No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
[CODE] <asp:TemplateField HeaderText="Grabbelpas"> <ItemTemplate> <asp:CheckBox id="lblGrabbelpas" Enabled="false" runat="server" Checked='<%# DataBinder.Eval(Container, "DataItem.Grabbelpas") %>' ></asp:CheckBox> </ItemTemplate> <EditItemTemplate> <asp:CheckBox id="txtEditGrabbelpas" runat="server" Checked='<%# DataBinder.Eval(Container, "DataItem.Grabbelpas") %>' /> </EditItemTemplate> </asp:TemplateField>[/CODE] [CODE]CheckBox txtGrabbelpas = (CheckBox)(myDetailsView.FindControl("txtEditGrabbelpas")); strSQL = "UPDATE leden SET LidID = "Grabbelpas = '" + txtGrabbelpas.Checked + "' " + " WHERE LidID = '" …
|
|
|
[CODE]//SELECT ID van ingelogde gebruiker MySqlConnection cn = cn = new MySqlConnection("server=localhost; user id=bla; password=bla; database=project; Allow User Variables=True;"); cn.Open(); string selID = "SELECT LidID FROM gebruikers WHERE Gebruikersnaam=?Gebruikersnaam;"; MySqlCommand cmd = new MySqlCommand(selID, cn); MySqlDataReader dr = default(MySqlDataReader); //Add parameters to get the username and password cmd.Parameters.Add("?Gebruikersnaam", MySqlDbType.VarChar); cmd.Parameters["?Gebruikersnaam"].Value …
|