ASPX.CS C# - How to read from a table in a database
SqlConnection conn = new SqlConnection("...");
conn.Open();
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT Description, Position FROM TableName";
cmd.CommandText = "SELECT Description, Position FROM TableName";
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Desc = Convert.ToString(dr["Description"]);
Pos = Convert.ToDouble(dr["Position"]);
{
Desc = Convert.ToString(dr["Description"]);
Pos = Convert.ToDouble(dr["Position"]);
...
}
}
dr.Close();
conn.Close()
conn.Close()
{moscomment}
| < Prev | Next > |
|---|





