where are SQL server database files located? - ASP.NET Discussion Boards

MathewPV30-Dec-09 17:57

30-Dec-09 17:57

i want to allow the user to enter apostrophe in the name entered in the text box.. it cant be given as e.KeyChar == '''. can somebody help me i am new to this..

Re: Validate name in text box

nagendrathecoder30-Dec-09 18:02

nagendrathecoder

30-Dec-09 18:02

Currently, how are you validating your textbox?

Re: Validate name in text box

MathewPV30-Dec-09 18:32

MathewPV

30-Dec-09 18:32

i have just started when i was writing the code it showed me this error

Re: Validate name in text box

dan!sh 30-Dec-09 18:13

dan!sh

30-Dec-09 18:13

\' maybe.

Why not use regular expression and do the validation in javascript?

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

steps for how to pass parameters to crystal report using text box or dropdownlist using asp.net with c#

developerit30-Dec-09 17:14

developerit

30-Dec-09 17:14

steps for how to pass parameters to crystal reports throug textbox or dropdownlist using asp.net with c#.net

in design time text box is not available in tool box how to take textbox or dropdownlist

Re: steps for how to pass parameters to crystal report using text box or dropdownlist using asp.net with c#

nagendrathecoder30-Dec-09 17:41

nagendrathecoder

30-Dec-09 17:41

Did you tried the solution given in your last post?
Are you facing any problem with that?

Search google, you'll find many examples of parameter passing to crystal reports.

Re: steps for how to pass parameters to crystal report using text box or dropdownlist using asp.net with c#

developerit30-Dec-09 20:50

developerit

30-Dec-09 20:50

in the tool box there is no textbox, dropdownlist controls then how to take values from these controls

where are SQL server database files located?

Seraph_summer30-Dec-09 9:10

Seraph_summer

30-Dec-09 9:10

I am using SQL SERVER to create a database, but I can not find the files in my PC.

if open it from SQL SERVER MANAGEMENT, it is shown as my-PC\SQLEXPRESS\database\system datatase\master\tables\dbo.TEST

actually TEST is one table I CREATEED. but I CAN NOT FIND IT IN THE EXPLORER.

who can tell me where is it located then?

thanks.

Re: where are SQL server database files located?

Ian McCaul30-Dec-09 9:33

Ian McCaul

30-Dec-09 9:33

First and foremost. Never add tables to the master database. Create a new database and add it there. For express the default data location is usually C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. Also, you cannot see specific tables in Windows Explorer, only the databases.

Re: where are SQL server database files located?

Christopher Duncan30-Dec-09 17:11

Christopher Duncan

30-Dec-09 17:11

I'm using the full version so there may be some differences in Express (I'm not familiar with that product). That said, one way to determine where your .mdf / .ldf files for your db are located is to script the database. Right click on the database you've created, select Script Database As from the popup menu.

You may have to follow slightly different steps in Express, but the general idea here is to generate a CREATE DATABASE script. Having done so, you'll notice something along these lines:

CREATE DATABASE [YourDbName] ON PRIMARY
( NAME = N'YourDbName', FILENAME = N'C:\Whatever\The\Path\Is\YourDbName.mdf' , SIZE = 45056KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )...

There's more to the script of course, but the FILENAME portion will show you exactly where the db file lives. Sql Server uses .mdf files for the database, and .ldf for the log. If you want to move it to a new directory, be sure to move both files.

Hope this helps -

Christopher Duncan
www.PracticalUSA.com
Author of The Career Programmer and Unite the Tribes
Copywriting Services

passing parameters to crystal report in asp.net with c#

developerit30-Dec-09 4:24

developerit

30-Dec-09 4:24

In my project i want to use crystal reports .but in crystal reports how to pass parameters(ie when user enters any no in textbox it

should display all deatails of that employe , and in dropdown list also the same )

Re: passing parameters to crystal report in asp.net with c#

Abhishek Sur30-Dec-09 4:45

Abhishek Sur

30-Dec-09 4:45

Check this.. You will get the idea ...

http://www.c-sharpcorner.com/Blogs/BlogDetail.aspx?BlogId=548[^]

Smile | :)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

Insertion Problem into Database

Zafar A khan 30-Dec-09 3:19

Zafar A khan

30-Dec-09 3:19

hi everyone.

i am inserting values in the table

the code.

<br />
SqlCommand com=new SqlCommand();<br />
con.Open();<br />
com.CommandText="insert into tbl([Name],FName,Address) values('Angelina','Carlos','sedny')";<br />
com.Connection=con;<br />
com.ExecuteNonQuery();<br />
con.Close();<br />

This code is running perfectly no Exception occurs no Error.
it is also returning the rows effected. But after successful execution
the values are not inserting in the database.
and when i run the same query in QueryAnalyzer it is ok and inserting the values but from the Ado.Net it is not working.
i don't understand this problem.
can anyone help me in this regard?
thanks in advance.

Re: Insertion Problem into Database

Abhishek Sur30-Dec-09 4:42

Abhishek Sur

30-Dec-09 4:42

Reconfirm if the connectionstring is perfect. I think it is inserting in some other database ...

If ADO.NET cannot insert in database, it will throw you an error. Poke tongue | ;-P

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Windows7 API Code Pack

Simplify Code Using NDepend
Basics of Bing Search API using .NET

Re: Insertion Problem into Database

Zafar A khan 30-Dec-09 5:00

Zafar A khan

30-Dec-09 5:00

sir thank you for your reply
i have checked the connectionstring it is ok.
and i have no other database with same name and table, columns
only the select query work.
nor update and nor delete and nor insert work.

Re: Insertion Problem into Database [modified]

sri_346430-Dec-09 6:37

sri_3464

30-Dec-09 6:37

Try inserting the data inside the transaction and commit the transaction in .net code

modified on Wednesday, December 30, 2009 12:48 PM

Re: Insertion Problem into Database

Venkatesh Mookkan30-Dec-09 15:34

Venkatesh Mookkan

30-Dec-09 15:34

Put a breakpoint in the con.Open() line and check the connection string property of connection object. Sometimes the connection string itself referring a wrong location.

As the other user said, ADO.NET will throw error if the execute fails. So, you must me referring a wrong database.

Zafar Ali Khan 1900 wrote:
com.CommandText="insert into <DATABASENAME>.dbo.tbl([Name],FName,Address) values('Angelina','Carlos','sedny')";

replace the <DATABASENAME> with your database name (Full qualifier name). This would help if two or more databases has table in same name and your connection string does not have any Initial Catalog mentioned (default is master database).

Better you post your connection string also

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

CITRIX

Sebastian T Xavier30-Dec-09 1:22

Sebastian T Xavier

30-Dec-09 1:22

Hello,

I have a CITRIX client application. usually I invoke it by clicking the shortcut in the desktop. Now, I would like to invoke this application from a web page (from my mail box). How can I accomplish this. Any help would be appreciated.

Thanks for your time

Sebastian

Re: CITRIX

Abhijit Jana30-Dec-09 2:26

Abhijit Jana

30-Dec-09 2:26

Check my answer over
here[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: CITRIX

Sebastian T Xavier30-Dec-09 2:51

Sebastian T Xavier

30-Dec-09 2:51

Thanks...let me try that

Re: CITRIX

Abhijit Jana30-Dec-09 17:45

Abhijit Jana

30-Dec-09 17:45

Let me know if you have any issue

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

How to call the WSDL file in ASp.Net 3.5

somagunasekaran30-Dec-09 1:08

somagunasekaran

30-Dec-09 1:08

Hi All,

Please give me idea..
How to call the webservice through WSDL file in ASP.Net
Actually i have WSDL file..Please give me any sample applications

Confused | :confused:

Regards
Somasundaram

I want to join in the website

Re: How to call the WSDL file in ASp.Net 3.5

Abhijit Jana30-Dec-09 2:18

Abhijit Jana

30-Dec-09 2:18

somagunasekaran wrote:
How to call the webservice through WSDL file in ASP.Net

I didnt get your point.

You need to consume web services only. If you are using Visuals studio, Go to your web Application > Right Click > Add Web Reference > Give the web service url

Then you need to create the object to call methods !

Let me know if you have further issue Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Opening new window using shortcut key

Karan_TN30-Dec-09 0:54

Karan_TN

30-Dec-09 0:54

hai,
currently i m using asp.net 2.0 (C#)
i m trying to open a new popup window (or window) so as to display the project developer name and his information. But this has to be popup'ed only when user press some key combinations (say.. ctrl+d). i tried this by assigning accesskey to a button and redirected. but while i hide that button the shortcut does'nt work..

is there any other way to achieve it?
help me.... - Karan

Re: Opening new window using shortcut key

m-khansari30-Dec-09 20:09

m-khansari

30-Dec-09 20:09

Hi
How do you hide the button?

if you set Visible to false the button's does not be inserted into page

you should hide the button using javascript code and css property.

Mohammad Khansari

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.