Not sure if anyone else is banging their head or not.
However I here is how to databind a textbox to a SQL Database using a sqldata control.
Here is the code behind:
1: using System;
2: using System.Data;
3: using System.Configuration;
4: using System.Web;
5: using System.Web.Security;
6: using System.Web.UI;
7: using System.Web.UI.WebControls;
8: using System.Web.UI.WebControls.WebParts;
9: using System.Web.UI.HtmlControls;
10:
11: public partial class _Default : System.Web.UI.Page
12: { 13: protected void Page_Load(object sender, EventArgs e)
14: { 15:
16: }
17: protected void Button1_Click(object sender, EventArgs e)
18: { 19: SqlDataSource1.InsertParameters["Title"].DefaultValue = txtTitle.Text.ToString();
20: SqlDataSource1.InsertParameters["Body"].DefaultValue = txtBody2.Text.ToString();
21: SqlDataSource1.InsertParameters["StartDate"].DefaultValue = MyDateStartTB1.Text.ToString();
22: SqlDataSource1.InsertParameters["EndDate"].DefaultValue = MyDateEndTB2.Text.ToString();
23: SqlDataSource1.Insert();
24: }
25: }
ASPX Page:
1: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:local %>"
2:
3:
4: DeleteCommand="DELETE FROM [tblPageContent] WHERE [ID] = @ID" InsertCommand="INSERT INTO [tblPageContent] ([StartDate], [EndDate], [Title], [Body]) VALUES (@StartDate, @EndDate, @Title, @Body)"
5: SelectCommand="SELECT * FROM [tblPageContent]" UpdateCommand="UPDATE [tblPageContent] SET [StartDate] = @StartDate, [EndDate] = @EndDate, [Title] = @Title, [Body] = @Body WHERE [ID] = @ID">
6: <DeleteParameters>
7: <asp:Parameter Name="ID" Type="Int32" />
8: </DeleteParameters>
9: <UpdateParameters>
10: <asp:Parameter Name="StartDate" Type="DateTime" />
11: <asp:Parameter Name="EndDate" Type="DateTime" />
12: <asp:Parameter Name="Title" Type="String" />
13: <asp:Parameter Name="Body" Type="String" />
14: <asp:Parameter Name="ID" Type="Int32" />
15: </UpdateParameters>
16: <InsertParameters>
17: <asp:Parameter Name="StartDate" Type="DateTime" />
18: <asp:Parameter Name="EndDate" Type="DateTime" />
19: <asp:Parameter Name="Title" Type="String" />
20: <asp:Parameter Name="Body" Type="String" />
21: </InsertParameters>
22: </asp:SqlDataSource>
Thanks for the help from:
Connect SQL Datasource