|
How to store and retrive multilinetext(Not single line) from textbox in to sql server.
|
|
|
|
|
Hi,
depends on how the user entered the text. If he used "Return" to do a line break, the character for this well be stored in the database. So when you read the value from your db again and place it into the textbox the text will be formatted as before.
If the user didn't use "Return" the textbox will do a line break automatically, so within your db the text will be stored without the line break. But if you put the text back into the textbox the text will be formatted as before.
So after all you don't have to do anything special with your db to support multiline text (it is just a matter of your UI formatting the text).
So my question is: What do you want to achieve?
Regards
Sebastian
|
|
|
|
|
When i enter
shankar,
India,
641636.
means its stored in db but i can't retrive it again.
but when i entered like this means,
shankar,India,641636.
I can able to retrive it from db.
so how to solve this problem?
|
|
|
|
|
Hi,
you can retrieve both inputs from your db. If you debug your app you will see that when entering the first input it will be retrieved like this "shankar\r\nIndia\r\n641636". The value you put in your db is the same you will retrieve.
So you did you tried it and it doesn't work? If yes, maybe you could post a bit of your code...
Regards
Sebastian
|
|
|
|
|
<asp:TextBox ID="TextBox6address" runat="server" Height="72px" TextMode="MultiLine" Width="178px" MaxLength="500"></asp:TextBox></td>
<td style="width: 207px; height: 54px">
cmd = new SqlCommand("insert into AdminAccount (UserName,Password,Email,Address,City,Pincode,PhoneNo,MobileNo) values('" + TextBox1username.Text.ToString() + "','" + TextBox2password.Text.ToString() + "','" + TextBox4email.Text.ToString() + "','" + TextBox6address.Text.ToString() + "','" + TextBox7city.Text.ToString() + "','" + TextBox8pincode.Text.ToString() + "','" + TextBox9phoneno.Text.ToString() + "','" + TextBox10mobileno.Text.ToString() + "')", con);
Datatype is varchar(Max)
Textbox's textmode is Multiline
|
|
|
|
|
1. Why are you using Textbox.Text.ToString()? Textbox.Text should be sufficient.
2. Wouldn't use string-concatenation for all the values. Maybe using PreparedStatements will be better (SQL-Injection)
3. Did you try to debug your app, before you store the value? Does this value contains the "\r\n" I mentioned before?
4. Abhijit mentioned an answer he gave to you before? How did you add the code he mentioned to yours?
|
|
|
|
|
kavinnagarajan wrote: How to store and retrive multilinetext(Not single line) from textbox in to sql server
Did you tried the way I have suggested to two days back ?
|
|
|
|
|
Its not working correctly for me. Please send a code for this
|
|
|
|
|
kavinnagarajan wrote: Its not working correctly for me
Then you should asked me over there, rather than creating a new thread. .
I do a good followup
|
|
|
|
|
|
No Problem.
|
|
|
|
|
But still i cant resolve from that problem
so please send a sample code for that, how to store & retrive multiline text from textbox in to sql server
|
|
|
|
|
Hi Abhijit,
could you link to that message? Maybe then I get a clue where the problem could be?
Regards
Sebastian
|
|
|
|
|
|
Thanks for the links... Seems like the problem itself is not really clear...
|
|
|
|
|
He's obviously a moron.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I'm calling webserivce using javascript.it's working fine.
here i'm populating the dropdown using the result of webservice.
and added a (Select from list) item to dropdown.In the dropdown onchange event i'm calling the webservice to fill the another dropdown,
here is the problem.when i'm selecting the (select from list) item.no need to call the webserivce and clear the second dropdown list.In this situation i'm planning to use same javascript method to clear the second dropdown.
here my javascript
function Users_Check(result)
{
if(result.error)
{
alert('Error occured while processing.Error Description :-' + result.errorDetail.string);
return false;
}
else
{
if(result.value!=null)
{
if(result.value.length>0)
{
if(result.value[0].length>0)
{
var tOptArr=result.value[0].split('~');
document.getElementById('ddlGroups').options.length = 0;
for(var iLoop=0;iLoop<tOptArr.length;iLoop++)
{
var opt = document.createElement('option');
document.getElementById('ddlGroups').options.add(opt);
opt.text=tOptArr[iLoop];
}
}
return false;
}
}
else
{
alert('Unable to get the required information. Check the page scripts.');
return false;
}
}
}
this code will call through webserivce
but i my case
i need to call manually.how can pass the result to this method..
|
|
|
|
|
how to put drop down list what is the coding for that
|
|
|
|
|
rajni_nanu wrote: how to put drop down list what is the coding for that
Where do you want to put dropdownlist ? In a page ? and you want code for it ?
|
|
|
|
|
i want to put it on page and want code for that
|
|
|
|
|
If you're too stupid to work this out with google, then there's really not any point in anyone telling you how to do this. You just HAVE to be kidding.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
rajni_nanu wrote: i want to put it on page and want code for that
<asp:DropDownList ID="ddlLsit" runat="Server" >
<asp:ListItem>FirstOption</asp:ListItem>
<asp:ListItem>SecondOption</asp:ListItem>
</asp:DropDownList>
I will suggest you to buy some beginners ASP.NET Book and start reading.
|
|
|
|
|
How to send free SMS using asp.net?
|
|
|
|
|
|
I tried it already but its not working.
|
|
|
|