Skip to content

Instantly share code, notes, and snippets.

@swaters86
Created June 4, 2020 16:55
Show Gist options
  • Save swaters86/90c536549032cd9c860a780d00a81a5c to your computer and use it in GitHub Desktop.
Save swaters86/90c536549032cd9c860a780d00a81a5c to your computer and use it in GitHub Desktop.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="GridViewTest.WebForm1" %>
<!DOCTYPE html>
<script runat="server">
void AddWindow_Click(Object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection("Server=LAPTOP-53EAQ51T;Database=films;Trusted_Connection=True;");
StartDate.Text = "2007-05-02T19:58:47.1234567";
EndDate.Text = "2007-05-02T19:58:47.1234567";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@StartDate", StartDate.Text);
cmd.Parameters.AddWithValue("@EndDate", EndDate.Text);
cmd.Parameters.AddWithValue("@Sunday", Sunday.Text);
cmd.Parameters.AddWithValue("@Monday", Monday.Text);
cmd.Parameters.AddWithValue("@Tuesday", Tuesday.Text);
cmd.Parameters.AddWithValue("@Wednesday", Wednesday.Text);
cmd.Parameters.AddWithValue("@Thursday", Thursday.Text);
cmd.Parameters.AddWithValue("@Friday", Friday.Text);
cmd.Parameters.AddWithValue("@Satruday", Saturday.Text);
cmd.CommandText = @"INSERT maintence_windows(starttime, endtime, sunday, monday, tuesday, wednesday, thursday, friday, saturday) VALUES ('2007-05-02 19:58:47.1234567', '2007-05-02 19:58:47.1234567', 0, 0, 0, 0, 0, 0, 0)";
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
FilmsGridView.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<label>Start Date:</label>
<asp:TextBox ID="StartDate" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
</div>
<div>
<label>End Date:</label>
<asp:TextBox ID="EndDate" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
</div>
<div>
<label>Sunday</label>
<asp:TextBox ID="Sunday" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
<label>Monday</label>
<asp:TextBox ID="Monday" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
<label>Tuesday</label>
<asp:TextBox ID="Tuesday" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
<label>Wed</label>
<asp:TextBox ID="Wednesday" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
<label>Thursday</label>
<asp:TextBox ID="Thursday" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
<label>Friday</label>
<asp:TextBox ID="Friday" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
<label>Satruday</label>
<asp:TextBox ID="Saturday" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
</div>
<div>
<label>Sunday</label>
<asp:TextBox ID="TextBox1" ValidationGroup="maintanencewindows" runat="server"></asp:TextBox>
</div>
<asp:Button ID="AddWindow" Text="Submit" OnClick="AddWindow_Click" runat="server" />
<asp:sqldatasource id="FilmSource"
selectcommand="SELECT starttime, endtime, sunday, monday, tuesday, wednesday, thursday, friday, saturday FROM maintence_windows"
connectionstring="Server=LAPTOP-53EAQ51T;Database=films;Trusted_Connection=True;"
runat="server"/>
<asp:gridview id="FilmsGridView"
datasourceid="FilmSource"
autogeneratecolumns="True"
emptydatatext="No data available."
allowpaging="True"
runat="server" DataKeyNames="starttime">
</asp:gridview>
</form>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment