| | |
Loading Database data into Labels for viewing?
Please support our C# advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Oct 2008
Posts: 32
Reputation:
Solved Threads: 4
Hi
SqlConnection ObjConn = new SqlConnection(ConnectionString);
if (ObjConn.State != ConnectionState.Open)
{
ObjConn.Open();
}
SqlDataAdapter ObjSqlDataAdapter = new SqlDataAdapter(CommandText, ObjConn);
Ds = new DataSet();
ObjSqlDataAdapter.Fill(Ds);
if (ObjDs.Tables[0].Rows.Count > 0)
{
label1.Text = ObjDs.Tables[0].Rows[rowindex][columnname].toString();
-
-
}
ObjDs.Dispose();
ObjConn.Close();
ObjConn.Dispose();
SqlConnection ObjConn = new SqlConnection(ConnectionString);
if (ObjConn.State != ConnectionState.Open)
{
ObjConn.Open();
}
SqlDataAdapter ObjSqlDataAdapter = new SqlDataAdapter(CommandText, ObjConn);
Ds = new DataSet();
ObjSqlDataAdapter.Fill(Ds);
if (ObjDs.Tables[0].Rows.Count > 0)
{
label1.Text = ObjDs.Tables[0].Rows[rowindex][columnname].toString();
-
-
}
ObjDs.Dispose();
ObjConn.Close();
ObjConn.Dispose();
![]() |
Other Threads in the C# Forum
- Previous Thread: transfer contends from database table to excel
- Next Thread: Looking for a project to join
Views: 898 | Replies: 4
| Thread Tools | Search this Thread |
Tag cloud for C#
.net access ado.net algorithm array barchart bitmap box broadcast button c# chat check checkbox class client code color combobox control conversion csharp custom database datagrid datagridview dataset datetime degrees development draganddrop drawing encryption event excel file files form format forms ftp function gcd gdi+ http httpwebrequest image index input install java label list listbox listener login math mouseclick mysql networking object operator path photoshop picturebox pixelinversion post prime programming radians regex remote remoting resource saving serialization server sleep socket sql statistics stream string tcp text textbox thread time timer treeview update usercontrol validation view visualstudio webbrowser windows winforms wpf xml






