private void LoadAllSizesIntoGrid() { using (SqlConnection con = new SqlConnection(Application_Settings.ConnectionString())) { using (SqlCommand cmd = new SqlCommand("MSP_LoadDataIntoGrid", con)) { cmd.CommandType = CommandType.StoredProcedure; if (con.State != ConnectionState.Open) { con.Open(); } DataTable dt = new DataTable(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { dt.Load(dr); SizesdataGridView1.DataSource = dt; SizesdataGridView1.Columns[0].Visible = false; } } } } }
private void btnLogin_Click(object sender, EventArgs e) { if (IsValid()) { using (SqlConnection con = new SqlConnection(Application_Settings.ConnectionString())) { using (SqlCommand cmd = new SqlCommand("usp_Login_VerifyLoginDetails", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserName", txtUsername.Text.Trim()); cmd.Parameters.AddWithValue("@Password", txtPassword.Text.Trim()); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { this.Hide(); Dashboard dsh = new Dashboard(); dsh.Show(); } else { MessageBox.Show("Username or Password is incorrect", "Login Failed!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } }
private DataTable GetComboBoxData(int listTypeID) { DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection(Application_Settings.ConnectionString())) { using (SqlCommand cmd = new SqlCommand("MSP_LoadDataIntoCombo", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ListTypeID", 1); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); dt.Load(dr); } } return(dt); }