上面的代码太乱了,看不清,整理一下,如下:
private void xpButton_login_Click(object sender, System.EventArgs e)
{
//logging....
string ls_username="";
string ls_passwd="";
SqlConnection sqlconn = new SqlConnection();
SqlCommand sqlcmd = new SqlCommand();
//读配置文件得到服务器名称,数据库等信息
GetPrivateProfileString("database","server","",Base.MainForm.gs_server,255,
Base.MainForm.gs_inipath);
GetPrivateProfileString("database","userid","",Base.MainForm.gs_logid,255,
Base.MainForm.gs_inipath);
GetPrivateProfileString("database","userid","",Base.MainForm.gs_logpass,255,
Base.MainForm.gs_inipath);
GetPrivateProfileString"database","database","",Base.MainForm.gs_database,255,
Base.MainForm.gs_inipath);
Base.MainForm.gs_connectstring = "Server="+Base.MainForm.gs_server+";"
+"User ID="+Base.MainForm.gs_logid+";"+
"database="+Base.MainForm.gs_database+";"+"Connect Timeout=30";
sqlconn.ConnectionString=Base.MainForm.gs_connectstring;
try
{
sqlconn.Open();
}
catch(SqlException err){
string errorMessages = "";
for (int i=0;i<err.Errors.Count;i++)
{
errorMessages += "Index #" + i + "\n" + "Message: " + err.Errors[i].Message + "\n" + "LineNumber: " + err.Errors[i].LineNumber + "\n" + "Source: " + err.Errors[i].Source + "\n" + "Procedure: " + err.Errors[i].Procedure + "\n";
}
MessageBox.Show(errorMessages,"提示信息",
MessageBoxButtons.OK,MessageBoxIcon.Stop);
return;
} sqlcmd.CommandText="Select username,passwd from sys_users where
userid='"+UserId.Text+"'";
sqlcmd.CommandTimeout=15;
sqlcmd.CommandType=CommandType.Text;
sqlcmd.Connection=sqlconn;
SqlDataReader sqldr ;
sqldr = sqlcmd.ExecuteReader();
try
{
if(sqldr.HasRows)
{
sqldr.Read();
if(!sqldr.IsDBNull(0))
ls_username = sqldr.GetString(0);
else
ls_username="";
if(!sqldr.IsDBNull(1))
ls_passwd = sqldr.GetString(1);
else
ls_passwd="";
Base.MainForm.gs_username=ls_username;
Base.MainForm.gs_userid=UserId.Text;
}
else
{
MessageBox.Show("没有数据!");
}
sqldr.Close();
sqlconn.Close();
}
catch(SqlException err)
{
string errorMessages = "";
for (int i=0;i<err.Errors.Count;i++)
{
errorMessages += "Index #" + i + "\n" + "Message: " + err.Errors[i].Message + "\n" + "LineNumber: " + err.Errors[i].LineNumber + "\n" + "Source: " + err.Errors[i].Source + "\n" + "Procedure: " + err.Errors[i].Procedure + "\n";
}
sqldr.Close();
sqlconn.Close();
MessageBox.Show(errorMessages,"提示信息",
MessageBoxButtons.OK,MessageBoxIcon.Stop);
return;
}
}
private void xpButton_login_Click(object sender, System.EventArgs e)
{
//logging....
string ls_username="";
string ls_passwd="";
SqlConnection sqlconn = new SqlConnection();
SqlCommand sqlcmd = new SqlCommand();
//读配置文件得到服务器名称,数据库等信息
GetPrivateProfileString("database","server","",Base.MainForm.gs_server,255,
Base.MainForm.gs_inipath);
GetPrivateProfileString("database","userid","",Base.MainForm.gs_logid,255,
Base.MainForm.gs_inipath);
GetPrivateProfileString("database","userid","",Base.MainForm.gs_logpass,255,
Base.MainForm.gs_inipath);
GetPrivateProfileString"database","database","",Base.MainForm.gs_database,255,
Base.MainForm.gs_inipath);
Base.MainForm.gs_connectstring = "Server="+Base.MainForm.gs_server+";"
+"User ID="+Base.MainForm.gs_logid+";"+
"database="+Base.MainForm.gs_database+";"+"Connect Timeout=30";
sqlconn.ConnectionString=Base.MainForm.gs_connectstring;
try
{
sqlconn.Open();
}
catch(SqlException err){
string errorMessages = "";
for (int i=0;i<err.Errors.Count;i++)
{
errorMessages += "Index #" + i + "\n" + "Message: " + err.Errors[i].Message + "\n" + "LineNumber: " + err.Errors[i].LineNumber + "\n" + "Source: " + err.Errors[i].Source + "\n" + "Procedure: " + err.Errors[i].Procedure + "\n";
}
MessageBox.Show(errorMessages,"提示信息",
MessageBoxButtons.OK,MessageBoxIcon.Stop);
return;
} sqlcmd.CommandText="Select username,passwd from sys_users where
userid='"+UserId.Text+"'";
sqlcmd.CommandTimeout=15;
sqlcmd.CommandType=CommandType.Text;
sqlcmd.Connection=sqlconn;
SqlDataReader sqldr ;
sqldr = sqlcmd.ExecuteReader();
try
{
if(sqldr.HasRows)
{
sqldr.Read();
if(!sqldr.IsDBNull(0))
ls_username = sqldr.GetString(0);
else
ls_username="";
if(!sqldr.IsDBNull(1))
ls_passwd = sqldr.GetString(1);
else
ls_passwd="";
Base.MainForm.gs_username=ls_username;
Base.MainForm.gs_userid=UserId.Text;
}
else
{
MessageBox.Show("没有数据!");
}
sqldr.Close();
sqlconn.Close();
}
catch(SqlException err)
{
string errorMessages = "";
for (int i=0;i<err.Errors.Count;i++)
{
errorMessages += "Index #" + i + "\n" + "Message: " + err.Errors[i].Message + "\n" + "LineNumber: " + err.Errors[i].LineNumber + "\n" + "Source: " + err.Errors[i].Source + "\n" + "Procedure: " + err.Errors[i].Procedure + "\n";
}
sqldr.Close();
sqlconn.Close();
MessageBox.Show(errorMessages,"提示信息",
MessageBoxButtons.OK,MessageBoxIcon.Stop);
return;
}
}
{
if(sqldr.HasRows)
{
sqldr.Read();
if(!sqldr.IsDBNull(0))
ls_username = sqldr.GetString(0);
else
ls_username="";
if(!sqldr.IsDBNull(1))
ls_passwd = sqldr.GetString(1);
else
ls_passwd="";
Base.MainForm.gs_username=ls_username;
Base.MainForm.gs_userid=UserId.Text;
}
else
{
MessageBox.Show("没有数据!");
}
}
catch(SqlException err)
{
string errorMessages = "";
for (int i=0;i<err.Errors.Count;i++)
{
errorMessages += "Index #" + i + "\n" + "Message: " + err.Errors[i].Message + "\n" + "LineNumber: " + err.Errors[i].LineNumber + "\n" + "Source: " + err.Errors[i].Source + "\n" + "Procedure: " + err.Errors[i].Procedure + "\n";
}
MessageBox.Show(errorMessages,"提示信息",
MessageBoxButtons.OK,MessageBoxIcon.Stop);
return;
}finally
{
sqldr.Close();
sqlconn.Close();}