My computer is telling me lies is it
![]()
i have this in the webconfig
VB Code:
<appSettings> <add key = "oSQLConn" value="server=localhost;database=StoreProc;integrated security=SSPI"/> </appSettings>
this in my code behind
VB Code:
Public Sub getuser() oSQLConn1 = New SqlConnection(ConfigurationSettings.AppSettings("oSQLConn")) strSql = "EXECUTE sprShowUsers" objCmd = New SqlCommand(strSql, oSQLConn1) 'Try oSQLConn1.Open() dataReader = objCmd.ExecuteReader() 'bind to datagrid dgUsers.DataSource = dataReader dgUsers.DataBind() 'Catch ex As Exception 'Finally oSQLConn1.Close() 'oSQLConn.Dispose() ' End Try
this is my stored procedure
im trying to fill a datagrid and learn how to use stored proceduresCode:CREATE PROCEDURE sprShowUsers as select towm from tbUser order by carreg GO
i have got my users for asp.net and isur in my database also
cant figure out the problem![]()
thanks




My computer is telling me lies is it
Reply With Quote