Click here to Skip to main content
13,005,920 members (95,260 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Dear Friends,

I am making WebPage which store detail of Client in SqlDataSource.I am using TextBox for Name,Address,Contact No.. I want to know how we can bind TextBox to SqlDataSource?.

Posted 24-Sep-11 20:35pm
Thiyagarajan.rk 25-Sep-11 4:11am
If you want insert the data?
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

create a server side text Box control
<asp:textbox id="txtName" runat="server" xmlns:asp="#unknown"></asp:textbox>

create a datasource
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
SelectCommand="SELECT * FROM [PersonalDetails]" >

write in codebehind page on Page load event write the below code
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
     Dim dv As DataView =      DirectCast(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)
     For Each drv As DataRowView In dv
          txtName.Text = drv("Name").ToString()
End Sub

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170628.1 | Last Updated 10 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100