public int Search_uid(string name)
{
int list = -1;
string ConnectionString = db.strconn;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConnectionString;
string cmdText = "select * from tb_user where uname='" + name + "'";
SqlCommand cmd = new SqlCommand(cmdText, con);
try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
list = Convert.ToInt32(dr["ID"]);
}
}
dr.Close();
}
catch (Exception ex)
{
}
con.Close();
return list;
}
{
int list = -1;
string ConnectionString = db.strconn;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConnectionString;
string cmdText = "select * from tb_user where uname='" + name + "'";
SqlCommand cmd = new SqlCommand(cmdText, con);
try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
list = Convert.ToInt32(dr["ID"]);
}
}
dr.Close();
}
catch (Exception ex)
{
}
con.Close();
return list;
}