这一路码来,求指点方向。
回忆码农这一道、基本可以用正文的代码概括。
现遭遇1年之痒,有些迷茫,有些疲惫。求大神指引。
看别人共享的代码和论道,感觉都好有深度哦~~。
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
/// *****************大二时候码的代码***********************
protected void Button1_Click(object sender, EventArgs e)
{
string connString = "data source =.;user id =sa;password=123456;";
SqlConnection sConn = new SqlConnection(connString);
sConn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from user", sConn);
DataSet ds = new DataSet();
sda.Fill(ds, "用户表");
GridView1.DataSource = ds;
GridView1.DataMember = ds.Tables[0].TableName;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
string connString = "data source =.;user id =sa;password=123456;";
SqlConnection sConn = new SqlConnection(connString);
sConn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from user", sConn);
DataSet ds = new DataSet();
sda.Fill(ds, "用户表");
GridView1.DataSource = ds;
GridView1.DataMember = ds.Tables[0].TableName;
GridView1.DataBind();
}
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
///*****************大四毕业设计时候用的代码*****************
protected void Button1_Click(object sender, EventArgs e)
{
SQLHelper sqlHelper = new SQLHelper();
string cmd = "select * from user where username ='" + TextBox1.Text + "'";
DataSet ds = new DataSet();
ds = sqlHelper.SearchData(cmd);
GridView1.DataSource = ds;
GridView1.DataMember = ds.Tables[0].TableName;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
SQLHelper sqlHelper = new SQLHelper();
string cmd = "select * from user where username ='" + TextBox1.Text + "'";
DataSet ds = new DataSet();
ds = sqlHelper.SearchData(cmd);
GridView1.DataSource = ds;
GridView1.DataMember = ds.Tables[0].TableName;
GridView1.DataBind();
}
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
///*******************入职培训后用的代码****************
#region 事件
#region 根据检索条件检索用户信息
/// <summary>
/// 根据检索条件检索用户信息
/// </summary>
protected void btnSearchUserInfo_Click(object sender, EventArgs e)
{
try
{
SQLHelper sqlHelper = new SQLHelper();
string strUserName = txtUserName.Text.Trim();//用户姓名
string strDepartmentName = txtDepartmentName.Text.Trim();//用户所属部门
string cmd = string.Format("select * from D_1_User where vcUserName like '%{0}%' and vcDepartment like '%{1}% '", strUserName, strDepartmentName);
DataTable dtUser = new DataTable();
dtUser = sqlHelper.SearchByCMDText(cmd);
gvUser.DataSource = dtUser;
gvUser.DataBind();
}
catch (Exception ex)
{
this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
}
}
#endregion
#endregion
#region 事件
#region 根据检索条件检索用户信息
/// <summary>
/// 根据检索条件检索用户信息
/// </summary>
protected void btnSearchUserInfo_Click(object sender, EventArgs e)
{
try
{
SQLHelper sqlHelper = new SQLHelper();
string strUserName = txtUserName.Text.Trim();//用户姓名
string strDepartmentName = txtDepartmentName.Text.Trim();//用户所属部门
string cmd = string.Format("select * from D_1_User where vcUserName like '%{0}%' and vcDepartment like '%{1}% '", strUserName, strDepartmentName);
DataTable dtUser = new DataTable();
dtUser = sqlHelper.SearchByCMDText(cmd);
gvUser.DataSource = dtUser;
gvUser.DataBind();
}
catch (Exception ex)
{
this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
}
}
#endregion
#endregion
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
///*******************转正后码的代码****************
#region 事件
#region 根据检索条件检索用户信息
/// <summary>
/// 根据检索条件检索用户信息
/// </summary>
protected void btnSearchUserInfo_Click(object sender, EventArgs e)
{
try
{
string strUserName = txtUserName.Text.Trim();//用户姓名
string strDepartmentID = ddlDepartment.SelectedValue;//用户所属部门ID
DataTable dtUser = SearchUserInfo(strUserName, strDepartmentID);//获取用户数据
BindGridView(dtUser);//绑定用户数据到GridView
}
catch (Exception ex)
{
this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
}
}
#endregion
#endre
#region 事件
#region 根据检索条件检索用户信息
/// <summary>
/// 根据检索条件检索用户信息
/// </summary>
protected void btnSearchUserInfo_Click(object sender, EventArgs e)
{
try
{
string strUserName = txtUserName.Text.Trim();//用户姓名
string strDepartmentID = ddlDepartment.SelectedValue;//用户所属部门ID
DataTable dtUser = SearchUserInfo(strUserName, strDepartmentID);//获取用户数据
BindGridView(dtUser);//绑定用户数据到GridView
}
catch (Exception ex)
{
this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
}
}
#endregion
#endre
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
///*******************毕业一年后的现在*********************
#region 事件
#region 根据检索条件检索用户信息
/// <summary>
/// 根据检索条件检索用户信息
/// </summary>
protected void btnSearchUserInfo_Click(object sender, EventArgs e)
{
try
{
string strEmployeeName = txtEmployeeName.Text.Trim();//员工姓名
string strEmployeeID = txtEmployeeID.Text.Trim();//员工编号
string strDepartmentID = ddlDepartment.SelectedValue;//用户所属部门ID
string strAge= txtAge.Text.Trim();//年龄
D_1_Entity d_1_Entity = new D_1_Entity();//用户实体初始化
d_1_Entity._EmployeeName = strEmployeeName;
d_1_Entity._EmployeeID = strEmployeeID;
d_1_Entity._DepartmentID = strDepartmentID;
d_1_Entity._Age = strAge;
DataTable dtUser = d_1_Entity.GetData();//获取用户数据
BindGridView(dtUser);//绑定用户数据到GridView
}
catch (NoteException ex)
{
this.ShowMessageBox(ex, MessageType.FailedSearch);
}
catch (Exception ex)
{
this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
}
}
#endregion
#endregion
#region 事件
#region 根据检索条件检索用户信息
/// <summary>
/// 根据检索条件检索用户信息
/// </summary>
protected void btnSearchUserInfo_Click(object sender, EventArgs e)
{
try
{
string strEmployeeName = txtEmployeeName.Text.Trim();//员工姓名
string strEmployeeID = txtEmployeeID.Text.Trim();//员工编号
string strDepartmentID = ddlDepartment.SelectedValue;//用户所属部门ID
string strAge= txtAge.Text.Trim();//年龄
D_1_Entity d_1_Entity = new D_1_Entity();//用户实体初始化
d_1_Entity._EmployeeName = strEmployeeName;
d_1_Entity._EmployeeID = strEmployeeID;
d_1_Entity._DepartmentID = strDepartmentID;
d_1_Entity._Age = strAge;
DataTable dtUser = d_1_Entity.GetData();//获取用户数据
BindGridView(dtUser);//绑定用户数据到GridView
}
catch (NoteException ex)
{
this.ShowMessageBox(ex, MessageType.FailedSearch);
}
catch (Exception ex)
{
this.RecordLogsAndShowMessageBox(ex, LogType.ApplicationError, MessageType.FailedSearch);
}
}
#endregion
#endregion
有码一堆兮,过目即忘。一日不见兮,思之如狂。
凤求翱翔兮,四海求凰。无奈佳人兮,不在东墙。