学C#，碰到问题：
In the Formview, I have a field thats with Checkbox. In the database this column is named 'Status' with Tinyint as datatype. Now, when I show particular item from database to the screen, I do this:- <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Convert.ToBoolean(Eval("status")) %>' />
The problem is when I like to save. VS generate the code for me as below:- <asp:SqlDataSource ID="SqlDataSource1" runat="server"
- ConnectionString="<%$ ConnectionStrings:testdemoConnectionString %>"
- SelectCommand="SELECT * FROM [test_table_1] WHERE ([id] = @id)"
- DeleteCommand="DELETE FROM [test_table_1] WHERE [id] = @id"
- InsertCommand="INSERT INTO [test_table_1] ([name], [email], [status]) VALUES (@name, @email, @status)"
- UpdateCommand="UPDATE [test_table_1] SET [name] = @name, [email] = @email, [status] = @status WHERE [id] = @id">
|
