110,533
社区成员
发帖
与我相关
我的任务
分享
select rtrim(订单号) as 订单号,rtrim(确认状态) as 确认状态,货单号,rtrim(发货日期) as 发货日期,中文姓名,rtrim(送货地址) as送货地址,rtrim(联系电话) as 联系电话,rtrim(备注) as 备注,rtrim(操作人) as 操作人
from table
private void getData3()
{
try
{
string sql = "select rtrim(订单号) as 订单号,rtrim(确认状态) as 确认状态,货单号,rtrim(发货日期) as 发货日期,中文姓名,rtrim(送货地址) as送货地址,rtrim(联系电话) as 联系电话,rtrim(备注) as 备注,rtrim(操作人) as 操作人 from table where " + ComboBox1.Text + " like '%" + textbox.Text + "%'";
conn = new SqlConnection(cmd);
da = new SqlDataAdapter(sql, conn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
ds = new DataSet();
da.Fill(ds, "table");
dataGridView1.DataSource = ds.Tables[0].DefaultView;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
catch
{
MessageBox.Show("该数据不存在!", "确认");
}
finally
{
if (conn.State != ConnectionState.Closed)
{
try
{
conn.Close();
}
catch { }
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "确认");
//MessageBox.Show("该数据不存在!", "确认");
}
catch
{
MessageBox.Show("该数据不存在!", "确认");
}
catch
{
MessageBox.Show("该数据不存在!", "确认");
}