代码是这样的
default2.aspx代码
id = Request.QueryString["id"].ToString();
DAL.DisciplineInfo da = new DAL.DisciplineInfo();
DataSet ds = da.GetAll(id, "selectid");
Name = ds.Tables[0].Rows[0][1].ToString();
Type = ds.Tables[0].Rows[0][2].ToString();
Grade = ds.Tables[0].Rows[0][3].ToString();
ContructGrade =Convert.ToByte(ds.Tables[0].Rows[0][4].ToString());
Field = ds.Tables[0].Rows[0][5].ToString();
LeaderNO = ds.Tables[0].Rows[0][6].ToString();
Intro = ds.Tables[0].Rows[0][7].ToString();DisciplineInfo.cs 代码
public DataSet GetAll(string id,string zx)
{
SqlParameter[] para ={
new SqlParameter("@zx",zx),
new SqlParameter("@Id",id),
};
return SqlHelper.GetList("DisciplineInfo1", para);SqlHelper.cs代码
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = BuildCommand(storeProcName, para);
DataSet ds = new DataSet();
sda.Fill(ds);
Closecon();
return ds;
存储过程是
ALTER proc [dbo].[DisciplineInfo1] @zx varchar(6),@id varchar(6)=null,@DisciplineName varchar(40)=null,@DisciplineType char(6)=null,@DisciplineGrade char(8)=null,@ContructGrade tinyint=null,@ToDisciplineField varchar(10)=null,@AcademicLeaderNO varchar(8)=null,@DisciplineIntro text=null
as
if @zx='insert'
insert DisciplineInfo values(@id,@DisciplineName,@DisciplineType,@DisciplineGrade,@ContructGrade,@ToDisciplineField,@AcademicLeaderNO,@DisciplineIntro);
if @zx='update'
update DisciplineInfo set DisciplineName=@DisciplineName,DisciplineType=@DisciplineType,DisciplineGrade=@DisciplineGrade,ContructGrade=@ContructGrade,ToDisciplineField=@ToDisciplineField,AcademicLeaderNO=@AcademicLeaderNO,DisciplineIntro=@DisciplineIntro
where Id=@id;
if @zx='delete'
DELETE FROM DisciplineInfo WHERE Id=@id;
if @zx='select'
select * from DisciplineInfo;
if @zx='selectid'
select * from DisciplineInfo where Id=@id;
为什么总是返回首行首列的,不能返回指定编号的数据啊
default2.aspx代码
id = Request.QueryString["id"].ToString();
DAL.DisciplineInfo da = new DAL.DisciplineInfo();
DataSet ds = da.GetAll(id, "selectid");
Name = ds.Tables[0].Rows[0][1].ToString();
Type = ds.Tables[0].Rows[0][2].ToString();
Grade = ds.Tables[0].Rows[0][3].ToString();
ContructGrade =Convert.ToByte(ds.Tables[0].Rows[0][4].ToString());
Field = ds.Tables[0].Rows[0][5].ToString();
LeaderNO = ds.Tables[0].Rows[0][6].ToString();
Intro = ds.Tables[0].Rows[0][7].ToString();DisciplineInfo.cs 代码
public DataSet GetAll(string id,string zx)
{
SqlParameter[] para ={
new SqlParameter("@zx",zx),
new SqlParameter("@Id",id),
};
return SqlHelper.GetList("DisciplineInfo1", para);SqlHelper.cs代码
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = BuildCommand(storeProcName, para);
DataSet ds = new DataSet();
sda.Fill(ds);
Closecon();
return ds;
存储过程是
ALTER proc [dbo].[DisciplineInfo1] @zx varchar(6),@id varchar(6)=null,@DisciplineName varchar(40)=null,@DisciplineType char(6)=null,@DisciplineGrade char(8)=null,@ContructGrade tinyint=null,@ToDisciplineField varchar(10)=null,@AcademicLeaderNO varchar(8)=null,@DisciplineIntro text=null
as
if @zx='insert'
insert DisciplineInfo values(@id,@DisciplineName,@DisciplineType,@DisciplineGrade,@ContructGrade,@ToDisciplineField,@AcademicLeaderNO,@DisciplineIntro);
if @zx='update'
update DisciplineInfo set DisciplineName=@DisciplineName,DisciplineType=@DisciplineType,DisciplineGrade=@DisciplineGrade,ContructGrade=@ContructGrade,ToDisciplineField=@ToDisciplineField,AcademicLeaderNO=@AcademicLeaderNO,DisciplineIntro=@DisciplineIntro
where Id=@id;
if @zx='delete'
DELETE FROM DisciplineInfo WHERE Id=@id;
if @zx='select'
select * from DisciplineInfo;
if @zx='selectid'
select * from DisciplineInfo where Id=@id;
为什么总是返回首行首列的,不能返回指定编号的数据啊
解决方案 »
- 像listbox那样的控件,旁边有上下两个换钮,实现控件内数据位置交换应该用哪类控件,如何实现?
- 急急急....html语句怎么写?
- 求高手做个类似于百度的页面
- 急啊!那位达人帮帮啊,鄙人才学C#3天,老板让做个小东西!看看啊,在线等啊!
- 请问这个挺玄的网站用的什么技术做的?
- ASP.NET Web Matrix使用的一个问题,如何放控件
- 急!急!急!在asp.net的页面中如何用soap调用一个webservice?
- 最后70分,求简单datagrid问题的解决方法
- 如何获取指定节点下的子节点
- 紧急,关于页面刷新,贴有原码,请高手过目
- EF 数据诡异异常,期待大神拯救
- 如何在后台获取listview中InsertItemTemplate模板的一个控件的Text
或使用model,使用实体类为属性,显示NAME