"Teemu Keiski" <joteke@aspalliance.com> wrote in message
news:OlCtdIqiDHA.2308@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> have you set DataGrid2.DataSource=myDS before binding the grid?
>
> --
> Teemu Keiski
> MCP, ASP.NET MVP
> AspInsiders Member, www.aspinsiders.com
> ASP.NET Forums Moderator, www.asp.net
> AspAlliance Columnist, www.aspalliance.com
>
> "Kent Johnson" <08.6044303@telia.com> wrote in message
> news:YUDfb.27363$mU6.68599@newsb.telia.net...
> > Hi all,
> >
> > How can I get data to show in a datagrid?
> > This is what I have tested:
> > ===============================
> > Dim ConnStr As String
> > ConnStr = "data source=MyServer;initial catalog=pubs;persist security
> > info=True;workstation id=LABSERVER;packet size=4096;user id=sa
> >
> > Dim SQLSelect As String
> > SQLSelect = "SELECT * FROM Titles"
> >
> > Dim mySqlConn As New System.Data.SqlClient.SqlConnection(ConnStr)
> > Dim mySqlDA As New System.Data.SqlClient.SqlDataAdapter(SQLSelect,
> ConnStr)
> >
> > Dim myDS As New DataSet()
> >
> > mySqlConn.Open()
> > mySqlDA.Fill(myDS)
> > DataGrid2.DataBind()
> > mySqlConn.Close()
> > ================================
> > I get no errormessage.
> >
> > What can be wrong?
> >
> > /Kent J.
> >
> >
> >
> >
>
>

"Kent Johnson" <08.6044303@telia.com> wrote in message
news:YUDfb.27363$mU6.68599@newsb.telia.net...
> Hi all,
>
> How can I get data to show in a datagrid?
> This is what I have tested:
> ===============================
> Dim ConnStr As String
> ConnStr = "data source=MyServer;initial catalog=pubs;persist security
> info=True;workstation id=LABSERVER;packet size=4096;user id=sa
>
> Dim SQLSelect As String
> SQLSelect = "SELECT * FROM Titles"
>
> Dim mySqlConn As New System.Data.SqlClient.SqlConnection(ConnStr)
> Dim mySqlDA As New System.Data.SqlClient.SqlDataAdapter(SQLSelect,
ConnStr)
>
> Dim myDS As New DataSet()
>
> mySqlConn.Open()
> mySqlDA.Fill(myDS)
> DataGrid2.DataBind()
> mySqlConn.Close()
> ================================
> I get no errormessage.
>
> What can be wrong?
>
> /Kent J.
>
>
>
>

"Kent Johnson" <08.6044303@telia.com> wrote in message
news:HFEfb.27370$mU6.68743@newsb.telia.net...
> Teemu,
>
> No, I hadn't done that. That fixed it!
> Thanks!
>
> Do you happen to know how I can store the fields in memVar when I retrive
> one record from the recordset?
>
> Example:
> Field1= strVar1
> Field2=strVar2
> Field3=strVar3
>
> I'm planning to use those fields for calculations.
>
> I guess I have to loop through the fields somehow.
>
> /Kent J.
>
>
>
>
>
>
> "Teemu Keiski" <joteke@aspalliance.com> wrote in message
> news:OlCtdIqiDHA.2308@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > have you set DataGrid2.DataSource=myDS before binding the grid?
> >
> > --
> > Teemu Keiski
> > MCP, ASP.NET MVP
> > AspInsiders Member, www.aspinsiders.com
> > ASP.NET Forums Moderator, www.asp.net
> > AspAlliance Columnist, www.aspalliance.com
> >
> > "Kent Johnson" <08.6044303@telia.com> wrote in message
> > news:YUDfb.27363$mU6.68599@newsb.telia.net...
> > > Hi all,
> > >
> > > How can I get data to show in a datagrid?
> > > This is what I have tested:
> > > ===============================
> > > Dim ConnStr As String
> > > ConnStr = "data source=MyServer;initial catalog=pubs;persist security
> > > info=True;workstation id=LABSERVER;packet size=4096;user id=sa
> > >
> > > Dim SQLSelect As String
> > > SQLSelect = "SELECT * FROM Titles"
> > >
> > > Dim mySqlConn As New System.Data.SqlClient.SqlConnection(ConnStr)
> > > Dim mySqlDA As New System.Data.SqlClient.SqlDataAdapter(SQLSelect,
> > ConnStr)
> > >
> > > Dim myDS As New DataSet()
> > >
> > > mySqlConn.Open()
> > > mySqlDA.Fill(myDS)
> > > DataGrid2.DataBind()
> > > mySqlConn.Close()
> > > ================================
> > > I get no errormessage.
> > >
> > > What can be wrong?
> > >
> > > /Kent J.
> > >
> > >
> > >
> > >
> >
> >
>
>