C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

help me out

Posted Date: 25 Jul 2008 Total Responses: 2

Posted By: janu Member Level: Silver Points: 1

string QUpdate = "select ('" + GrdCmplnts.CurrentRow.Cells[3].Value + "' )from tbl_Customers A1, tbl_Complaints A2 where ('" + GrdCmplnts.CurrentRow.Cells[3].Value + "' )=('" + txtCmplRecID.Text + "') group by ('" + GrdCmplnts.CurrentRow.Cells[3].Value + "' ) ";

SqlConnection con = new SqlConnection(objconnect);
SqlDataReader dr = SqlHelper.ExecuteReader(con, CommandType.Text, QUpdate);
if (dr.Read())
{
// txtCmplRecID.Text = dr[2].ToString();
label8.Text = dr[1].ToString();
label9.Text = dr[4].ToString();
label10.Text = dr[5].ToString();
label11.Text = dr[6].ToString();
label12.Text = dr[7].ToString().Substring(0, 8);
label13.Text = dr[9].ToString();
label14.Text = dr[11].ToString();
label15.Text = dr[12].ToString();
label16.Text = dr[13].ToString();
label18.Text = dr[14].ToString();
label19.Text = dr[15].ToString();
label20.Text = dr[16].ToString();
this.CustomerDeatails.Enabled = true;
EPComplaints.Clear();

}

Responses

Author: akhilesh chauhan 25 Jul 2008

Member Level: Gold

Rating:

Points: 3

so what is the questioin...?

Author: Sabu C Alex 28 Jul 2008

Member Level: Gold

Rating:

Points: 0

hi janu

so what we have to do?

Post Reply

You must Sign In to post a response.

	Next : How to get only methods from a class type using Reflection
	Previous : adding dynamically textbox and labels in Windows applications
	Return to Discussion Forum
	Post New Message
	Category: Windows

Related Messages

dotNet Slackers BizTalk Adaptors Web Design

efax