SqlConnection myConnection = new SqlConnection("Server=dz;UID=sa;PWD=;Pooling=True");
myConnection.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter("Select * From User_Login Where User_name='"+User_Name+"'",myConnection);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
myConnection.Open();
SqlDataAdapter myAdapter = new SqlDataAdapter("Select * From User_Login Where User_name='"+User_Name+"'",myConnection);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
myConnection.Open();
SqlCommand myCmd = new SqlCommand("Select * From User_Login Where User_name='"+User_Name+"'",myConnection);
try
{
if(myCmd.ExecuteScalar() != null)
{
//成功
}
else
{
//不成功
}
}
finally
{
myCmd.Close();
}