public static SqlConnection GetConnection()
{
SqlConnect.ConnectStr connect = new SqlConnect.ConnectStr("ERP");
string s = connect.GetConnectStr("ERP");
return(GetConnection(s));
//return GetConnection("packet size=4096;user id=sa;pwd=;data source=192.168.0.97;persist security info=False;initial catalog=hy");
}
private void button1_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;//等待
dt.Clear();
SqlConnect.ConnectStr connect = new SqlConnect.ConnectStr("ERP");
string s = connect.GetConnectStr("ERP");
string connectionString = s;
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "thequery2";
SqlParameter[] para =
{
new SqlParameter("@DAH", SqlDbType.VarChar)
};
para[0].Value = textBox1.Text.Trim();
try
{
cmd.CommandTimeout = 60 * 60 * 1000;
cmd.Parameters.AddRange(para);// 将参数加入命令对象
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
conn.Close();
dataGridView1.DataSource = dt;
dataGridView1.Columns["部件编号"].Visible = false;
dataGridView1.Columns["序号"].Visible = false;
dataGridView1.RowsDefaultCellStyle.BackColor = Color.Azure;
dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.WhiteSmoke;
dataGridView1.RowsDefaultCellStyle.Font = new Font("微软雅黑", 8, FontStyle.Regular);
dataGridView1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
this.Cursor = Cursors.Default;//正常状态
}
