机票预订系统课程设计报告(17)

// DataSet ds1 = new DataSet();//实例化dataset

// da.Fill(ds1);//把数据填充到dataset

// dataGridView1.DataSource = ds1.Tables[0];//将数据集绑定datagridview,完成显

// conn.Close();

}

private void Form3_Load(object sender, EventArgs e)

{

//SqlConnection conn = new SqlConnection(MyConn);

string MyConn = ;

conn = new SqlConnection(MyConn);

}

private void label14_Click(object sender, EventArgs e)

{

}

}

}

using System;

using

using ponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using

using

namespace WindowsApplication2

{

public partial class Form4 : Form

{

public static Form4 f = null;

public Form4()

{

InitializeComponent();

f = this;

}

public SqlConnection conn;

public string toos()

{

string a = textBox1.Text;

return a;

}

private void button1_Click(object sender, EventArgs e)

{

// conn = new SqlConnection(MyConn);

string MyInsert = "select * from 订单信息表where 订单号='"+textBox1.Text+"'";

SqlCommand MyCommand = new SqlCommand(MyInsert, conn);

try

{

conn.Open();

}

catch { MessageBox.Show("数据库连接失败"); return; }

object o = MyCommand.ExecuteScalar();

if (o == null)

{

MessageBox.Show("不存在此记录", "提示", MessageBoxButtons.OK, rmation); }

else

{

SqlDataAdapter DA = new SqlDataAdapter(MyInsert, conn);

DataSet dsl = new DataSet();

DA.Fill(dsl);

dataGridView1.DataSource = dsl.Tables[0];

}

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新高中教育机票预订系统课程设计报告(17)全文阅读和word下载服务。