Hello friends,
i am not able to get data into database after clicking button. following is code for that. please help me for this problem
This is .aspx file codes
==============================
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>
<!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 runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<p>
no
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</p>
<p>
name
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</p>
<p>
<asp:Button ID="Button1" runat="server" Text="Button" />
</p>
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
InsertCommand="INSERT INTO Table1([no], name) VALUES (,)"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT [no], name FROM Table1">
<InsertParameters>
<asp:Parameter Name="no" />
<asp:Parameter Name="name" />
</InsertParameters>
</asp:SqlDataSource>
<br />
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
no:
<asp:Label ID="noLabel" runat="server" Text='<%# Eval("no") %>' />
<br />
name:
<asp:Label ID="nameLabel" runat="server" Text='<%# Eval("name") %>' />
<br />
<br />
</ItemTemplate>
</asp:DataList>
</div>
======================================
.vb file code
-----------
Imports System.Data.OleDb
Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
SqlDataSource1.InsertParameters("no").DefaultValue = TextBox1.Text
SqlDataSource1.InsertParameters("name").DefaultValue = TextBox2.Text
End Sub
End Class
</form>
</body>
</html>