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;//正常状态 }