using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace j062
{
public partial class QueryForm : Form
{
public QueryForm()
{
InitializeComponent();
} private void QueryForm_Load(object sender, EventArgs e)
{
comboBox1.SelectedIndex = 0; } private void button2_Click(object sender, EventArgs e)
{
Close();
} private void button1_Click(object sender, EventArgs e)
{
if (textBox2.Text.Length > 0)
{
try
{
Int32.Parse(textBox2.Text.Trim());
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox2.Focus();
return;
}
}
String sqlstring = (@"select Student.学号,姓名,年龄,Course.课程号,课程名,SC.成绩
from Student,Course,SC
where (Student.学号=SC.学号) and
(Course.课程号=SC.课程号) and
姓名 like '%" + textBox1.Text.Trim().ToString() + "%'and");
switch (comboBox1.SelectedIndex)
{
case 0: { sqlstring += "SC.成绩='" + textBox2.Text.Trim() + "'"; break; }
case 1: { sqlstring += "SC.成绩!='" + textBox2.Text.Trim() + "'"; break;}
case 2: { sqlstring += "SC.成绩>'" + textBox2.Text.Trim() + "'"; break;}
case 3: { sqlstring += "SC.成绩>='" + textBox2.Text.Trim() + "'"; break;}
case 4: {sqlstring += "SC.成绩<'" + textBox2.Text.Trim() + "'"; break; }
case 5: { sqlstring += "SC.成绩<='" + textBox2.Text.Trim() + "'"; break;}
}
sqlstring += "order by Student.学号,SC.成绩";
string connectionstring = (@"Data Source=3967A13981A4436;
Persist Security Info=false;
Integrated Security=SSPI;
Initial Catalog=学生信息管理系统;
User ID=sa;
Password=88105421;"); SqlConnection mysqlconnection=new SqlConnection(connectionstring);
try
{
mysqlconnection.Open();
}
catch (Exception ex)
{MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SqlCommand mysqlcommand=new SqlCommand(sqlstring,mysqlconnection);
SqlDataAdapter myDataAdapter=new SqlDataAdapter(mysqlcommand);
DataSet myDataSet=new DataSet();
myDataAdapter.Fill(myDataSet);
dataGridView1.DataSource=myDataSet.Tables[0].DefaultView;
}
}
}
可以生成对话框,可是在按确认按钮时,出现下面的错误:
未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 System.Data.dll 中。其他信息: 第 1 行: ',' 附近有语法错误。然后箭头指向这行 myDataAdapter.Fill(myDataSet);
什么原因啊?
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace j062
{
public partial class QueryForm : Form
{
public QueryForm()
{
InitializeComponent();
} private void QueryForm_Load(object sender, EventArgs e)
{
comboBox1.SelectedIndex = 0; } private void button2_Click(object sender, EventArgs e)
{
Close();
} private void button1_Click(object sender, EventArgs e)
{
if (textBox2.Text.Length > 0)
{
try
{
Int32.Parse(textBox2.Text.Trim());
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox2.Focus();
return;
}
}
String sqlstring = (@"select Student.学号,姓名,年龄,Course.课程号,课程名,SC.成绩
from Student,Course,SC
where (Student.学号=SC.学号) and
(Course.课程号=SC.课程号) and
姓名 like '%" + textBox1.Text.Trim().ToString() + "%'and");
switch (comboBox1.SelectedIndex)
{
case 0: { sqlstring += "SC.成绩='" + textBox2.Text.Trim() + "'"; break; }
case 1: { sqlstring += "SC.成绩!='" + textBox2.Text.Trim() + "'"; break;}
case 2: { sqlstring += "SC.成绩>'" + textBox2.Text.Trim() + "'"; break;}
case 3: { sqlstring += "SC.成绩>='" + textBox2.Text.Trim() + "'"; break;}
case 4: {sqlstring += "SC.成绩<'" + textBox2.Text.Trim() + "'"; break; }
case 5: { sqlstring += "SC.成绩<='" + textBox2.Text.Trim() + "'"; break;}
}
sqlstring += "order by Student.学号,SC.成绩";
string connectionstring = (@"Data Source=3967A13981A4436;
Persist Security Info=false;
Integrated Security=SSPI;
Initial Catalog=学生信息管理系统;
User ID=sa;
Password=88105421;"); SqlConnection mysqlconnection=new SqlConnection(connectionstring);
try
{
mysqlconnection.Open();
}
catch (Exception ex)
{MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SqlCommand mysqlcommand=new SqlCommand(sqlstring,mysqlconnection);
SqlDataAdapter myDataAdapter=new SqlDataAdapter(mysqlcommand);
DataSet myDataSet=new DataSet();
myDataAdapter.Fill(myDataSet);
dataGridView1.DataSource=myDataSet.Tables[0].DefaultView;
}
}
}
可以生成对话框,可是在按确认按钮时,出现下面的错误:
未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 System.Data.dll 中。其他信息: 第 1 行: ',' 附近有语法错误。然后箭头指向这行 myDataAdapter.Fill(myDataSet);
什么原因啊?
解决方案 »
- 求教:主机如何通过GPRS方式发送数据给车载LCD屏显示
- 请问GrideView分页的问题,初学者谢谢各位大大
- 请帮看看SQL语句有无错误
- tabControl改变选项内容
- 请问用IHTMLDocument2如何往MSWEBBROWSE里面写入HTML字符串啊(在线等)
- 一个一直困扰我的数据问题,请大家帮帮忙
- 我在这里下载之后,为什么用vs打开后是乱码那?
- 出于安全原因,此 XML 文档中禁止了 DTD???
- 应该知足了
- fck增加word文档导入功能,本地运行没有问题,发布后报错
- Dotfuscator community Edition如何解决多语言的问题?
- 问一下delegate的底层实现
String sqlstring = (@"select Student.学号,姓名,年龄,Course.课程号,课程名,SC.成绩
红色标记的字段前,没有对应的表名称
应该为:Student.姓名,Student.年龄,...
设置断点,检查一下SQL语句。
String sqlstring = (@"select Student.学号,姓名,年龄,Course.课程号,课程名,SC.成绩
from Student,Course,SC
where (Student.学号=SC.学号) and
(Course.课程号=SC.课程号) and
姓名 like '%" + textBox1.Text.Trim().ToString() + "%' and ");
用(,)
String sqlstring = (@"select Student.学号,姓名,年龄,Course.课程号,课程名,SC.成绩
from Student,Course,SC
where (Student.学号=SC.学号) and
(Course.课程号=SC.课程号) and
姓名 like '%" + textBox1.Text.Trim().ToString() + "%'and");
ToString() + "%'and");
and连接符左右要有空格,最好在查询分析器中执行一下 看都报什么错,
未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 system.data.dll 中。其他信息: 系统错误。
看看语句有没有执行!