Converting each datagrid line into a string in vb

[Eric Broers]

LS,

Assume I have a datagrid, which is filled by an SQL statement (Select * from
Customer). The Customers table contains 4 columns and 10 rows.

Now, I want to fill 10 strings with the datagrid rows. So, sting1 should
become the first database row, string2 the 2nd, etc, etc

So, I tried this:

For i = 0 To MyDataGrid.Item s.Count - 1
string1 = ??????????????? ?????????
Next

How do I read the datagrid and put it into a string? I hope someone can help
me out with this one.

Many thanks!!

Eric

[Armin Zingler]

"Eric Broers" <er*********@ho tmail.com> schrieb

Assume I have a datagrid, which is filled by an SQL statement (Select
* from Customer). The Customers table contains 4 columns and 10
rows.

Now, I want to fill 10 strings with the datagrid rows. So, sting1
should become the first database row, string2 the 2nd, etc, etc

So, I tried this:

For i = 0 To MyDataGrid.Item s.Count - 1
string1 = ??????????????? ?????????
Next

How do I read the datagrid and put it into a string? I hope someone
can help me out with this one.

Why not read from the bound datasource?
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Eric Broers]

All options are open... How do I read from the bound datasource?
"Armin Zingler" <az*******@free net.de> wrote in message
news:OH******** ******@tk2msftn gp13.phx.gbl...

"Eric Broers" <er*********@ho tmail.com> schrieb

Assume I have a datagrid, which is filled by an SQL statement (Select
* from Customer). The Customers table contains 4 columns and 10
rows.

Now, I want to fill 10 strings with the datagrid rows. So, sting1
should become the first database row, string2 the 2nd, etc, etc

So, I tried this:

For i = 0 To MyDataGrid.Item s.Count - 1
string1 = ??????????????? ?????????
Next

How do I read the datagrid and put it into a string? I hope someone
can help me out with this one.

Why not read from the bound datasource?
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Armin Zingler]

"Eric Broers" <er*********@ho tmail.com> schrieb

All options are open... How do I read from the bound datasource?

Did you bind the datagrid to a dataset or a datatable? If you did, you can
access the bound datatable. Have a look at the documentation of the
DataTable class.

See also the ADO.NET chapters (these and others):
http://msdn.microsoft.com/library/en...datatables.asp
http://msdn.microsoft.com/library/en...tingDataVB.asp

--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Cor]

Hi Eric,

The Datagrid is something that mostly shows data. That is always from
something that is inheritted from the iList and mostly a datatable. (Maybe
using a dataview).

Dont try to grab the data from the datagrid, take it from the datatable.
Trough that you can easily itterate by (and I show you an example with a
dataset wich have one table)

\\\roughly written watch typoes
dim i, y as integer
dim mystring as string (ds.tables(0).r ows.count - 1)
for i = 0 to ds.tables(0).ro ws.count - 1
mystring(i) = ds.tables(0).ro ws(i).item(0).t ostring
for y = 1 to 3
mystring(i) = mystring & " " & ds.tables(0).ro ws(i).item(y).t ostring
next y
next
////

I hope this helps?

Cor

Assume I have a datagrid, which is filled by an SQL statement (Select * from Customer). The Customers table contains 4 columns and 10 rows.

Now, I want to fill 10 strings with the datagrid rows. So, sting1 should
become the first database row, string2 the 2nd, etc, etc

[Eric Broers]

Hi Cor,

ok, I get it. But I am obly able to fill a datagrid by the following
statements (see the bottom of this message).

So now my question is, how do I fill the dataset by calling a stored
procedure??

Many thanks!

Eric

shop.aspx:
Private Sub Page_Load(..... )
MyDataGrid.Data Source = cart.GetItems(c artId)
MyDataGrid.Data Bind()
....
procs.vb:
Public Function GetItems(ByVal cartID As String) As SqlDataReader

' Create Instance of Connection and Command Object
Dim myConnection As SqlConnection = New
SqlConnection(C onfigurationSet tings.AppSettin gs("ConnectionS tring"))
Dim myCommand As SqlCommand = New SqlCommand("Sho ppingCartList",
myConnection)

' Mark the Command as a SPROC
myCommand.Comma ndType = CommandType.Sto redProcedure

' Add Parameters to SPROC
Dim parameterCartID As SqlParameter = New
SqlParameter("@ CartID", SqlDbType.NVarC har, 50)
parameterCartID .Value = cartID
myCommand.Param eters.Add(param eterCartID)

' Execute the command
myConnection.Op en()
Dim result As SqlDataReader =
myCommand.Execu teReader(Comman dBehavior.Close Connection)

' Return the datareader result
Return result

End Function


"Cor" <no*@non.com> wrote in message
news:eL******** ******@TK2MSFTN GP12.phx.gbl...

Hi Eric,

The Datagrid is something that mostly shows data. That is always from
something that is inheritted from the iList and mostly a datatable. (Maybe
using a dataview).

Dont try to grab the data from the datagrid, take it from the datatable.
Trough that you can easily itterate by (and I show you an example with a
dataset wich have one table)

\\\roughly written watch typoes
dim i, y as integer
dim mystring as string (ds.tables(0).r ows.count - 1)
for i = 0 to ds.tables(0).ro ws.count - 1
mystring(i) = ds.tables(0).ro ws(i).item(0).t ostring
for y = 1 to 3
mystring(i) = mystring & " " & ds.tables(0).ro ws(i).item(y).t ostring
next y
next
////

I hope this helps?

Cor

Assume I have a datagrid, which is filled by an SQL statement (Select *

from

Customer). The Customers table contains 4 columns and 10 rows.

Now, I want to fill 10 strings with the datagrid rows. So, sting1 should
become the first database row, string2 the 2nd, etc, etc

[Cor]

Hi Eric,

I use for this a dataset instead of the datareader, now you have to make the
underlaying tables, while the dataset makes that direct.

You need for that also a sqlDataadapter that uses the command.

I hope this helps?

Cor

ok, I get it. But I am obly able to fill a datagrid by the following
statements (see the bottom of this message).

So now my question is, how do I fill the dataset by calling a stored
procedure??