c# query to get sql server name at runtime

[shyam akola]

Hello......
i want to use sql server as my database in c#.net for that i want sql server connection string & i also want that if it is possible then query for get automatically connection string at run time or globle query for that.Give me reply as fast as possible...

thank you.

[ck9663]

It's more of a C#.net question than a SQL Server question.

Happy Coding!!!

~~ CK

[nbiswas]

private string strConnection = @"Data Source=xxx;Init ial Catalog=xxx;Int egrated Security=True";

SqlConnection objConnection = new SqlConnection(s trConnection);
objConnection.O pen();
SqlCommand objCommand = new SqlCommand("ins ert into tblDummy(Name,C ode) values('xxx','x xx')",objConnec tion);
objCommand.Exec uteNonQuery();
objConnection.C lose();