Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
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?.
 
Thankyou,
Posted 24-Sep-11 20:35pm
Comments
Thiyagarajan.rk at 25-Sep-11 4:11am
   
If you want insert the data?
Rate this: bad
good
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]" >
</asp:SqlDataSource>
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()
     Next
End Sub
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 676
1 OriginalGriff 385
2 CPallini 240
3 PIEBALDconsult 150
4 Magic Wonder 131
0 OriginalGriff 5,835
1 Sergey Alexandrovich Kryukov 5,198
2 CPallini 4,740
3 George Jonsson 3,167
4 Gihan Liyanage 2,470


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 10 Dec 2012
Copyright © CodeProject, 1999-2014
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