hello
is it possible to to bind a single field from a database table to a textbox.
I am trying to open a web form with five textboxes on it. When it loads is it possible to have the textboxes filled with a different field from a row in a database, selected with a sql statment.
Thanks in advance NubNub
Wrong Forum.|||Yes, that is quite possible.
But you will get better assistance if you post your question in one of the .NET ASP related forums.
sqlI want to bind some data to a text box from sql server db. but when i run the page i get an error. here is my code.
<formid="form1"runat="server"><div><asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:imacsConn %>"SelectCommand="SELECT Reportnumber FROM [SummaryBlue] WHERE REPORTNUMBER = @.REPORTNUMBER"><SelectParameters><asp:QueryStringParameterName="REPORTNUMBER"QueryStringField="REPORTNo"Type="String"/></SelectParameters></asp:SqlDataSource><asp:TextBoxID="TextBox1"runat="server"Columns="<%$ ConnectionStrings:imacsConn %>"></asp:TextBox></div></form>
Error:
Exception Details:System.FormatException: Input string was not in a correct format.
Source Error:
Line 25: </SelectParameters>Line 26: </asp:SqlDataSource>Line 27: <asp:TextBox ID="TextBox1" runat="server" Columns="<%$ ConnectionStrings:imacsConn %>"></asp:TextBox></div>Line 28: </form>
The Columns property of a text box is how many characters wide it should be (an integer property). You are trying to assign it a string.
<asp:TextBoxID="TextBox1"runat="server"Columns="<%$ ConnectionStrings:imacsConn %>">
|||Hi xbhavesh,
From your description, I understand you want to bind data to single TextBox. Base on my experience and research, SqlDataSource can be binded to List data-bound controls, but TextBox is not belong to them. So I think we cannot simply bind data to TextBox from SqlDataSource.
I find two solutions and hope they are helpful to you.
1. Bind the DataSource to a GridView, and then bind the GridView cell value to TextBox. Don't forget set GridView to not visible and call DataBind method when Page Load. Here is the sample code:
<asp:TextBoxID="TextBox1"runat="server"Text='<% #GridView1.Rows[0].Cells[0].Text%>'></asp:TextBox>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:testConnectionString%>"
SelectCommand="SELECT [id] FROM [Table1] WHERE ([id] = 2)">
</asp:SqlDataSource>
<asp:GridViewID="GridView1"Visible="false"runat="server"DataSourceID="SqlDataSource1">
</asp:GridView>
protectedvoid Page_Load(object sender,EventArgs e)
{
TextBox1.DataBind();
}
2. Create your custom control to inherit DataBoundControl:
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.databoundcontrol.aspx
P.S. We should bind to the Text property, not Columns.
I have search for answers to the all over google and every thing I have found so far did not work for some reason or anothr. .
Here is what I am looking for I am codeing in Visual Studio using C#. I have been able to crate a connection and create taxt boxes with a submit button that when it is presed enters data in to a database (Sql server) what I have been unable to do is:
1. Display data in a text box.
2. Update data
3. create buttons to navagate through fields.
I know I can do this with the gridview or datagrid but in really need a custome form for what I am doing.
Hello,
You can use a Sqldatasource to do insert, update and delete for your textboxes. You can read the data from datasource through a datareader object and bind the data you your textboxes manually. For example, txtComments.Text =Convert.ToString(dReader["Comments"]).
You can call Sqldatsource.update() to update your form data when your tesxboxes' values have been changed.
You can create a linkbutton to send in some sort of id to the page on its click event to retrieve data for these textboxes.
Or you can do everything from code behind as in ASP.NET 1.X programmatically.
If you have more questions, please post back.
Hi all,
I would like to do something I thought was simple but I can't seem to figure it out. I would like to bind the Text properties to two labels to the columns in an SqlDataSource, much the same as you can bind a listbox to a SqlDataSource.
Is this possible?
The reason why I'm trying it this way is because I originally used an OleDB connection and datareader, but it doesn't seem to work on our service providers server (keeps saying that it can't find the database) even though it works on the four other server's I've tried. It definitely connects to the database when I use the SqlDataSource on a listbox control, but it fails when I use the same connection string with the OleDB connection.
Is this the best way to go about it, or should I persist with finding the OleDB/datareader (the service provider has been no help at all).
Thanks.
If you want to use SqlDataSource, why not bind SqlDataSource with GridView? So that you can view all records:<asp:SqlDataSource ID="mySDS" runat="server" ConnectionString="<%$ ConnectionStrings:Conn2000 %>"
SelectCommand="SELECT FirstName, LastName, Title FROM Employees">
</asp:SqlDataSource>
<asp:GridView runat="server" ID="myGV" DataSourceID="mySDS" AutoGenerateColumns="true">
</asp:GridView
BTW, what's the exception you got when connecting with OleDB connection? OleDB connection string can differ from SqlDataSource connection string, you can check http://www.connectionstrings.com/
float i = (float)Convert.ToDouble(textBox1.Text);
and insert number 12,3 in my table I have following number 12.30000000000032324!
What I must to do with this conversion and have in my table number 12,3?
Hi,
although this is not a C# forum, you should take a look at the Help for a more precise datatype than float.
http://msdn2.microsoft.com/en-us/library/b1e65aza.aspx
In addition see the float definition in the BOL for more information about float in SQL Server.
You might want to have a look on the decimal type instead.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
You can full text search enable the database, and create a full text index on the column in the table you want to search. Then you will be able to search any word that appears inside that column. Here are a couple of links that might be helpful to you.
http://www.databasejournal.com/features/mssql/article.php/3441981
http://www.wherecanibuyit.co.uk/ASP/full-text-search.html
http://msdn2.microsoft.com/en-us/library/ms177652.aspx
|||Hi
Thanks for that, it was a great help
I have noticed that their is a RowNumber method in SQL 2005, is their any way to do this functionality in SQL 2000
One method I thought of was to put the data in temp table and loop through each record and give it a number, and then pull out 10 records at a time as the user pages through.
Are their any other ways I could do this.
Many thanks in advance
|||The short answer is yes. You may want to search for articles on Custom Paging with SQL Server 2000. There are ways to do it, but they are not as simple or clean as the ROW_NUMBER() function. Here is an article to get you started.
http://www.4guysfromrolla.com/webtech/042606-1.shtml