Re: Insertion Problem into Database - ASP.NET Discussion Boards

Re: where are SQL server database files located?

Christopher Duncan30-Dec-09 17:11

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

Re: Opening new window using shortcut key

Karan_TN31-Dec-09 0:13

Karan_TN

31-Dec-09 0:13

how to do this?
i found we can hide the button using

document.getElementById('Button1').style.visibility='hidden';

but i need to use this in page load in ASCX page. how to use it.

Re: Opening new window using shortcut key

m-khansari1-Jan-10 18:21

m-khansari

1-Jan-10 18:21

It's better to use display stead of visibility

insert following code in Page_Load

hide the button

this.Button1.Style.Add("display", "none");

show the button

this.Button1.Style.Add("display", "inline");

hope to be useful for you

Mohammad Khansari

get left position of the panel

S.Aijaz30-Dec-09 0:44

S.Aijaz

30-Dec-09 0:44

i have to get left position of the panel on pageload. i do get dat by playing a trick, but wt problem now i face is im not able to put dat value in the hidden control. below is code that i use for the purpose:

string strJS = @" <script language='javascript' type='text/javascript'> intWidth = document.body.clientWidth;intHeight = document.body.clientHeight;intWidth = (intWidth* 15/100);document.getElementById('<% =HpnlCtrlLeftPos.ClientID %>').value=intWidth; alert('Width : '+ intWidth +' Height : ' + intHeight); </script>";

Page.ClientScript.RegisterStartupScript(this.GetType(), "ScreenPosition", strJS);

it throws exception

can any body help me............

Re: get left position of the panel

ProtoBytes30-Dec-09 8:09

ProtoBytes

30-Dec-09 8:09

The exception thrown might help to solve the problem...

Re: get left position of the panel

Venkatesh Mookkan30-Dec-09 15:41

Venkatesh Mookkan

30-Dec-09 15:41

S_Aijaz1 wrote:
string strJS = @" intWidth = document.body.clientWidth;intHeight = document.body.clientHeight;intWidth = (intWidth* 15/100);document.getElementById('<% =HpnlCtrlLeftPos.ClientID %>').value=intWidth; alert('Width : '+ intWidth +' Height : ' + intHeight); ";

Page.ClientScript.RegisterStartupScript(this.GetType(), "ScreenPosition", strJS);

Try this,

string strJS = @" intWidth = document.body.clientWidth;intHeight = document.body.clientHeight;intWidth = (intWidth* 15/100);document.getElementById('<% =HpnlCtrlLeftPos.ClientID %>').value=intWidth; alert('Width : '+ intWidth +' Height : ' + intHeight); ";

Page.ClientScript.RegisterStartupScript(this.GetType(), "ScreenPosition", strJS, true);

if this doesn't help, post the error message you getting.

Castle Rider

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

My: Website | Yahoo Group | Blog Spot

Re: get left position of the panel

S.Aijaz31-Dec-09 20:42

S.Aijaz

31-Dec-09 20:42

thank you sir, i have have tried dis as well but it is not working, at page load it does nt find the hidden control

C# code behind the login page if u drag the login from toolbox

Tanzeel Altaf29-Dec-09 22:45

Tanzeel Altaf

29-Dec-09 22:45

I am working on a web application and newly entered in the developement field.
I need your help in the completion of this application.I want complete code behind the
login page means what will be classes we will have to declare,Integration with master page,
Navigation and creating,access to db.
Thanks

Re: C# code behind the login page if u drag the login from toolbox

nagendrathecoder29-Dec-09 22:50

nagendrathecoder

29-Dec-09 22:50

Did you searched on google, you'll find many examples if you spend just 5 minutes for searching it.

aspnet_regsql.exe

mylogics29-Dec-09 22:11

mylogics

29-Dec-09 22:11

one of my site is running online.I want to configure my online sql server database for application services.I know to do it locally but dont know how to do online.i did following steps:
>i selected configure sql server for application services.
>give database name and selected sql server authentication mode,give username and password
>but it does not show the list of database n shows error:
"failed to query list of database name from sqlserver.login failed for user.
the user is not associated with trusted sql server connection."

Tell me what to do n where m i wrong....thank's

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