不好意思时间来不及了,加上这两天感冒 一点也写不下去了,麻烦兄弟们帮我写下。下面是我写的大致意思,可能不对麻烦改下:CREATE PROCEDURE selcarinfo2
AS
select @@IDENTITY FROM carinfo //返回自增长的ID号,好像是这么写的
select * from carinfo //获得数据集
GOc#代码要用到DATASET
m_dataadapter = new SqlDataAdapter("selcarinfo2", m_connection);
m_dataadapter.SelectCommand.CommandType = CommandType.StoredProcedure; ???????//就是要获取 增长的ID号和 select * from carinfo的数据集
m_dataadapter.FillSchema(m_ds, SchemaType.Source, "carinfo");
m_dataadapter.Fill(m_ds, "carinfo");
AS
select @@IDENTITY FROM carinfo //返回自增长的ID号,好像是这么写的
select * from carinfo //获得数据集
GOc#代码要用到DATASET
m_dataadapter = new SqlDataAdapter("selcarinfo2", m_connection);
m_dataadapter.SelectCommand.CommandType = CommandType.StoredProcedure; ???????//就是要获取 增长的ID号和 select * from carinfo的数据集
m_dataadapter.FillSchema(m_ds, SchemaType.Source, "carinfo");
m_dataadapter.Fill(m_ds, "carinfo");
SqlConnection myConnection = new SqlConnection(cs);
SqlCommand myCommand = new SqlCommand("xs_delete", myConnection);
//指明SQL的命令类型是存储过程
myCommand.CommandType = CommandType.StoredProcedure;
//给存储过程添加参数
SqlParameter paraJSZH = new SqlParameter("@jszh",SqlDbType.NVarChar,10);
paraJSZH.Value = textBox1.Text;
myCommand.Parameters.Add(paraJSZH); //添加存储过程的输出参数
SqlParameter paraFLAG = new SqlParameter("@flag", SqlDbType.Int, 4);
paraFLAG.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(paraFLAG);
//打开数据库连接
myConnection.Open();
//执行数据库操作//myCommand.ExecuteReader();
myCommand.ExecuteNonQuery();
//关闭数据库连接
myConnection.Close();