private void button1_Click(object sender, System.EventArgs e)
{
sqlCmd=new SqlCommand("insert into stu values('9715255','asdfasd','男','8210138','asdfasd')",sqlCon);
try
{
sqlCmd.ExecuteNonQuery();
Console.WriteLine("Insert Succ!");
}
catch(Exception err)
{
Console.WriteLine(err.Message);
}
sqlCon.Close();
} private void butConn_Click(object sender, System.EventArgs e)
{
strCon="uid=sa;pwd=888;database=test;server=134.242.7.155";
sqlCon=new SqlConnection(strCon);
try
{
sqlCon.Open();
Console.WriteLine("Connection Succ!");
}
catch(Exception err)
{
Console.WriteLine(err.Message);
}
} private void butExit_Click(object sender, System.EventArgs e)
{
Application.Exit();
} private void butEdit_Click(object sender, System.EventArgs e)
{
sqlDA=new SqlDataAdapter("select * from stu",sqlCon);
sqlDA.Fill(sqlDS,"stu");
sqlTable=sqlDS.Tables["stu"];
sqlRow=sqlTable.Rows[0];
sqlRow.BeginEdit();
sqlRow["number"]="1234567";
sqlRow.EndEdit();
SqlCommandBuilder sqlCB=new SqlCommandBuilder(sqlDA);
sqlDA.UpdateCommand=sqlCB.GetUpdateCommand();
sqlDA.Update(sqlDS,"stu"); }
{
sqlCmd=new SqlCommand("insert into stu values('9715255','asdfasd','男','8210138','asdfasd')",sqlCon);
try
{
sqlCmd.ExecuteNonQuery();
Console.WriteLine("Insert Succ!");
}
catch(Exception err)
{
Console.WriteLine(err.Message);
}
sqlCon.Close();
} private void butConn_Click(object sender, System.EventArgs e)
{
strCon="uid=sa;pwd=888;database=test;server=134.242.7.155";
sqlCon=new SqlConnection(strCon);
try
{
sqlCon.Open();
Console.WriteLine("Connection Succ!");
}
catch(Exception err)
{
Console.WriteLine(err.Message);
}
} private void butExit_Click(object sender, System.EventArgs e)
{
Application.Exit();
} private void butEdit_Click(object sender, System.EventArgs e)
{
sqlDA=new SqlDataAdapter("select * from stu",sqlCon);
sqlDA.Fill(sqlDS,"stu");
sqlTable=sqlDS.Tables["stu"];
sqlRow=sqlTable.Rows[0];
sqlRow.BeginEdit();
sqlRow["number"]="1234567";
sqlRow.EndEdit();
SqlCommandBuilder sqlCB=new SqlCommandBuilder(sqlDA);
sqlDA.UpdateCommand=sqlCB.GetUpdateCommand();
sqlDA.Update(sqlDS,"stu"); }
解决方案 »
- 大家一起来学习系列(代码分析)20080802
- 恳求大家帮助!555555555555
- 在C#中怎样获得当前所有已打开的word文档对象(Word.Application)???
- 用VC#时在MDI窗体中打开另一个窗体时显示“不能将顶级控件添加到一个控件上”出现“不能将顶级控件添加到一个控件上”错误怎么处理?
- nhibernate One to Many 疑问 一个老师带多个学生
- 线程中重新启动Timer的问题
- exe广告注入器的原理
- mm急救急急急!分全加上了,请教如何在英文版的WIN98上运行C#程序?
- 我的QuickStart在自己的机子上运行不了!!
- wpf的ToolBarTray如何实现自动换行?
- 我准备学习.net,已有多年的Delphi开发经验,大家有何建议
- 简单问题!!!
它会自动生成insertcommand deletecommand updatacommand
再在代码中加入Updata方法就可以了!~~!!
public static decimal[] chi(int i,decimal j)
{
decimal x;
decimal y;
string source ="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sbbyn;Data Source=SUNB\\sbnet";
SqlConnection conn=new SqlConnection(source);
SqlCommand cmd=new SqlCommand("StoredProcedure4",conn);
cmd.CommandType=CommandType.StoredProcedure;
SqlDataAdapter da=new SqlDataAdapter(cmd);
SqlCommandBuilder custcb=new SqlCommandBuilder(da);
conn.Open();
DataSet ds=new DataSet();
da.Fill(ds,"学生成绩表");
DataColumn[] keys=new DataColumn[1]; keys[0]=ds.Tables["学生成绩表"].Columns["学号"];
ds.Tables["学生成绩表"].PrimaryKey=keys;
DataRow foundrow=ds.Tables["学生成绩表"].Rows.Find(i);
x=Convert.ToDecimal(foundrow["总成绩"]);
y=Convert.ToDecimal(foundrow["语文"]);
x-=y;
foundrow["语文"]=j;
y=Convert.ToDecimal(foundrow["语文"]);
x+=y;
foundrow["总成绩"]=x;
foundrow["平均成绩"]=x/5;
decimal[] dec=new Decimal[2];
dec[0]=x;
dec[1]=x/5;
da.Update(ds,"学生成绩表");
ds.AcceptChanges();
return dec; }
public static void delete(int i)
{
string source ="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sbbyn;Data Source=SUNB\\sbnet";
SqlConnection conn=new SqlConnection(source);
SqlCommand cmd=new SqlCommand("StoredProcedure4",conn);
cmd.CommandType=CommandType.StoredProcedure;
SqlDataAdapter da=new SqlDataAdapter(cmd);
SqlCommandBuilder custcb=new SqlCommandBuilder(da);
conn.Open();
DataSet ds=new DataSet();
da.Fill(ds,"学生成绩表");
DataColumn[] keys=new DataColumn[1];
keys[0]=ds.Tables["学生成绩表"].Columns["学号"];
ds.Tables["学生成绩表"].PrimaryKey=keys;
try
{
DataRow foundrow=ds.Tables["学生成绩表"].Rows.Find(i);
foundrow.Delete();
da.Update(ds,"学生成绩表");
ds.AcceptChanges();
}
catch(System.NullReferenceException)
{
MessageBox.Show("您要删除的学号不存在"); }
}
public static void insert(int i ,string j)
{
string source ="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sbbyn;Data Source=SUNB\\sbnet";
SqlConnection conn=new SqlConnection(source);
SqlCommand cmd=new SqlCommand("StoredProcedure4",conn);
cmd.CommandType=CommandType.StoredProcedure;
SqlDataAdapter da=new SqlDataAdapter(cmd);
SqlCommandBuilder custcb=new SqlCommandBuilder(da);
conn.Open();
DataSet ds=new DataSet();
da.Fill(ds,"学生成绩表");
DataColumn[] keys=new DataColumn[1];
keys[0]=ds.Tables["学生成绩表"].Columns["学号"];
ds.Tables["学生成绩表"].PrimaryKey=keys;
try
{
DataRow myrow=ds.Tables["学生成绩表"].NewRow();
myrow["学号"]=i;
myrow["姓名"]=j;
myrow["数学"]=0;
myrow["物理"]=0;
myrow["化学"]=0;
myrow["英语"]=0;
myrow["语文"]=0;
myrow["总成绩"]=0;
myrow["平均成绩"]=0;
ds.Tables["学生成绩表"].Rows.Add(myrow);
da.Update(ds,"学生成绩表");
ds.AcceptChanges(); }附存储过程4ALTER PROCEDURE StoredProcedure4
/*
(
@parameter1 datatype = default value,
@parameter2 datatype OUTPUT
)
*/
AS
/* SET NOCOUNT ON */
select * from 学生成绩表
using System;
using System.Data;
using System.Data.SqlClient;namespace DataReaderExample
{ //******************************Enter Class**************************** class DataReaderExample
{
[STAThread]
static void Main(string[] args)
{
SqlConnection thisConnection = new SqlConnection(
@"Data Source = (local);Integrated Security = SSPI;" + "Initial Catalog = northwind");
thisConnection.Open();
SqlCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText =
"select customerid,companyname from customers";
SqlDataReader thisReader = thisCommand.ExecuteReader();
while (thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",
thisReader["customerid"],thisReader["companyname"]);
}
thisReader.Close();
thisConnection.Close();
Console.ReadLine();
}
}
}