ASP.NET(vb.net) & SQL Server List Field Name - This is example scripts how to use ASP.NET get a field name from SQL Server database.
ShotDev Focus:
- ASP.NET(vb.net) & SQL Server List Field Name
Example
AspNetSQLServerListFields.aspx
<%@ Import Namespace="System.Data"%> <%@ Import Namespace="System.Data.SqlClient"%> <%@ Page Language="VB" %> <script runat="server"> Dim objConn As SqlConnection Dim objCmd As SqlCommand Sub Page_Load(sender As Object, e As EventArgs) Dim strConnString As String strConnString = "Server=localhost;Uid=sa;PASSWORD=;database=mydatabase;Max Pool Size=400;Connect Timeout=600;" objConn = New SqlConnection(strConnString) objConn.Open() BindData() End Sub Sub BindData() Dim strSQL As String Dim i As Integer strSQL = "SELECT * FROM customer " Dim dtReader As SqlDataReader objCmd = New SqlCommand(strSQL, objConn) dtReader = objCmd.ExecuteReader() Me.lblText.Text = "<b>Table customer have " & dtReader.FieldCount & " Fields</b>" For i = 0 To dtReader.FieldCount - 1 Me.lblText.Text = Me.lblText.Text & "<br>" & dtReader.GetName(i) Next dtReader.Close() dtReader = Nothing End Sub Sub Page_UnLoad() objConn.Close() objConn = Nothing End Sub </script> <html> <head> <title>ShotDev.Com Tutorial</title> </head> <body> <form id="form1" runat="server"> <asp:Label id="lblText" runat="server"></asp:Label> </form> </body> </html>
Screenshot
2subjugate…
…