高分請教!DataGrid問題 如下dim ds as new datasetds= dg1.DataSource()然后对ds进行操作 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 private void Button1_Click(object sender, System.EventArgs e) { if ((biaoti.Text=="")||(neirong.Text=="")||(zuozhe.Text=="")) { lb1.Text="标题、内容、作者等不能为空!"; } else if (biaoti.Text.Length>=50) { lb1.Text="你的标题太长了!"; } else { string sele="select * from aa "; sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sele,sqlConnection1); dataSet11=new DataSet1(); sqlDataAdapter1.Fill(dataSet11,"aa"); dr=dataSet11.Tables ["aa"].Rows [0]; sele="select max(aaid) from aa "; sqlCommand1=new System.Data.SqlClient.SqlCommand (sele,sqlConnection1); sqlCommand1.Connection .Open (); sqlDataReader1=sqlCommand1.ExecuteReader(); sqlDataReader1.Read (); int i=sqlDataReader1.GetInt32(0); i=i+1; sqlDataReader1.Close (); //sqlCommand1.CommandText ="UPDATE aa SET click="+i.ToString ()+" WHERE aaid="+get3; sqlCommand1.ExecuteNonQuery (); sqlCommand1.Connection .Close (); //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ string sell="insert into aa (aaid, biaoti, neirong,zuozhe,shijian,click,img,typeid) values ('"+i.ToString ()+"','" + biaoti.Text.ToString() + "', '" + neirong.Text.ToString() + "','" + zuozhe.Text.ToString() + "','" + DateTime.Now.ToString() + "',0,0,'" + DropDownList1.SelectedItem.Value+ "')"; sqlCommand1 = new System.Data.SqlClient.SqlCommand(sell,sqlConnection1); sqlCommand1.Connection.Open(); sqlCommand1.ExecuteNonQuery(); sqlCommand1.Connection.Close(); Response.Redirect("WebForm1.aspx") ; } } Excel导出拒绝访问,在线等 Devexpress的ChartControl画线形曲线图 资源文件Resource.resx 这道题目答案是什么? C#定义,使用类——VS2008(我是新手哦) winfrom的DataGridView自动排列问题 求助,SQL不能插入重复的值 C# 如何实时监视某程序内存占用?? C#winform 画点、线、删除、保存等操作??? 引用配置文件没有显示? 控件设计时右键菜单扩展(高手进) 散分
{
if ((biaoti.Text=="")||(neirong.Text=="")||(zuozhe.Text==""))
{
lb1.Text="标题、内容、作者等不能为空!";
}
else if (biaoti.Text.Length>=50)
{
lb1.Text="你的标题太长了!";
}
else
{
string sele="select * from aa ";
sqlDataAdapter1=new System.Data.SqlClient.SqlDataAdapter (sele,sqlConnection1);
dataSet11=new DataSet1();
sqlDataAdapter1.Fill(dataSet11,"aa");
dr=dataSet11.Tables ["aa"].Rows [0]; sele="select max(aaid) from aa ";
sqlCommand1=new System.Data.SqlClient.SqlCommand (sele,sqlConnection1); sqlCommand1.Connection .Open ();
sqlDataReader1=sqlCommand1.ExecuteReader();
sqlDataReader1.Read ();
int i=sqlDataReader1.GetInt32(0);
i=i+1;
sqlDataReader1.Close ();
//sqlCommand1.CommandText ="UPDATE aa SET click="+i.ToString ()+" WHERE aaid="+get3;
sqlCommand1.ExecuteNonQuery ();
sqlCommand1.Connection .Close ();
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
string sell="insert into aa (aaid, biaoti, neirong,zuozhe,shijian,click,img,typeid) values ('"+i.ToString ()+"','" + biaoti.Text.ToString() + "', '" + neirong.Text.ToString() + "','" + zuozhe.Text.ToString() + "','" + DateTime.Now.ToString() + "',0,0,'" + DropDownList1.SelectedItem.Value+ "')";
sqlCommand1 = new System.Data.SqlClient.SqlCommand(sell,sqlConnection1);
sqlCommand1.Connection.Open();
sqlCommand1.ExecuteNonQuery();
sqlCommand1.Connection.Close();
Response.Redirect("WebForm1.aspx") ;
}
}