show text instead of value in gridview

C# Corner

Garima Bansal

3y1.1kASP.NET

I have a gridview that gets the data from a database and it has SectorId, name,mobile

But in Database table SectorId is save in Value and i want text in Gridview on pageload

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh3y ago

Accepted answer

step 1:- Modify Gridview Bound field as

step 2:- Bind GridView in page load as

using(SqlConnection con=new SqlConnection(cs))
{
SqlCommand cmd=new SqlCommand("SELECT t2.Name as SectorName, t1.Name, Mobile_No, Grievance_Details as Details, Status FROM GrievanceDetails t1 inner join Sectors t2 on t1.Id = t2.Id",con);
con.Open();
grdtrack.DataSource=cmd.ExecuteReader();
grdtrack.DataBind();

}

Garima Bansal3y ago
SELECT t2.Name as Name, Name, Mobile_No, Grievance_Details,
Status FROM GrievanceDetails t1 inner join Sectors t2 on t1.Id = t2.Id WHERE Id = @Id

error i am geeting "Must declare the scalar variable "@Id"."
+1
Garima Bansal3y ago
SELECT t2.Name as Name, Name, Mobile_No, Details, Status FROM GrievanceDetails t1 inner join Sectors t2 on t1.Id = t2.Id WHERE Id = @Id //error

+1
Jignesh Kumar3y ago
can you please share code where you are getting error ?
+1
Garima Bansal3y ago
Jignesh Kumar

getting an error in sql query "scalar variable"
+1

Jignesh Kumar3y ago

Hi,

You need to add sectorname in your sql query, Use join to get sectore name based on sectorId,

SELECT t2.Name as SectorName, Name, Mobile_No, Details, Status FROM YourOtherTableName t1
inner join SectorTable t2 on t1.SectorId= t2.Id -- Join is used to get data from two tablse based on common column
WHERE Id = @Id