Automatically Detect sql Database

Question

what is the code to automatically detect sql database in Any System.

Vijay Yadav · Answer

Hi, Try this, string strCon = "Data Source=.\SQLExpress;AttachDBFilename=|DataDirectory|db_name.mdf;integrated security=true;" and place the database file inside bin folder if you are using window application, if you are using web application then place in App_Data folder.

Mayur Gujrathi · Answer

Add name space of system.data.oledb This will test the connection of oracle database private void button1_Click(object sender, EventArgs e) { oracon = new OleDbConnection("Provider=Msdaora;User Id=Scott;Password=tiger"); oracon.Open(); MessageBox.Show(oracon.State.ToString()); oracon.Close(); MessageBox.Show(oracon.State.ToString()); } this will test the connection of sql server database private void button2_Click(object sender, EventArgs e) { sqlcon = new OleDbConnection(); sqlcon.ConnectionString = "Provider=SQLOLEDB;User Id=citrus_usr;Password=surtic;Database=DEMAT;Data Source=server"; sqlcon.Open(); MessageBox.Show(sqlcon.State.ToString()); sqlcon.Close(); MessageBox.Show(sqlcon.State.ToString()); }

Shalini Juneja · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} C# // Connection strings shouldn't be hardcoded for production code using(SqlConnection conn = new SqlConnection( "server=MyServer; database=AdventureWorks; user id=MyUser; password=MyPassword")) { conn.Open(); SqlCommand cmd = new SqlCommand( "SELECT Name, GroupName FROM HumanResources.Department", conn); SqlDataReader r = cmd.ExecuteReader(); while(r.Read()) { // Consume the data from the reader and perform some computation with it } } Visual Basic .NET Dim cmd as SqlCommand Dim r as SqlDataReader ' Connection strings shouldn't be hardcoded for production code Using conn As New SqlConnection( _ "server=MyServer; database=AdventureWorks; user id=MyUser; password=MyPassword") conn.Open() cmd = New SqlCommand("SELECT Name, GroupName FROM HumanResources.Department", conn) r = cmd.ExecuteReader() Do While r.Read() ' Consume the data from the reader and perform some computation with it Loop End Using Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} This sample uses the System.Data.SqlClient provider to connect to SQL Server. Note that if this code runs inside SQLCLR, it would be connecting from the SQL Server that hosts it to another SQL Server. You can also connect to different data sources. For example, you can use the System.Data.OracleClient provider to connect to an Oracle server directly from inside SQL Server. Hope this will help you

Automatically Detect sql Database

Answers (3)