Help with Connection script

You declared the variable in the first function, then tried to use it in another. You need to move the declaration outside of the function. It's a scope problem.

I do realize that I forgot to put in the execute and close commands in the above as well. Sorry about that. com.ExecuteNonQuery(); sqlConn.Close();

Anyone... Please help.

Perhaps I spoke too fast. Could someone help me with the onclick script? private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here SqlConnection sqlConn = new SqlConnection("server=C099450d01;uid=sa;pwd=;database=WebTimeSheet"); sqlConn.Open(); } #region Web Form Designer generated code public void AddProfile_Click(Object sender, EventArgs E) { SqlCommand com = new SqlCommand("InsertProfile",sqlConn); com.CommandType = CommandType.StoredProcedure; } The error I am getting is: The name 'sqlConn' does not exist in the class or namespace 'TimeSheet1.Profile' This error is referring to the last sqlConn above. Any ideas? Sincerely, Tim

Ignore last post. I figured out what I was doing wrong. Wrong placement of script. Thank you all once again for your help. Sincerely, Tim

spgilmore, That worked for the first line. Great and Thank you. However, the second line is now generating an error: sqlConn.Open(); Invalid token '(' in class, struct, or interface member declaration Any further ideas? Thank you again for your help. Sincerely, Tim

Quote it and lose the last semicolon. SqlConnection sqlConn = new SqlConnection("server=local;uid=sa;pwd=;database=profile");

jcf, There was no distinct error given in as much as a coding alarm in the form of a red squiggly red line under each ";". If you place your pointer over the squiggly lines the comment is: ) is expected. Invalid token ";" in class, struct, or interface member declaration Invalid token "=" in class, struct, or interface member declaration Perhaps what I should do is post the article the information was taken from: http://www.developerfusion.com/scripts/print?id=4278 If you view the connection string script provided for C# you will see the script I have posted. My question was, is this a mistake in code and if so what format should I use. Thank you for your thoughts. Regards, Tim

Hi Tim, Just give the connection string in double quotes ("). If there are any special characters, just give a @ character at the beginning. Something like this: SqlConnection sqlConn = new SqlConnection(@"server=local;uid=sa;pwd=;database=profile;"); sqlConn.Open(); Regards, Ann Catherine Jose http://www.chiramattel.com/ann

It would be much easier to keep track of your error if you're also going to post it here. What's the error message anyway?