[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.sdk

expand datagrid in Pocket PC 2003

Constantine Leshkov

9/18/2003 7:10:00 AM

Hi all.

I have device HP iPAQ 5550 with win Pocket PC 2003

I develop application on VS.net 2003 in VB.net

I have problem with DataGrid after set data source to datagrid I see changes on data grid (see picture) and I can't expand data grid

Pleas help



Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

'Dim connectstring As String

'connectstring = "data source=Isaserv-test;initial catalog=northwind;User ID=sa; Password=1111; workstation id=hp;packet size=4096"

Dim cOm As New SqlClient.SqlCommand

Dim da As New SqlClient.SqlDataAdapter

Dim cOn As New System.Data.SqlClient.SqlConnection("user id=sa;password=1;" + _

"initial catalog=northwind;server=serv-test")

Dim DsG As New DataSet

cOm.Connection() = cOn

cOm.CommandType = CommandType.StoredProcedure

cOm.CommandText = "getSuppliers"

cOm.Parameters.Add("@CompanyName", TextBox1.Text)

da.SelectCommand = cOm

da.Fill(DsG)


da.SelectCommand = cOm

da.Fill(DsG)

DataGrid1.DataSource = DsG



End Sub
3 Answers

Jason Hsu

9/18/2003 5:05:00 PM

0

I''m not so sure, but didn''t you remember DataGrid1.Bind()

Jason Hsu

"Constantine Leshkov" <lesh@it.alegratrans.com> |b?l?o
news:OTv44PbfDHA.1832@TK2MSFTNGP09.phx.gbl ?????g...
Hi all.

I have device HP iPAQ 5550 with win Pocket PC 2003

I develop application on VS.net 2003 in VB.net

I have problem with DataGrid after set data source to datagrid I see changes
on data grid (see picture) and I can''t expand data grid

Pleas help



Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click

''Dim connectstring As String

''connectstring = "data source=Isaserv-test;initial catalog=northwind;User
ID=sa; Password=1111; workstation id=hp;packet size=4096"

Dim cOm As New SqlClient.SqlCommand

Dim da As New SqlClient.SqlDataAdapter

Dim cOn As New System.Data.SqlClient.SqlConnection("user id=sa;password=1;"
+ _

"initial catalog=northwind;server=serv-test")

Dim DsG As New DataSet

cOm.Connection() = cOn

cOm.CommandType = CommandType.StoredProcedure

cOm.CommandText = "getSuppliers"

cOm.Parameters.Add("@CompanyName", TextBox1.Text)

da.SelectCommand = cOm

da.Fill(DsG)


da.SelectCommand = cOm

da.Fill(DsG)

DataGrid1.DataSource = DsG



End Sub

Constantine Leshkov

9/19/2003 5:58:00 AM

0

datagrid for Pocket PC have not metod Bind

"Jason Hsu" <jsnhsu@msn.com> wrote in message
news:epnfDcgfDHA.892@TK2MSFTNGP12.phx.gbl...
> I''m not so sure, but didn''t you remember DataGrid1.Bind()
>
> Jason Hsu
>
> "Constantine Leshkov" <lesh@it.alegratrans.com> &#166;b&#182;l&#165;&#243;
> news:OTv44PbfDHA.1832@TK2MSFTNGP09.phx.gbl &#164;&#164;&#188;&#182;&#188;g...
> Hi all.
>
> I have device HP iPAQ 5550 with win Pocket PC 2003
>
> I develop application on VS.net 2003 in VB.net
>
> I have problem with DataGrid after set data source to datagrid I see
changes
> on data grid (see picture) and I can''t expand data grid
>
> Pleas help
>
>
>
> Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
> System.EventArgs) Handles Button2.Click
>
> ''Dim connectstring As String
>
> ''connectstring = "data source=Isaserv-test;initial catalog=northwind;User
> ID=sa; Password=1111; workstation id=hp;packet size=4096"
>
> Dim cOm As New SqlClient.SqlCommand
>
> Dim da As New SqlClient.SqlDataAdapter
>
> Dim cOn As New System.Data.SqlClient.SqlConnection("user
id=sa;password=1;"
> + _
>
> "initial catalog=northwind;server=serv-test")
>
> Dim DsG As New DataSet
>
> cOm.Connection() = cOn
>
> cOm.CommandType = CommandType.StoredProcedure
>
> cOm.CommandText = "getSuppliers"
>
> cOm.Parameters.Add("@CompanyName", TextBox1.Text)
>
> da.SelectCommand = cOm
>
> da.Fill(DsG)
>
>
> da.SelectCommand = cOm
>
> da.Fill(DsG)
>
> DataGrid1.DataSource = DsG
>
>
>
> End Sub
>


Microsoft MVP ®}¸t­õ for .NET CF

10/4/2003 1:02:00 PM

0


¨þ¨þ¡ã¸ò§Ú·íªì¹J¨ìªº°ÝÃD¬O¤@¼Ëªº¡A½Ð³]©w DataTable µ¹ DataSource ¡Aª½±µµ¹
DataSet¬O¤£¦æ¦a
--
============================
·L³n³Ì¦³»ù­È±M®a
Microsoft MVP
®}¸t­õ(John, SHU) for .NET CF

"Constantine Leshkov" <lesh@it.alegratrans.com> ¦b¶l¥ó
news:OTv44PbfDHA.1832@TK2MSFTNGP09.phx.gbl ¤¤¼¶¼g...
Hi all.
I have device HP iPAQ 5550 with win Pocket PC 2003
I develop application on VS.net 2003 in VB.net
I have problem with DataGrid after set data source to datagrid I see changes
on data grid (see picture) and I can't expand data grid
Pleas help


Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
'Dim connectstring As String
'connectstring = "data source=Isaserv-test;initial catalog=northwind;User
ID=sa; Password=1111; workstation id=hp;packet size=4096"
Dim cOm As New SqlClient.SqlCommand
Dim da As New SqlClient.SqlDataAdapter
Dim cOn As New System.Data.SqlClient.SqlConnection("user id=sa;password=1;"
+ _
"initial catalog=northwind;server=serv-test")
Dim DsG As New DataSet
cOm.Connection() = cOn
cOm.CommandType = CommandType.StoredProcedure
cOm.CommandText = "getSuppliers"
cOm.Parameters.Add("@CompanyName", TextBox1.Text)
da.SelectCommand = cOm
da.Fill(DsG)
da.SelectCommand = cOm
da.Fill(DsG)
DataGrid1.DataSource = DsG
End Sub