string myConnectString = "user id=sa;password=;initial catalog=northwind;data source=mySQLServer;Connect Timeout=30";
SqlConnection myConnection = new SqlConnection(myConnectString);
myConnection.Open();
SqlConnection myConnection = new SqlConnection(myConnectString);
myConnection.Open();
public DataView bbsadmin_select(string user_id,string oskey)
{
SqlConnection myConn=new SqlConnection(myConnectString);
SqlDataAdapter adapt=new SqlDataAdapter("select * from bbsadmin where user_id=@m_user_id and oskey=@m_oskey",myConn);
adapt.SelectCommand.Parameters.Add(new SqlParameter("@m_user_id", SqlDbType.NVarChar,50)).Value=user_id;
adapt.SelectCommand.Parameters.Add(new SqlParameter("@m_oskey", SqlDbType.NVarChar,50)).Value=oskey;
DataTable dt = new DataTable();
adapt.Fill(dt);
return dt.DefaultView;
}