There is no easier answer to your question. It depends on the datasource, and what you intend to do.
Watching the videos will give you a good understanding about how to design your solution so that it is compatible with your objective.
There are thousands of ways to connect them. You'll need to provide much more data before someone can offer more help. :)
You can also do some research on SQL data Sources. Setting up a connection, Gridview, Formview, DetialsView these are controls that are used to display data. You don't generally output SQL data directly to a textbox.
There is no easier answer to your question. It depends on the datasource, and what you intend to do.
Watching the videos will give you a good understanding about how to design your solution so that it is compatible with your objective.
There are thousands of ways to connect them. You'll need to provide much more data before some can offer more help. :)
You can also do some research on SQL data Sources. Setting up a connection, Gridview, Formview, DetialsView thes are controls that are used to display data. You don't generally output SQL data directly to a textbox.
Good Luck.
1. thank you
2. i did set up my connection and i played a bit with GridView FormView and DetailsView
3.im still looking for some answers on how to connect between them...
i used the SqlDataSource from the ToolBox
Eaxactly, the next step has to do with whether you need to Update, Edit, Delete the results. The controls handle all of this for you by default. Its based in the selection process when you set up the connection, look for the Advanced button. You clcik the
check box to create Update, Delete, Select functionality. Your table will need to have key set and Identity specification for this to work.
Otherwise you can and for example, a button to your web page, and use the button click event to read the data from the gridview, formview, etc, and process it as needed.
tzahi2010
Member
266 Points
287 Posts
Table With TextBoxes
Oct 06, 2011 01:26 PM|LINK
hello i am new to this world of sql server's
and i whould like to know how to connect my Table to a TextBox
march11
Contributor
3015 Points
1364 Posts
Re: Table With TextBoxes
Oct 06, 2011 01:30 PM|LINK
I would suggest you start with some of these. some are short videos others are detialed walk throughs.
great resource that got me started.
http://www.asp.net/web-forms
tzahi2010
Member
266 Points
287 Posts
Re: Table With TextBoxes
Oct 06, 2011 01:39 PM|LINK
I dont see where it tells u about Sql
march11
Contributor
3015 Points
1364 Posts
Re: Table With TextBoxes
Oct 06, 2011 02:09 PM|LINK
Try this one, its 43 minutes in all....
http://www.pluralsight-training.net/microsoft/players/PSODPlayer.aspx?author=dan-wahlin&name=webforms-08&mode=live&clip=0&course=aspdotnet-webforms4-intro
nikunjnandan...
Participant
882 Points
223 Posts
Re: Table With TextBoxes
Oct 06, 2011 02:15 PM|LINK
Hii,
Please refer belo Links.Surely it will help u.
http://www.codeproject.com/KB/aspnet/InsertingWithGridView.aspx
http://www.codeproject.com/KB/vb/sqlcriptnet.aspx
http://www.codeproject.com/KB/database/sql_in_csharp.aspx
Nikunj Nandaniya
My Blog
march11
Contributor
3015 Points
1364 Posts
Re: Table With TextBoxes
Oct 06, 2011 02:16 PM|LINK
This is the link I was first looking for sorry....
http://www.asp.net/general/videos
tzahi2010
Member
266 Points
287 Posts
Re: Table With TextBoxes
Oct 06, 2011 02:20 PM|LINK
its still doesnt answer my question :)
march11
Contributor
3015 Points
1364 Posts
Re: Table With TextBoxes
Oct 06, 2011 02:39 PM|LINK
There is no easier answer to your question. It depends on the datasource, and what you intend to do.
Watching the videos will give you a good understanding about how to design your solution so that it is compatible with your objective.
There are thousands of ways to connect them. You'll need to provide much more data before someone can offer more help. :)
You can also do some research on SQL data Sources. Setting up a connection, Gridview, Formview, DetialsView these are controls that are used to display data. You don't generally output SQL data directly to a textbox.
Good Luck.
tzahi2010
Member
266 Points
287 Posts
Re: Table With TextBoxes
Oct 06, 2011 03:07 PM|LINK
1. thank you
2. i did set up my connection and i played a bit with GridView FormView and DetailsView
3.im still looking for some answers on how to connect between them...
i used the SqlDataSource from the ToolBox
march11
Contributor
3015 Points
1364 Posts
Re: Table With TextBoxes
Oct 06, 2011 03:42 PM|LINK
Eaxactly, the next step has to do with whether you need to Update, Edit, Delete the results. The controls handle all of this for you by default. Its based in the selection process when you set up the connection, look for the Advanced button. You clcik the check box to create Update, Delete, Select functionality. Your table will need to have key set and Identity specification for this to work.
Otherwise you can and for example, a button to your web page, and use the button click event to read the data from the gridview, formview, etc, and process it as needed.