?? ysheng.aspx.cs
字號:
this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@職務", System.Data.SqlDbType.NVarChar, 20));
this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@電話", System.Data.SqlDbType.NVarChar, 20));
this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@郵箱", System.Data.SqlDbType.NVarChar, 20));
this.cmd2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@家庭地址", System.Data.SqlDbType.NVarChar, 50));
this.Button8.Click += new System.EventHandler(this.Button8_Click);
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dsa1)).EndInit();
}
#endregion
private void fills()
{
if(cnn.State==0) cnn.Open();
sda.SelectCommand.ExecuteNonQuery();
dsa1.Clear();
sda.Fill(dsa1);
cnn.Close();
DataGrid1.DataBind();
}
private void Button1_Click(object sender, System.EventArgs e)
{
if(cnn.State==0) cnn.Open();
sda1.SelectCommand.Parameters["@sel"].Value=TextBox1.Text;
sda1.SelectCommand.Parameters["@name"].Value=TextBox2.Text;
sda1.SelectCommand.ExecuteNonQuery ();
this.dsa1.Clear();
this.sda1.Fill(dsa1);
this.DataGrid1.DataBind();
cnn.Close();
}
private void Button2_Click(object sender, System.EventArgs e)
{
Panel2.Visible =true;
Submit.Visible =false;
}
private void Button5_Click(object sender, System.EventArgs e)
{
Panel1.Visible =true;
// this.DataGrid1.SelectedIndex=-1;
}
private void Button6_Click(object sender, System.EventArgs e)
{
if(DataGrid1.SelectedIndex==-1)
{
Response.Write("<script language=javascript>alert('你還沒選擇！');</script>") ;
}
else
{
Panel2.Visible =true;
Submit.Text="修改";
Button7.Visible =false;
if(cnn.State==0) cnn.Open();
cmd1.Parameters["@id"].Value=Convert.ToInt32(DataGrid1.SelectedItem.Cells[1].Text);
SqlDataReader rd=cmd1.ExecuteReader();
while (rd.Read())
{
tname.Text=rd.GetValue(1).ToString();
tjg.Text=rd.GetValue(4).ToString();
tzz.Text =rd.GetValue(5).ToString();
tdh.Text=rd.GetValue(9).ToString();
tem.Text =rd.GetValue(10).ToString();
tdz.Text =rd.GetValue(11).ToString();
}
}
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
fills();
}
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
Panel2.Visible =false;
}
private void Submit_Click(object sender, System.EventArgs e)
{
Panel2.Visible =false;
if(this.File1.Value=="")
{
Response.Write("<script language=javascript>alert('你還沒選擇圖片路徑！')</script>") ;
return;
}
else
{
string file=File1.PostedFile.FileName ;
string type=file.Substring(file.LastIndexOf(".")+1);
byte[] fileCont = new byte[File1.PostedFile.ContentLength];
File1.PostedFile.InputStream.Read(fileCont,0,(int)File1.PostedFile.ContentLength); //將文件流中的內容轉成byte數組
if(cnn.State==0) cnn.Open();
cmd.Parameters["@put"].Value=Submit.Text;
if(Submit.Text=="上傳")
{
cmd.Parameters["@id"].Value=11;
}
else
{
cmd.Parameters["@id"].Value=DataGrid1.SelectedItem.Cells[1].Text;
}
cmd.Parameters["@mydata"].Value = fileCont ;
cmd.Parameters ["@姓名"].Value =tname.Text ;
cmd.Parameters ["@性別"].Value =r1.SelectedValue ;
cmd.Parameters ["@出生年月"].Value =d1.SelectedValue + "-" + d2.SelectedValue;
cmd.Parameters ["@籍貫"].Value =tjg.Text ;
cmd.Parameters ["@種族"].Value =tzz.Text ;
cmd.Parameters ["@政治面貌"].Value =d3.SelectedValue;
cmd.Parameters ["@學歷"].Value =d4.SelectedValue ;
cmd.Parameters ["@職務"].Value =d6.SelectedValue ;
cmd.Parameters ["@電話"].Value =tdh.Text ;
cmd.Parameters ["@郵箱"].Value =tem.Text ;
cmd.Parameters ["@家庭地址"].Value =tdz.Text ;
cmd.ExecuteNonQuery();
cnn.Close();
// fills();
// Response.Write("<script language=javascript>alert('恭喜你?。?！你已成功的填完！')</script>") ;
string kk="";
if(Submit.Text=="上傳")
{
kk="添加成功！";
}
else
{
kk="修改成功！";
}
Response.Write("<script language=javascript>alert('"+kk+"');</script>") ;
fills();
this.DataGrid1.SelectedIndex=-1;
tname.Text="";
tjg.Text="";
tzz.Text ="";
tdh.Text="";
tem.Text ="";
tdz.Text ="";
}
}
private void Button3_Click(object sender, System.EventArgs e)
{
if(DataGrid1.SelectedIndex==-1)
{
Response.Write("<script language=javascript>alert('你還沒選擇！');</script>") ;
}
else
{
if(cnn.State==0) cnn.Open();
sda.DeleteCommand.Parameters["@id"].Value=DataGrid1.SelectedItem.Cells[1].Text;
sda.DeleteCommand.ExecuteNonQuery ();
cnn.Close();
fills();
this.DataGrid1.SelectedIndex=-1;
}
}
private void Button7_Click(object sender, System.EventArgs e)
{
Panel2.Visible =false;
if(this.File1.Value=="")
{
Response.Write("<script language=javascript>alert('你還沒選擇圖片路徑！')</script>") ;
return;
}
else
{
string file=File1.PostedFile.FileName ;
string type=file.Substring(file.LastIndexOf(".")+1);
byte[] fileCont = new byte[File1.PostedFile.ContentLength];
File1.PostedFile.InputStream.Read(fileCont,0,(int)File1.PostedFile.ContentLength); //將文件流中的內容轉成byte數組
if(cnn.State==0) cnn.Open();
cmd2.Parameters["@mydata"].Value = fileCont ;
cmd2.Parameters ["@姓名"].Value =tname.Text ;
cmd2.Parameters ["@性別"].Value =r1.SelectedValue ;
cmd2.Parameters ["@出生年月"].Value =d1.SelectedValue + "-" + d2.SelectedValue;
cmd2.Parameters ["@籍貫"].Value =tjg.Text ;
cmd2.Parameters ["@種族"].Value =tzz.Text ;
cmd2.Parameters ["@政治面貌"].Value =d3.SelectedValue;
cmd2.Parameters ["@學歷"].Value =d4.SelectedValue ;
cmd2.Parameters ["@職務"].Value =d6.SelectedValue ;
cmd2.Parameters ["@電話"].Value =tdh.Text ;
cmd2.Parameters ["@郵箱"].Value =tem.Text ;
cmd2.Parameters ["@家庭地址"].Value =tdz.Text ;
cmd2.ExecuteNonQuery();
cnn.Close();
fills();
}
}
private void Button8_Click(object sender, System.EventArgs e)
{
this.Response.Redirect("index.aspx");
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -