Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help please :)

Author  Topic 

lars_toreh
Starting Member

29 Posts
Posted - 2010-01-13 : 15:34:29
I have started a large project.
My database is rather simple,with 16 columns including IDcolumn in one table.
The IDcolumn has identity.

I have 14 textboxes,that I want to transfer data from to the database with a buttonclick,and there is my problem.

Here is the page:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="CarsID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Cars" HeaderText="Cars" SortExpression="Cars" />
<asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" />
<asp:BoundField DataField="-1900" HeaderText="-1900" SortExpression="-1900" />
<asp:BoundField DataField="1900" HeaderText="1900" SortExpression="1900" />
<asp:BoundField DataField="1910" HeaderText="1910" SortExpression="1910" />
<asp:BoundField DataField="1920" HeaderText="1920" SortExpression="1920" />
<asp:BoundField DataField="1930" HeaderText="1930" SortExpression="1930" />
<asp:BoundField DataField="1940" HeaderText="1940" SortExpression="1940" />
<asp:BoundField DataField="1950" HeaderText="1950" SortExpression="1950" />
<asp:BoundField DataField="1960" HeaderText="1960" SortExpression="1960" />
<asp:BoundField DataField="1970" HeaderText="1970" SortExpression="1970" />
<asp:BoundField DataField="1980" HeaderText="1980" SortExpression="1980" />
<asp:BoundField DataField="1990" HeaderText="1990" SortExpression="1990" />
<asp:BoundField DataField="2000" HeaderText="2000" SortExpression="2000" />
<asp:BoundField DataField="2010-" HeaderText="2010-" SortExpression="2010-" />
</Columns>
</asp:GridView>
<br />
<br />
Cars: <asp:TextBox ID="carsTB" runat="server"></asp:TextBox>
<br />
<br />
Notes: <asp:TextBox ID="notesTB" runat="server" Height="66px" TextMode="MultiLine"
Width="289px"></asp:TextBox>
<br />
<br />
-1900: <asp:TextBox ID="tb1" runat="server"></asp:TextBox>
<br />
<br />
1910: <asp:TextBox ID="tb2" runat="server"></asp:TextBox>
<br />
<br />
1920: <asp:TextBox ID="tb3" runat="server"></asp:TextBox>
<br />
<br />
1930: <asp:TextBox ID="tb4" runat="server"></asp:TextBox>
<br />
<br />
1940: <asp:TextBox ID="tb5" runat="server"></asp:TextBox>
<br />
<br />
1950: <asp:TextBox ID="tb6" runat="server"></asp:TextBox>
<br />
<br />
1960: <asp:TextBox ID="tb7" runat="server"></asp:TextBox>
<br />
<br />
1970: <asp:TextBox ID="tb8" runat="server"></asp:TextBox>
<br />
<br />
1980: <asp:TextBox ID="tb9" runat="server"></asp:TextBox>
<br />
<br />
1990: <asp:TextBox ID="tb10" runat="server"></asp:TextBox>
<br />
<br />
2000: <asp:TextBox ID="tb11" runat="server"></asp:TextBox>
<br />
<br />
2010-: <asp:TextBox ID="tb12" runat="server"></asp:TextBox>
<br />
<br />
<br />
<asp:Button ID="Button1" runat="server" Text="Save" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:CarsvsToycarsConnectionString5 %>"
DeleteCommand="DELETE FROM [Cars] WHERE [CarsID] = @original_CarsID AND (([Cars] = @original_Cars) OR ([Cars] IS NULL AND @original_Cars IS NULL)) AND (([Notes] = @original_Notes) OR ([Notes] IS NULL AND @original_Notes IS NULL)) AND (([-1900] = @original_column1) OR ([-1900] IS NULL AND @original_column1 IS NULL)) AND (([1900] = @original_column2) OR ([1900] IS NULL AND @original_column2 IS NULL)) AND (([1910] = @original_column3) OR ([1910] IS NULL AND @original_column3 IS NULL)) AND (([1920] = @original_column4) OR ([1920] IS NULL AND @original_column4 IS NULL)) AND (([1930] = @original_column5) OR ([1930] IS NULL AND @original_column5 IS NULL)) AND (([1940] = @original_column6) OR ([1940] IS NULL AND @original_column6 IS NULL)) AND (([1950] = @original_column7) OR ([1950] IS NULL AND @original_column7 IS NULL)) AND (([1960] = @original_column8) OR ([1960] IS NULL AND @original_column8 IS NULL)) AND (([1970] = @original_column9) OR ([1970] IS NULL AND @original_column9 IS NULL)) AND (([1980] = @original_column10) OR ([1980] IS NULL AND @original_column10 IS NULL)) AND (([1990] = @original_column11) OR ([1990] IS NULL AND @original_column11 IS NULL)) AND (([2000] = @original_column12) OR ([2000] IS NULL AND @original_column12 IS NULL)) AND (([2010-] = @original_column13) OR ([2010-] IS NULL AND @original_column13 IS NULL))"
InsertCommand="INSERT INTO [Cars] ([Cars], [Notes], [-1900], [1900], [1910], [1920], [1930], [1940], [1950], [1960], [1970], [1980], [1990], [2000], [2010-]) VALUES (@Cars, @Notes, @column1, @column2, @column3, @column4, @column5, @column6, @column7, @column8, @column9, @column10, @column11, @column12, @column13)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [Cars] ORDER BY [Cars]"
UpdateCommand="UPDATE [Cars] SET [Cars] = @Cars, [Notes] = @Notes, [-1900] = @column1, [1900] = @column2, [1910] = @column3, [1920] = @column4, [1930] = @column5, [1940] = @column6, [1950] = @column7, [1960] = @column8, [1970] = @column9, [1980] = @column10, [1990] = @column11, [2000] = @column12, [2010-] = @column13 WHERE [CarsID] = @original_CarsID AND (([Cars] = @original_Cars) OR ([Cars] IS NULL AND @original_Cars IS NULL)) AND (([Notes] = @original_Notes) OR ([Notes] IS NULL AND @original_Notes IS NULL)) AND (([-1900] = @original_column1) OR ([-1900] IS NULL AND @original_column1 IS NULL)) AND (([1900] = @original_column2) OR ([1900] IS NULL AND @original_column2 IS NULL)) AND (([1910] = @original_column3) OR ([1910] IS NULL AND @original_column3 IS NULL)) AND (([1920] = @original_column4) OR ([1920] IS NULL AND @original_column4 IS NULL)) AND (([1930] = @original_column5) OR ([1930] IS NULL AND @original_column5 IS NULL)) AND (([1940] = @original_column6) OR ([1940] IS NULL AND @original_column6 IS NULL)) AND (([1950] = @original_column7) OR ([1950] IS NULL AND @original_column7 IS NULL)) AND (([1960] = @original_column8) OR ([1960] IS NULL AND @original_column8 IS NULL)) AND (([1970] = @original_column9) OR ([1970] IS NULL AND @original_column9 IS NULL)) AND (([1980] = @original_column10) OR ([1980] IS NULL AND @original_column10 IS NULL)) AND (([1990] = @original_column11) OR ([1990] IS NULL AND @original_column11 IS NULL)) AND (([2000] = @original_column12) OR ([2000] IS NULL AND @original_column12 IS NULL)) AND (([2010-] = @original_column13) OR ([2010-] IS NULL AND @original_column13 IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_CarsID" Type="Int32" />
<asp:Parameter Name="original_Cars" Type="String" />
<asp:Parameter Name="original_Notes" Type="String" />
<asp:Parameter Name="original_column1" Type="String" />
<asp:Parameter Name="original_column2" Type="String" />
<asp:Parameter Name="original_column3" Type="String" />
<asp:Parameter Name="original_column4" Type="String" />
<asp:Parameter Name="original_column5" Type="String" />
<asp:Parameter Name="original_column6" Type="String" />
<asp:Parameter Name="original_column7" Type="String" />
<asp:Parameter Name="original_column8" Type="String" />
<asp:Parameter Name="original_column9" Type="String" />
<asp:Parameter Name="original_column10" Type="String" />
<asp:Parameter Name="original_column11" Type="String" />
<asp:Parameter Name="original_column12" Type="String" />
<asp:Parameter Name="original_column13" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Cars" Type="String" />
<asp:Parameter Name="Notes" Type="String" />
<asp:Parameter Name="column1" Type="String" />
<asp:Parameter Name="column2" Type="String" />
<asp:Parameter Name="column3" Type="String" />
<asp:Parameter Name="column4" Type="String" />
<asp:Parameter Name="column5" Type="String" />
<asp:Parameter Name="column6" Type="String" />
<asp:Parameter Name="column7" Type="String" />
<asp:Parameter Name="column8" Type="String" />
<asp:Parameter Name="column9" Type="String" />
<asp:Parameter Name="column10" Type="String" />
<asp:Parameter Name="column11" Type="String" />
<asp:Parameter Name="column12" Type="String" />
<asp:Parameter Name="column13" Type="String" />
<asp:Parameter Name="original_CarsID" Type="Int32" />
<asp:Parameter Name="original_Cars" Type="String" />
<asp:Parameter Name="original_Notes" Type="String" />
<asp:Parameter Name="original_column1" Type="String" />
<asp:Parameter Name="original_column2" Type="String" />
<asp:Parameter Name="original_column3" Type="String" />
<asp:Parameter Name="original_column4" Type="String" />
<asp:Parameter Name="original_column5" Type="String" />
<asp:Parameter Name="original_column6" Type="String" />
<asp:Parameter Name="original_column7" Type="String" />
<asp:Parameter Name="original_column8" Type="String" />
<asp:Parameter Name="original_column9" Type="String" />
<asp:Parameter Name="original_column10" Type="String" />
<asp:Parameter Name="original_column11" Type="String" />
<asp:Parameter Name="original_column12" Type="String" />
<asp:Parameter Name="original_column13" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Cars" Type="String" />
<asp:Parameter Name="Notes" Type="String" />
<asp:Parameter Name="column1" Type="String" />
<asp:Parameter Name="column2" Type="String" />
<asp:Parameter Name="column3" Type="String" />
<asp:Parameter Name="column4" Type="String" />
<asp:Parameter Name="column5" Type="String" />
<asp:Parameter Name="column6" Type="String" />
<asp:Parameter Name="column7" Type="String" />
<asp:Parameter Name="column8" Type="String" />
<asp:Parameter Name="column9" Type="String" />
<asp:Parameter Name="column10" Type="String" />
<asp:Parameter Name="column11" Type="String" />
<asp:Parameter Name="column12" Type="String" />
<asp:Parameter Name="column13" Type="String" />
</InsertParameters>
</asp:SqlDataSource>

The code behind:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("CarsvsToycarsConnectionString5").ConnectionString)
conn.Open()

Dim cars As String = carsTB.Text
Dim notes As String = notesTB.Text
Dim decade1 As String = tb1.Text
Dim decade2 As String = tb2.Text
Dim decade3 As String = tb3.Text
Dim decade4 As String = tb4.Text
Dim decade5 As String = tb5.Text
Dim decade6 As String = tb6.Text
Dim decade7 As String = tb7.Text
Dim decade8 As String = tb8.Text
Dim decade9 As String = tb9.Text
Dim decade10 As String = tb10.Text
Dim decade11 As String = tb11.Text
Dim decade12 As String = tb12.Text

Dim SQL As String = "INSERT INTO Cars (Cars, Notes, -1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980, 1990, 2000, 2010-) VALUES ('" & cars & "' ,'" & notes & "' ," & -1900 & " ," & 1910 & "," & 1920 & "," & 1930 & "," & 1940 & "," & 1950 & "," & 1960 & "," & 1970 & "," & 1980 & "," & 1990 & "," & 2000 & "," & 2010 - ")"

End Sub

Can someone please tell me what I`m doing wrong or help me code the button?Thanks in advanced

PS: Don`t want to use the insert in the gridview.
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site