DataGridView data source

[eileenc87]

hi All,

Why when I drag the datagridview in my designer, they don't give me a selection on which data source?
How can i declare my datsource, dataset?

URGENT..HELPPP

[Jx_Man]

Dim Myds as New DataSet
Dim Mycmd As New SqlCommand(YourSQLQuery, YourConnection)
Dim Myda As New DataAdapter(Mycmd)
Myda.fill(Myds)

[eileenc87]

how bout table adapter? meaning the data from database will mapped to the table in datagridview

[arezz09]

do u has add dataset to yr project

[eileenc87]

cannot...I cant even add a datasource, dataset and databinding...
I wonder why..Previously I was able to do this when once i drag and drop datagridview on the form...

But, today when I wanted to create another new project, somehow this happen...

[Saikalyankumar]

After creating a dataset, use this code

DGView.Datasource=DSet.Tables(0)
DGView.DataBind()

[eileenc87]

I cant even create dataset.....

[arezz09]

mybe u hve problem with yr vb.net..b4 this i get problem to add data source but after i reinstall vb.net, it back normaly..

i think u should reinstall yr vb...

[Saikalyankumar]

Dim ds As New DataSet
Dim cmd As New SqlCommand("your query", connection)
Dim da As New SqlDataAdapter(cmd)
da.fill(ds)
Dgview.Datasource = ds
Dgview.DataBind()

try this one

[eileenc87]

if I want to have this one, what should i do?

Me.MeetingTableAdapter.Fill(Me.CarerptDataSet.Meeting)

[Saikalyankumar]

Do, you have created new DataAdapter and DataSet?

[arezz09]

u need to binding data source first...

[eileenc87]

cannot create...no menu for create...what it show is none instead of add project data source

[arezz09]

Me.MeetingTableAdapter.Fill(Me.CarerptDataSet.Meeting)
this code will automatic load 2 yr form when u create dataset..