How to add data from sql databse to textbox?

Question

1.00/5 (1 vote)

See more:

Hello. I want to fetch data from database and display it in a textbox but data should be specific for different users ie for different users different data should be displayed...how to do?? please help me...

Posted 7-Mar-13 17:56pm

apjitin

Add a Solution

Comments

Nandakishore G N 8-Mar-13 0:47am

what have you done till now paste it?

apjitin 8-Mar-13 1:28am

This is only rough.Please help me out.
protected void Page_Load(object sender, EventArgs e)
{

string user=Userverify.GetUser(username);
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["userdatabase"].ConnectionString);
string command = "Select Portcode,Portname Userinfo.Username from Portinfo JOIN Userinfo ON Userinfo.Portcode=Portinfo.Portcode where Username=user";
SqlCommand cmd = new SqlCommand(command,con);
con.Open();
SqlDataAdapter dad = new SqlDataAdapter(cmd);
res = new DataTable();
dad.Fill(res);
while (res.Rows.Count==1)
{
tpc.Text = res.Rows[0]["Portcode"].ToString();
tpn.Text = res.Rows[0]["Portname"].ToString();
}
con.Close();
}

S. M. Ahasan Habib 8-Mar-13 1:34am

You can store user specific data to your database and user wise fetch that data and set it to the textbox. If your datasource has non user specific data then you need to transform it to your business layer and display it to the page text box.

2 solutions

Solution 2

You need to start from ado.net basics. Start here
Using ADO.NET for beginners[^]
A Beginner's Tutorial for Understanding ADO.NET[^]

Posted 7-Mar-13 18:38pm

bbirajdar

Add a Solution

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

Avik Ghosh22 · Accepted Answer · 2013-03-07T18:24:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

public partial class rnd : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(---------------------------------------);
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlCommand cmd = new SqlCommand("SELECT * FROM RNDTABLE", con);//collect userid/username using session or querystring and use where clause in this query
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
       textbox.Text=dt.Rows[0]["name"].Tostring();//return user ame in to textbox 
    }
}

How to add data from sql databse to textbox?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to add data from sql databse to textbox?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us