Passing Field Values to a text box

Question

I have a datagrid which is filled by a data adapter. Now I have to send Email to all the clients regarding the products they have chosen and thus the E-mail content would vary for each client. I mean at only the places where i list down the product names. How do i do this @ run time. for eg: thanx for choosing our product. IT would be xxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxx The product u have chosen is so the first 5 lines would be same for all  and only the product name would vary for each client. How do i go abt solving this problem

yasser_8227 · Answer

Sorry for that again. I did the same mistake. What a stupid guy I'm :-(. Do this way: Dim str As String = GetMessageContent(C:\Products.txt) i = 0 for each row as rows in datarow txtEmailMatter.Text = str txtEmailMatter.Text = Me.txtEmailMatter.Text.ToString.Replace (ProductName dataGridEmailTable.Item(i 10)) system.web.sendmail(XxyyProductstxtEmailMatter.Text) i += 1 end for Yasser

yasser_8227 · Answer

Sorry for that. I didn't realize that at first instance. Change your code to: Dim str As String = GetMessageContent(C:\Products.txt) i = 0 for each row as rows in datarow system.web.sendmail(Xx yy Products str.Replace(ProductName dataGridEmailTable.Item(i++ 10)) ) end for

vishalsethia · Answer

if i dont call the GetMEssageContent Function each time in the loop  my replace would not work after the 1st loop as product name  woudl be replaced with the first customers product name and there after the replace command would not replace anything

yasser_8227 · Answer

In your case ItemCommand will not work so leave that part. However you can improve your code to work faster by making 2 changes: First there's no need to read the contents of Products.txt for each row in a datagrid. Read the contents of Products.txt before the loop and store it in your txtEmailMatter. This will have a tremendous improvement in performance depending on the rows in Datagrid. Say txtEmailMatter.Text = GetMessageContent(C:\Products.txt) 'and then start your loop i = 0 for each row as rows in datarow 'and second reduce your code from 3 lines to 1 line. This will also enhance performance system.web.sendmail(Xx yy Products txtEmailMatter.Text.Replace(ProductName dataGridEmailTable.Item(i++ 10)) ) end for

vishalsethia · Answer

Iam a newbie in VB.net  can u please explain me the difference between a datatable and a datagrid. I first wanna show the users the list  beofre sending E-mail. Is that possible using a datatable.

miker · Answer

I don't think you have a lot if option on how to do this. The only thing I woud change is using DataTable instead of DataGrid to as a source for your data.

vishalsethia · Answer

Wat i have been doin so far is  i run a loop for all the rows in the Data Grid and use the Replace command to replace Product Name with the corresponding entry in the data grid i think there shld be a better way of handling this problem ?? i = 0 for each row as rows in datarow txtEmailMatter.Text = GetMessageContent(C:\Products.txt) txtEmailMatter.Text = Me.txtEmailMatter.Text.ToString.Replace (ProductName dataGridEmailTable.Item(i 10)) system.web.sendmail(XxyyProductstxtEmailMatter.Text) i = i + 1 end for I hope u understood wat i am trying to tell you

yasser_8227 · Answer

Can't you get the value of the product in ItemCommand event of DataGrid. For more info on how to do this check this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebuiwebcontrolsdatagridclassitemcommandtopic.asp