"Elton Wang" <elton_wang@hotmail.com> wrote in message
news:OW3e7iGlFHA.3628@TK2MSFTNGP10.phx.gbl...
> Could you show your datagrid html code?
>
>
> "bucrepus" <bucrepus@hotmail.com> wrote in message
> news:%23Pccz2ElFHA.3568@tk2msftngp13.phx.gbl...
> > I created a simple datagrid that was populated from a SQL stored
> procedure.
> >
> > SP
> > Select LNAME + FNAME as NAMETEXT, DATEHIRE as DATETEXT from employees
> >
> > did this in ASP.NET>>
> > tmpSQL.SQLDB.Open()
> > tmpSQL.SQLCmd.CommandType = CommandType.StoredProcedure
> > tmpSQL.SQLCmd.CommandText = "SP_GETNAMES"
> > Dim DS As DataSet = New DataSet
> > Dim DA As SqlDataAdapter = New SqlDataAdapter(tmpSQL.SQLCmd.CommandText,
> > tmpSQL.SQLDB)
> > DA.Fill(DS)
> > DataGrid1.DataSource = DS
> > DataGrid1.DataBind()
> >
> > works fine with AUOTGENERATE col's on., Displays the data....
> >
> > But if a make the bound columns in the wizard. ( so I can format the
the
> > date), nothing displays!!??
> >
> > what other code must I do to make the records display when I manually
key
> in
> > the column names?
> >
> > Thanks BUC
> >
> >
> >
>
>

"bucrepus" <bucrepus@hotmail.com> wrote in message
news:%23Pccz2ElFHA.3568@tk2msftngp13.phx.gbl...
> I created a simple datagrid that was populated from a SQL stored
procedure.
>
> SP
> Select LNAME + FNAME as NAMETEXT, DATEHIRE as DATETEXT from employees
>
> did this in ASP.NET>>
> tmpSQL.SQLDB.Open()
> tmpSQL.SQLCmd.CommandType = CommandType.StoredProcedure
> tmpSQL.SQLCmd.CommandText = "SP_GETNAMES"
> Dim DS As DataSet = New DataSet
> Dim DA As SqlDataAdapter = New SqlDataAdapter(tmpSQL.SQLCmd.CommandText,
> tmpSQL.SQLDB)
> DA.Fill(DS)
> DataGrid1.DataSource = DS
> DataGrid1.DataBind()
>
> works fine with AUOTGENERATE col's on., Displays the data....
>
> But if a make the bound columns in the wizard. ( so I can format the the
> date), nothing displays!!??
>
> what other code must I do to make the records display when I manually key
in
> the column names?
>
> Thanks BUC
>
>
>