想实现对Student表中学生信息进行删除,修改,插入操作。
用的是DW+NET Framework 版本:2.0.+Access
我这要输入数据库名
错误如下:
行 14: OleDbConnection conn;
行 15: int convar=0;
行 16: Div2.visible=false;
行 17: if (convar==0)
行 18: Div1.visible=false;
源程序如下:<% @ Page Language="C#" Debug="true"%>
<% @ Import Namespace="System.Data"%>
<% @ Import Namespace="System.Data.OleDb"%>
<html >
<head>
<title>无标题文档</title>
</head>
<script language="c#" runat="server">
public void Page_Load(Object src,EventArgs e)
{
//if(!IsPostBack)
//{
string strConn;
OleDbConnection conn;
int convar=0;
Div2.visible=false;
if (convar==0)
Div1.visible=false;
// }
}
public void Myconn()
{
strConn="Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath(Textbox1.Text);
conn=new OleDbConnection(strConn);
}
public void TextChange1(Object src,EventArgs e)
{
Myconn();
ConData("Select * from Student Order By ID",0);
}
public bool ConData(string constr,int show)
{
try
{
OleDbCommand cmd=new OleDbCommand(constr,conn);
conn.Open();
OleDbDataReader MyReader=cmd.ExecuteReader();
if (show==0)
{
dg.DataSource=MyReader;
dg.DataBind();
}
MyReader.Close();
conn.Close();
Textbox1.visible=false;
info.Text="Success";
Div1.visible=true;
return true;
}
catch(Exception ex)
{
conn.Close();
info.Text="Happen Error:"+ex.Message+"或者,请确认您输入的数据库名称无误:";
Textbox1.visible=true;
return false;
//Div1.visible=false;
}
}
public void btn_click1(Object src,EventArgs e)
{
Myconn();
ConData("delect * from Student ID="+input1.value,1);
ConData("Select * from Student",0);
}
public void btn_click2(Object src,EventArgs e)
{
convar=2;
Myconn();
string strUp="select * from Student where ID="+input2.value;
if(ConData(strUp,1))
{
info.Text="Modify"+inpu2.value;
Div2.visible=true;
Div1.visible=false;
}
else
{
Div2.visible=false;
Div1.visible=true;
}
}
public void btn_click3(Object src,EventArgs e)
{
convar=1;
Myconn();
info.Text="Insert!";
Div2.visible=true;
Div1.visible=false;
}
public void btn_click4(Object src,EventArgs e)
{
Myconn();
info.Text=convar.ToString();
if (convar==2)
{
string strUp="Update Student Set 学号="+Input3.value+",姓名='"+Input4.value+"',性别='"+Input5.value+"',成绩="+Input6.value+"where ID="+Input2.value;
}
if (ConData(strUp,1))
{
ConData("Select * From Student Order By ID",0);
info.Text="Modify Success";
}
else
{
Div2.visible=true;
}
else if (convar==1)
{
string strIns="Insert into Student (学号,姓名,性别,成绩) values ("+Input3.value+",'"+Input4.value+"','"+Input5.value+"',"+
Input6.value+")";
}
if (ConData(strIns,1))
{
ConData("Select * From Student Order By ID",0)
info.Text="Insert Success";
}
else
{
Div2.visible=true;
}
else
{
Div2.visible=true;
}
}
public void btn_click5(Object src, EventArgs e)
{
Div1.visible=true;
Div2.visible=false;
}
</script>
<body>
<form runat="server">
<asp:Label id="info" Text="请输入数据库文件名称:" runat="server"/>
<asp:TextBox id="Textbox1" AutoPostBack="true" OnTextChanged=TextChange1 runat="server" /><br>
<asp:DataGrid id="dg" runat="server" BorderColor="black" BorderWidth="1" GridLines="Both" CellPadding="3" CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" AlternatingItemStyle-BackColor="#eeeeee"/><br>
<Div id=Div1 runat=server visible=false><asp:Label id="Label1" runat="server" Text="请输入您要删除的ID号:"/>
<input id=Input1 runat=server size="3" OnServerChange="btn_click1" />
<asp:Button id="btn1" runat="server" Text="OK" OnClick="btn_click1"/><br>请输入您要修改的ID号:
<input id=input2 runat=server size="3" OnServerChange="btn_click2"/>
<asp:Button id="btn2" runat="server" Text="OK" OnClick="btn_click2"/><br>如果你要插入新记录请点这里-->
<asp:Button id="btn3" runat="server" Text="Insert" OnClick="btn_click3"/></div><br>
<Div id=Div2 style="Background-color:aqua" runat=server>请输入您的修改值<br>学号:
<input id=Input3 runat=server size="5"/>姓名:
<input id=Input4 runat=server size="5"/>性别:
<input id=Input5 runat=server size="2"/>成绩:
<input id=Input6 runat=server size="3"/>
<asp:button id="btn4" runat="server" OnClick="btn_click4" Text="Submit"/>
<asp:Button id="btn5" runat="server" OnClick="btn_click5" Text="Cancel"/>
</Div>
</form>
</body>
</html>
用的是DW+NET Framework 版本:2.0.+Access
我这要输入数据库名
错误如下:
行 14: OleDbConnection conn;
行 15: int convar=0;
行 16: Div2.visible=false;
行 17: if (convar==0)
行 18: Div1.visible=false;
源程序如下:<% @ Page Language="C#" Debug="true"%>
<% @ Import Namespace="System.Data"%>
<% @ Import Namespace="System.Data.OleDb"%>
<html >
<head>
<title>无标题文档</title>
</head>
<script language="c#" runat="server">
public void Page_Load(Object src,EventArgs e)
{
//if(!IsPostBack)
//{
string strConn;
OleDbConnection conn;
int convar=0;
Div2.visible=false;
if (convar==0)
Div1.visible=false;
// }
}
public void Myconn()
{
strConn="Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath(Textbox1.Text);
conn=new OleDbConnection(strConn);
}
public void TextChange1(Object src,EventArgs e)
{
Myconn();
ConData("Select * from Student Order By ID",0);
}
public bool ConData(string constr,int show)
{
try
{
OleDbCommand cmd=new OleDbCommand(constr,conn);
conn.Open();
OleDbDataReader MyReader=cmd.ExecuteReader();
if (show==0)
{
dg.DataSource=MyReader;
dg.DataBind();
}
MyReader.Close();
conn.Close();
Textbox1.visible=false;
info.Text="Success";
Div1.visible=true;
return true;
}
catch(Exception ex)
{
conn.Close();
info.Text="Happen Error:"+ex.Message+"或者,请确认您输入的数据库名称无误:";
Textbox1.visible=true;
return false;
//Div1.visible=false;
}
}
public void btn_click1(Object src,EventArgs e)
{
Myconn();
ConData("delect * from Student ID="+input1.value,1);
ConData("Select * from Student",0);
}
public void btn_click2(Object src,EventArgs e)
{
convar=2;
Myconn();
string strUp="select * from Student where ID="+input2.value;
if(ConData(strUp,1))
{
info.Text="Modify"+inpu2.value;
Div2.visible=true;
Div1.visible=false;
}
else
{
Div2.visible=false;
Div1.visible=true;
}
}
public void btn_click3(Object src,EventArgs e)
{
convar=1;
Myconn();
info.Text="Insert!";
Div2.visible=true;
Div1.visible=false;
}
public void btn_click4(Object src,EventArgs e)
{
Myconn();
info.Text=convar.ToString();
if (convar==2)
{
string strUp="Update Student Set 学号="+Input3.value+",姓名='"+Input4.value+"',性别='"+Input5.value+"',成绩="+Input6.value+"where ID="+Input2.value;
}
if (ConData(strUp,1))
{
ConData("Select * From Student Order By ID",0);
info.Text="Modify Success";
}
else
{
Div2.visible=true;
}
else if (convar==1)
{
string strIns="Insert into Student (学号,姓名,性别,成绩) values ("+Input3.value+",'"+Input4.value+"','"+Input5.value+"',"+
Input6.value+")";
}
if (ConData(strIns,1))
{
ConData("Select * From Student Order By ID",0)
info.Text="Insert Success";
}
else
{
Div2.visible=true;
}
else
{
Div2.visible=true;
}
}
public void btn_click5(Object src, EventArgs e)
{
Div1.visible=true;
Div2.visible=false;
}
</script>
<body>
<form runat="server">
<asp:Label id="info" Text="请输入数据库文件名称:" runat="server"/>
<asp:TextBox id="Textbox1" AutoPostBack="true" OnTextChanged=TextChange1 runat="server" /><br>
<asp:DataGrid id="dg" runat="server" BorderColor="black" BorderWidth="1" GridLines="Both" CellPadding="3" CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" AlternatingItemStyle-BackColor="#eeeeee"/><br>
<Div id=Div1 runat=server visible=false><asp:Label id="Label1" runat="server" Text="请输入您要删除的ID号:"/>
<input id=Input1 runat=server size="3" OnServerChange="btn_click1" />
<asp:Button id="btn1" runat="server" Text="OK" OnClick="btn_click1"/><br>请输入您要修改的ID号:
<input id=input2 runat=server size="3" OnServerChange="btn_click2"/>
<asp:Button id="btn2" runat="server" Text="OK" OnClick="btn_click2"/><br>如果你要插入新记录请点这里-->
<asp:Button id="btn3" runat="server" Text="Insert" OnClick="btn_click3"/></div><br>
<Div id=Div2 style="Background-color:aqua" runat=server>请输入您的修改值<br>学号:
<input id=Input3 runat=server size="5"/>姓名:
<input id=Input4 runat=server size="5"/>性别:
<input id=Input5 runat=server size="2"/>成绩:
<input id=Input6 runat=server size="3"/>
<asp:button id="btn4" runat="server" OnClick="btn_click4" Text="Submit"/>
<asp:Button id="btn5" runat="server" OnClick="btn_click5" Text="Cancel"/>
</Div>
</form>
</body>
</html>
解决方案 »
- 将参数值从 SqlParameter 转换到 Int32 失败。
- 一个小问题,大家帮我看看吧!我找了半天也不知是什么原因
- url重写问题,超过10个参数表示问题!
- 我想用数据库实现计数器功能,但是不起作用,谁能帮我看看,在线等!
- 三天了还没有解决,自定义控件,为何SortCommand事件不触发?
- 怎么在CodeBehind里把XSL格式化XML后输出到一个TEXTBOX上?
- 有没有针对Microsoft Windows Server 2003 Enterprise Edition的IE7.0啊
- 放分控讨在IE中操作Word
- VB.NET与C#混合编程问题。。。
- 为自已想到一个新名字,交友....
- 死锁问题
- 比较急的问题!!!!比较急的问题!!!! 来着有分!!!
注意大小写