先是查询整张表，用到combobox选择查询哪张表，最后用DataGridView显示
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void dataGridView1_CellContentClick( object sender, DataGridViewCellEventArgs e)
{
}
private void Form1_Load( object sender, EventArgs e)
{
this .dataGridView1.RowHeadersVisible = false ;
this .dataGridView1.AllowUserToAddRows = false ;
this .dataGridView1.ReadOnly = true ;
this .dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// this测试数据boBox1.SelectedIndex =0;
string sql = "select * from student" ;
DataTable table = SqlManage.TableSelect(sql);
this .dataGridView1.DataSource = table;
comboBox1.Items.Add( "学生表" );
comboBox1.Items.Add( "教师表" );
}
private void comboBox1_SelectedIndexChanged( object sender, EventArgs e)
{
string sql = "" ;
switch ( this 测试数据boBox1.SelectedIndex)
{
case 0:
sql = "select id as 学生号,name as 姓名,sage as 年龄 from student" ;
break ;
case 1:
sql = "select t_id as 教师号,t_name as 姓名,T_age as 年龄 from teacher" ;
break ;
default :
break ;
}
DataTable table = SqlManage.TableSelect(sql);
this .dataGridView1.DataSource = table;
}
}
}
然后是修改表格，这个比较简单，用到textbox和button
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication2
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void button4_Click( object sender, EventArgs e)
{
this .Close();
}
private void button1_Click( object sender, EventArgs e)
{
string sql = string .Format( "insert into teacher values('{0}','{1}','{2}')" ,
this .textBox1.Text, this .textBox2.Text, this .textBox3.Text);
SqlManage.TableChange(sql);
}
private void button2_Click( object sender, EventArgs e)
{
string sql = string .Format( "update teacher set ('{0}',''{1}'','{2}')" ,
this .textBox1.Text, this .textBox2.Text, this .textBox3.Text);
SqlManage.TableChange(sql);
}
private void button3_Click( object sender, EventArgs e)
{
string sql = string .Format( "delete from teacher where t_id='{0}'" ,
this .textBox1.Text);
SqlManage.TableChange(sql);
}
private void Form2_Load( object sender, EventArgs e)
{
}
}
}
按条件查询表格，这个是核心，用到radiobutt，combobox,，button， DataGridView
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication2
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
private void dataGridView1_CellContentClick( object sender, DataGridViewCellEventArgs e)
{
}
private void Form3_Load( object sender, EventArgs e)
{
this 测试数据boBox1.Enabled = false ;
this 测试数据boBox2.Enabled = false ;
this 测试数据boBox3.Enabled = false ;
this 测试数据boBox4.Enabled = false ;
//初始化教师编号
string sql = "select t_id from teacher" ;
DataTable table = SqlManage.TableSelect(sql);
string t_id;
foreach (DataRow row in table.Rows)
{
t_id = row[ "t_id" ].ToString();
this 测试数据boBox1.Items.Add(t_id);
}
if (table.Rows.Count > 0)
{
this 测试数据boBox1.SelectedIndex = 0;
}
//初始化教师姓名
string sql_name = "select t_name from teacher" ;
table.Clear();
table = SqlManage.TableSelect(sql_name);
string t_name;
foreach (DataRow row in table.Rows)
{
t_name= row[ "t_name" ].ToString();
this 测试数据boBox2.Items.Add(t_name);
}
if (table.Rows.Count > 0)
{
this 测试数据boBox2.SelectedIndex = 0;
}
//初始化学生
string sql_id = "select id from student" ;
table.Clear();
table = SqlManage.TableSelect(sql_id);
string s_id;
foreach (DataRow row in table.Rows)
{
s_id = row[ "id" ].ToString();
this 测试数据boBox3.Items.Add(s_id);
}
if (table.Rows.Count > 0)
{
this 测试数据boBox3.SelectedIndex = 0;
}
//初始化学生
string sql_sname = "select name from student" ;
table.Clear();
table = SqlManage.TableSelect(sql_sname);
string t_sname;
foreach (DataRow row in table.Rows)
{
t_sname = row[ "name" ].ToString();
this 测试数据boBox4.Items.Add(t_sname);
}
if (table.Rows.Count > 0)
{
this 测试数据boBox4.SelectedIndex = 0;
}
}
private void button2_Click( object sender, EventArgs e)
{
this .Close();
}
private void button1_Click( object sender, EventArgs e)
{
string sql = "" ;
if ( this .radioButton1.Checked)
{
sql = string .Format( "select t_id as 教师编号,t_name as 教师姓名,t_age as 年龄 from teacher where t_id = '{0}'" ,
this 测试数据boBox1.Text);
}
else if ( this .radioButton2.Checked)
{
sql = string .Format( "select t_id as 教师编号,t_name as 教师姓名,t_age as 年龄 from teacher where t_name = '{0}'" ,
this 测试数据boBox2.Text);
}
else if ( this .radioButton3.Checked)
{
sql = string .Format( "select id as 学生编号,name as 学生姓名,sage as 年龄 from student where id = '{0}'" ,
this 测试数据boBox3.Text);
}
else if ( this .radioButton4.Checked)
{
sql = string .Format( "select id as 学生编号,name as 学生姓名,sage as 年龄 from student where name = '{0}'" ,
this 测试数据boBox4.Text);
}
DataTable table = SqlManage.TableSelect(sql);
if (table.Rows.Count > 0)
{
this .dataGridView1.DataSource = table;
}
else
{
MessageBox.Show( "没有相关内容" );
}
}
private void radioButton1_CheckedChanged( object sender, EventArgs e)
{
if ( this .radioButton1.Checked)
{
this 测试数据boBox1.Enabled = true ;
}
else
{
this 测试数据boBox1.Enabled = false ;
}
}
private void radioButton2_CheckedChanged( object sender, EventArgs e)
{
if ( this .radioButton2.Checked)
{
this 测试数据boBox2.Enabled = true ;
}
else
{
this 测试数据boBox2.Enabled = false ;
}
}
private void radioButton3_CheckedChanged( object sender, EventArgs e)
{
if ( this .radioButton3.Checked)
{
this 测试数据boBox3.Enabled = true ;
}
else
{
this 测试数据boBox3.Enabled = false ;
}
}
private void radioButton4_CheckedChanged( object sender, EventArgs e)
{
if ( this .radioButton4.Checked)
{
this 测试数据boBox4.Enabled = true ;
}
else
{
this 测试数据boBox4.Enabled = false ;
}
}
}
}
以上所述是小编给大家介绍的c#操作sql server2008 的界面实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
原文链接：http://blog.csdn.net/sun_boy_01/article/details/62037071
dy("nrwz");
查看更多关于c#操作sql server2008 的界面实例代码的详细内容...