linq to sql in C# for text box

Question

0.00/5 (No votes)

See more:

C#

Please discribe with example how to populate text box with data from data base with linq to sql in c#?

Posted 26-Mar-13 20:15pm

Hodamdi

Add a Solution

Comments

Chamika Sandamal 27-Mar-13 2:44am

Better you try something before just putting questions

Prasad Khandekar 27-Mar-13 2:48am

Just search on MSDN library. You can find many examples in the LINQ documentation.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Chamika Sandamal · Accepted Answer · 2013-03-26T21:10:00

Solution 1

You can try following code sample,

XML

DataClasses1DataContext dc = new DataClasses1DataContext();
var q = (from a in dc.GetTable<Order>()
        where a.Number== number
        select a).SingleOrDefault();
textBox1.Text= q.Something;

Posted 26-Mar-13 21:10pm

Chamika Sandamal

Comments

Hodamdi 27-Mar-13 4:28am

tanx for your replay but i have 2 text box and i want to type code in txtEstateCode and after pressing enter key i should see Estatename in another txtEstatename i wrote bellow code :

private void txtEstateCode_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)13)
{

txtEstateName.Text = GiveEstateName(txtEstateCode.Text);
}
}
public dynamic GiveEstateName(string EstateCode)
{
using (DataLink.AsamLinqDataContext Dc = new DataLink.AsamLinqDataContext())
{
var EName = (from Estate_Info in Dc.Estate_Infos
where Estate_Info.Code == txtEstateCode.Text
select new { EI = Estate_Info.EstateName}) // txtEstateName.DataBindings.Clear();
//txtEstateName.DataBindings.Add("Text", EName, "EI");
return EName;
}

}
but it doesnt work.

Chamika Sandamal 27-Mar-13 4:41am

Try adding .FirstOrDefault(),
var EName = (from Estate_Info in Dc.Estate_Infos
where Estate_Info.Code == txtEstateCode.Text
select new { EI = Estate_Info.EstateName}).FirstOrDefault();

Hodamdi 28-Mar-13 0:33am

tanx for your help ,
my problem solved .

Chamika Sandamal 28-Mar-13 1:34am

then mark it as answer

Member 14174211 2-Apr-19 6:15am

I want to display filtered records searched via textbox and display result from database in a gridview using linQ