Hi all,
I have tried to do a test to a lesson which was in the internet, but it doesn't work?
ANYBody here to help please??
The problem that what I enter in the textbox should be sent to the database to be stored, but it doesn't.!!! I don't know why
the aspx. page...
the aspx.cs file code
and I have a database with
"Emp" as table name
"Sno" as int type
"Name" as varchar(50) type
"Age" as int type
"Salary" as money type
I have tried to do a test to a lesson which was in the internet, but it doesn't work?
ANYBody here to help please??
The problem that what I enter in the textbox should be sent to the database to be stored, but it doesn't.!!! I don't know why
the aspx. page...
Code:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Panel runat ="server" ID="panel1">
<asp:label ID="label1" runat="server" Font-Size="XX-Large">Data Entry Form</asp:label><br /><br />
Sno : <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br /><br />
Name : <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br /><br />
Age : <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br /><br />
Salary<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox><br /><br />
<asp:Button ID="Button1" runat="server" Text="Insert Record" />
</asp:Panel>
</div>
</form>
</body>
</html>
the aspx.cs file code
Code:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Default4 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("Select * from Emp", "Server=localhost; database=CV; integrated security=true;");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.FillSchema(ds, SchemaType.Source);
DataRow dr = ds.Tables[0].NewRow();
dr[0] = int.Parse(TextBox1.Text);
dr[1] = TextBox2.Text;
dr[2] = int.Parse(TextBox3.Text);
dr[3] = double.Parse(TextBox4.Text);
ds.Tables[0].Rows.Add(dr);
try
{
da.Update(ds);
}
catch (Exception ex)
{
Response.Write(ex.Message);
return;
}
Response.Write("Record Added.");
}
}
and I have a database with
"Emp" as table name
"Sno" as int type
"Name" as varchar(50) type
"Age" as int type
"Salary" as money type
Comment