C Sharp sql connection

Question

0.00/5 (No votes)

See more:

In the server(SQL Server-2005) I have two database. They are TERMSUS and TERMSSUP.
In the following codes when I close the connection for TERMSUS then run a select query from another database and that is TERMSSUP. After the select query I open the connection for TERMSSUP. Can anyone help me about connection? How can the second select query execute before opening the connection?

C#

ConManager.DBConnection("TERMSUS");
DataTable DTLocalEmp = new DataTable();
string EmpCode = string.Empty;
string strSQLE = "select EmpCode from tblUser where UserLoginId='"+Session["USER"].ToString()+"'";
ConManager.OpenDataTableThroughAdapter(strSQLE, out DTLocalEmp, true);
ConManager.CloseConnection();
EmpCode = DTLocalEmp.Rows[0]["EmpCode"].ToString();
strSQL = "";
strSQL = "select * from tblSheduleEntry where EmpCode='" + EmpCode + "'";
ConManager.DBConnection("TERMSSUP");
DataTable DTLocal = new DataTable();
ConManager.OpenDataTableThroughAdapter(strSQL, out DTLocal, true);
DTLocal.TableName = "Shedule";

Posted 5-Jun-13 0:22am

Sumon562

Updated 5-Jun-13 0:32am

Oshtri Deka

v3

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Oshtri Deka · Answer 1 · 2013-06-05T00:41:00

Solution 1

It doesn't.
Check my comments.

C#

//here you define command text
strSQL = "select * from tblSheduleEntry where EmpCode='" + EmpCode + "'";

//here you open your connection
ConManager.DBConnection("TERMSSUP");
DataTable DTLocal = new DataTable();

//and then you actually execute your query
ConManager.OpenDataTableThroughAdapter(strSQL, out DTLocal, true);
DTLocal.TableName = "Shedule";

Also you should know that:
In Visual studio right click in code editor gives you context menu with standard actions.
Two of particular interest are Go to definition and Find all references.
Right click on above methods and explore!

Good luck!

Posted 5-Jun-13 0:41am

Oshtri Deka

Updated 5-Jun-13 1:32am

v2

Comments

Sumon562 5-Jun-13 6:53am

Thank you Mr. Oshtri Deka.

Oshtri Deka 6-Jun-13 13:17pm

If you like this answer, up-vote and solution acceptance would be nice.

Sumon562 5-Jun-13 7:35am

Can you help me please How can I find Visual Studio code editor. I can not find out Go to definition and Find all references.

Oshtri Deka 5-Jun-13 15:41pm

Right click on any object inside code (while in Visual Studio), for instance right click on OpenDataTableThroughAdapter method. That action will open context menu with above mentioned actions.

C Sharp sql connection

1 solution

Solution 1

Add your solution here

Preview 0

C Sharp sql connection

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us