UC知道C# .net + Oracle 问题
来源：百度知道 编辑：UC知道 时间：2024/05/31 01:11:08
Sinner sn = new Sinner();
List<int> ps = new List<int>();
protected void btnOK_Click(object sender, EventArgs e)//点击事件
{
string userid = Convert.ToString(Application["LoginUser"]);
int courseid = Convert.ToInt32(this.XuanKeLieBiao.SelectedValue);
string course = XuanKeLieBiao.SelectedItem.Text;
string sql1 = "select courseid from tbStudentCourse where courseid='" + courseid + "'and userid='" + userid + "'";
Sinner sn1 = new Sinner();
OracleDataReader reader = sn1.ReadData(sql1);
if (reader.Read())
{
Label3.Text = course + " 课程已经存在,不必从新选择";
}
else
{
ps.Add(courseid);
}
}
protected void Button1_Click(object sender, EventArgs e)//确定添加事件
{
foreach (int cou
List<int> ps = new List<int>();
protected void btnOK_Click(object sender, EventArgs e)//点击事件
{
string userid = Convert.ToString(Application["LoginUser"]);
int courseid = Convert.ToInt32(this.XuanKeLieBiao.SelectedValue);
string course = XuanKeLieBiao.SelectedItem.Text;
string sql1 = "select courseid from tbStudentCourse where courseid='" + courseid + "'and userid='" + userid + "'";
Sinner sn1 = new Sinner();
OracleDataReader reader = sn1.ReadData(sql1);
if (reader.Read())
{
Label3.Text = course + " 课程已经存在,不必从新选择";
}
else
{
ps.Add(courseid);
}
}
protected void Button1_Click(object sender, EventArgs e)//确定添加事件
{
foreach (int cou
C# + SQLSever
Java + Oracle
你的组合好另类啊，只能关注了
course没有数据进去,你不能用int类型区接收数据，还得用list。
另外说下 C# + Oracle 就怎么另类了。
if (reader.Read())
{
Label3.Text = course + " 课程已经存在,不必从新选择";
}
else
{
ps.Add(courseid);
}
这里错了，再去了解一下reader.read()的意思吧，你好像还不是很明白哦