check out this link ..hope it will help u... http://aspnet.4guysfromrolla.com/articles/062905-1.aspx regards Ramesh
V
VenkataRamesh
@VenkataRamesh
Posts
-
Help me with this Pl/Sql procedure (ORACLE 9i) call from asp.net -
How can I use a connection string stored in the web.config filehow r u connecting to sqlserver? windows authentication.... just paste the connection string and ur code.. i will let u know any prob's in that..
-
How can I use a connection string stored in the web.config fileare you running on a sql Server? If so shouldn't you do any authentication? User Id=;Password=; check out the connection string in web.config
-
How can I use a connection string stored in the web.config fileDim sConn As String sConn = ConfigurationSettings.AppSettings("SQLConString") Dim con As New System.Data.SqlClient.SqlConnection(sConn) Dim selectCMD As SqlCommand = New SqlCommand("SELECT * FROM Customers", con) selectCMD.CommandTimeout = 30 Dim custDA As SqlDataAdapter = New SqlDataAdapter custDA.SelectCommand = selectCMD con.Open() Dim custDT As DataTable = New DataTable custDA.Fill(custDT, "Customers") con.Close() Now u have customers table in custDT .. Regards, Ramesh.
-
Clearing textbox on focusHi Look at this link.. http://weblogs.asp.net/dburke/archive/2003/10/01/29959.aspx Hope it will work for u Bye...