private void DataLoad() { List <TblStudent> list = new List <TblStudent>(); string constr = "Data Source=DESKTOP-J4JFLTU\\SQLEXPRESS;Initial Catalog=MyFirstDataBase;Integrated Security=True"; using (SqlConnection con = new SqlConnection(constr)) { string sql = "select * from TblStudent"; using (SqlCommand cmd = new SqlCommand(sql, con)) { con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { TblStudent model = new TblStudent(); model.tsid = reader.GetInt32(0); model.tsname = reader.GetString(1); model.tsgender = reader.IsDBNull(2)?null:reader.GetString(2); model.tsaddress = reader.IsDBNull(3) ? null : reader.GetString(3); model.tsage = reader.IsDBNull(4) ? null : (int?)reader.GetInt32(4); model.tsbirthday = reader.IsDBNull(5) ? null :(DateTime?)reader.GetDateTime(5); model.tscardid = reader.IsDBNull(6) ? null : reader.GetString(6); model.tsclassid = reader.GetInt32(7); list.Add(model);//添加到集合中 } } } } } this.dgvStudent.DataSource = list;//调用集合显示,即为绑定技术 }
private void m_update_Click(object sender, EventArgs e) { string constr = "Data Source=DESKTOP-J4JFLTU\\SQLEXPRESS;Initial Catalog=MyFirstDataBase;Integrated Security=True"; using (SqlConnection con = new SqlConnection(constr)) { TblStudent model = new TblStudent(); model.tsname = textedittsName.Text.Trim(); model.tsgender = textedittsGender.Text.Trim().Length == 0 ? null : textedittsGender.Text.Trim(); model.tsaddress = textedittsAddress.Text.Trim().Length == 0 ? null : textedittsAddress.Text.Trim(); model.tsage = textedittsAge.Text.Trim().Length == 0?null:(int?)Convert.ToInt32(textedittsAge.Text.Trim()); model.tsbirthday = textedittsBirthday.Text.Trim().Length == 0 ? null : (DateTime?)Convert.ToDateTime(textedittsBirthday.Text.Trim()); model.tscardid = textedittsCardid.Text.Trim(); model.tsclassid = textedittsClassid.Text.Trim().Length == 0?null:(int?)Convert.ToInt32(textedittsClassid.Text.Trim()); model.tsid = Convert.ToInt32(lbuptsid.Text.Trim()); string sql = string.Format("update Tblstudent set tsName='{0}',tsgender='{1}',tsaddress='{2}',tsage={3},tsbirthday='{4}',tscardid='{5}',tsclassid={6} where tsid={7} " , model.tsname, model.tsgender, model.tsaddress, model.tsage , model.tsbirthday, model.tscardid, model.tsclassid, model.tsid); using (SqlCommand cmd = new SqlCommand(sql, con)) { con.Open(); int r = cmd.ExecuteNonQuery(); this.Text = "更新了" + r + "行数据"; DataLoad(); } } }
private void dgvStudent_RowEnter(object sender, DataGridViewCellEventArgs e) { DataGridViewRow currentRow = this.dgvStudent.Rows[e.RowIndex]; //获取当前选中行对象 TblStudent model = currentRow.DataBoundItem as TblStudent; //获取当前选中行对象中的数据信息 if (model != null) { lbuptsid.Text = Convert.ToString(model.tsid); textedittsName.Text = model.tsname; textedittsGender.Text = model.tsgender; textedittsAddress.Text = model.tsaddress; textedittsAge.Text = Convert.ToString(model.tsage); textedittsBirthday.Text = Convert.ToString(model.tsbirthday); textedittsCardid.Text = model.tscardid; textedittsClassid.Text = Convert.ToString(model.tsclassid); } }
private void m_lookup_Click(object sender, EventArgs e) { List <TblStudent> list1 = new List <TblStudent>(); string constr = "Data Source=DESKTOP-J4JFLTU\\SQLEXPRESS;Initial Catalog=MyFirstDataBase;Integrated Security=True"; using (SqlConnection con = new SqlConnection(constr)) { int tsid = Convert.ToInt32(textlptsid.Text.Trim()); string sql = string.Format("select * from tblstudent where tsid={0}", tsid); using (SqlCommand cmd = new SqlCommand(sql, con)) { con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { TblStudent model = new TblStudent(); model.tsid = reader.GetInt32(0); model.tsname = reader.GetString(1); model.tsgender = reader.GetString(2); model.tsaddress = reader.GetString(3); model.tsage = reader.GetInt32(4); model.tsbirthday = reader.GetDateTime(5); model.tscardid = reader.GetString(6); model.tsclassid = reader.GetInt32(7); list1.Add(model); } } else { MessageBox.Show("数据库中没有此信息"); } } } } this.dgvStudent.DataSource = list1; }