Help with Connection script

Question

I have a connection script that I formated afer an article I just read but for some reason I cannot get it to exist error free. I am attempting to write a connection script for C#: SqlConnection sqlConn = new SqlConnection(server=local;uid=sa;pwd=;database=profile;); sqlConn.Open(); For what I think are obvious reasons I get build errors on all of the ; from inside the parenthesis. Can someone help me? Thank you. Regards Tim

sjones · Answer

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.

timothy.farrell · Answer

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();

timothy.farrell · Answer

Anyone... Please help.

timothy.farrell · Answer

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(InsertProfilesqlConn); 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

timothy.farrell · Answer

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

timothy.farrell · Answer

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

spgilmore · Answer

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

timothy.farrell · Answer

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

anu 0 · Answer

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

onthe_row · Answer

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?