Retrieve Gridview Data as String

Question

0.00/5 (No votes)

See more:

Hi All,

I have a gridview with columns as Itemid, item name, and Pnumber.
Fetch the item id and item name from the rows which are having same Pnumber and return the result as string.

can any one tell me how to do that...

Posted 22-Jul-10 0:09am

.netram

Add a Solution

2 solutions

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)

Sandeep Mewara · Answer 1 · 2010-07-22T00:35:00

Ok. So this sounds like your homework and good thing is you have no idea about it.

There can be various ways to do it. One simple way can be:
1. Loop through the datagrid rows
2. Pick the first row Pnumber and check with other rows. If you find same add the details in a string.
3. Maintain the Pnumber already checked. So that you dont repeat the same next time.
4. Do these for all rows.

Try now!

.netram · Answer 2 · 2010-07-22T01:00:00

Hi Sandeep,

I have tried that way..but got the output as..
Answer1Answer1%Answer2Answer1%Answer2%Answer3.I am sending mail in the same code..i have to send 9 mails but sending 27 mails ..so what to do..

Check my code..

protected void Notify(object sender, EventArgs e)
{
SPSite mysite = new SPSite("sitename");
SPWeb MYWEB = mysite.OpenWeb();
SPList Rmslist = MYWEB.Lists["list"];
SPListItemCollection Rmscollection = Rmslist.Items;
string Iitem = null;
string Iitemno = null;
string Iitemname = null;
try
{
if (ViewState["CurrentTable"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentTable"];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TextBox box1 = (TextBox)GridView2.Rows[i].Cells[0].FindControl("txtitems");
TextBox box2 = (TextBox)GridView2.Rows[i].Cells[1].FindControl("txtitemno");
TextBox box3 = (TextBox)GridView2.Rows[i].Cells[2].FindControl("txtitemname");
DropDownList ddl1 = (DropDownList)GridView2.Rows[i].Cells[3].FindControl("ddlplants");
DropDownList ddl2 = (DropDownList)GridView2.Rows[i].Cells[4].FindControl("ddlsloc");
TextBox box4 = (TextBox)GridView2.Rows[i].Cells[5].FindControl("txtpr");
//DropDownList ddl3 = (DropDownList)GridView2.Rows[i].Cells[6].FindControl("ddlreqstatus");
DropDownList ddl4 = (DropDownList)GridView2.Rows[i].Cells[6].FindControl("ddlitemstatus");
Iitem += box1.Text;
Iitemno += box2.Text;
Iitemname += box3.Text;
string prnum = box4.Text;
string plant = ddl1.SelectedValue.ToString();
string Slocation = ddl2.SelectedValue.ToString();
string istatus = ddl4.SelectedValue.ToString();
string mId;

if ((prnum != string.Empty) && (istatus == "PR Raised"))
{
foreach (SPListItem item in Rmscollection)
{
if ((plant == item["Plant"].ToString()) && (Slocation == item["Storesloc"].ToString()))
{
for (int j = 1; j < 10; j++)
{
if ((item.Fields["mail" + j] != null) && (item.Fields["mail" + j].ToString() != string.Empty))
{
mId = item["mail" + j].ToString();

}
else
break;
SendMails(mId,prnum,Iitem,Iitemno,Iitemname);
}
//Response.Write(receivermailid);
// receivermailid = item["mail1"].ToString();
}
}
}
}
}
}
}
catch (Exception ex)
{
Response.Write("Error" + ex.Message);
}
}

Retrieve Gridview Data as String

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0