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 OriginalGriff 723
1 George Jonsson 370
2 BillWoodruff 277
3 Garth J Lancaster 250
4 Sergey Alexandrovich Kryukov 249
0 Sergey Alexandrovich Kryukov 10,764
1 Maciej Los 5,474
2 OriginalGriff 5,472
3 CPallini 3,819
4 BillWoodruff 3,594


Advertise | Privacy | Mobile
Web04 | 2.8.141030.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