private Boolean SaveData() { SqlConnection conn; SqlCommand command; string sql; DataSet ds; class_is.dbconfig db = new class_is.dbconfig(); //config = db.config(); conn = new SqlConnection(db.config()); sql = "INSERT INTO [IS].[dbo].[USER] "; sql += "(USER_NAME,PASSWORD,USER_GROUP,LINE_ID,FIRST_NAME,LAST_NAME,USER_CODE,DEPARTMENT,EMAIL) "; sql += "VALUES ( "; sql += "'" + txtUserName.Text + "'"; sql += "'Password'"; sql += "'" + ddlGroup.SelectedValue + "'"; sql += "'" + txtLine.Text + "'"; sql += "'" + txtFName.Text + "'"; sql += "'" + txtLName.Text + "'"; sql += "'" + txtEmpID.Text + "'"; sql += "'" + ddlDep.SelectedValue + "'"; sql += "'" + txtEmail.Text + "'"; sql += ")"; if (db.ExecuteSQL(sql)) { return(true); } else { return(false); } }
private void GetUserGroup() { DataSet ds = new DataSet(); string sql; int i; int count; string GroupID, GroupName; SqlCommand cmd; ListItem li; class_is.dbconfig db = new class_is.dbconfig(); SqlConnection conn = new SqlConnection(db.config()); SqlDataAdapter data; conn.Open(); sql = "select * "; sql += "from [IS].[dbo].[UserGroup] "; cmd = new SqlCommand(sql); data = new SqlDataAdapter(sql, conn); data.Fill(ds); count = ds.Tables[0].Rows.Count; for (i = 0; i <= count - 1; i++) { GroupID = ds.Tables[0].Rows[i]["GroupID"].ToString(); GroupName = ds.Tables[0].Rows[i]["GroupName"].ToString(); li = new ListItem(GroupName, GroupID); ddlGroup.Items.Add(li); } conn.Close(); }