dataset

[citizenstitch]

how do i make a dataset so i can fill my adapter?

[Shaggy Hiker]

Here's an example of one I created. It does seem a bit backwards, doesn't it?



Dim cmd As System.Data.SqlServerCe.SqlCeCommand
Dim da As System.Data.SqlServerCe.SqlCeDataAdapter
Dim ds As New System.Data.DataSet

cmd = dbM.GetCommand
cmd.CommandText = "SELECT * FROM EffortTable WHERE SessionDate >= '" & dt.ToShortDateString & "'"
da = New System.Data.SqlServerCe.SqlCeDataAdapter(cmd)

da.Fill(ds)

[citizenstitch]

i think i did that before, but i could not see any results
is my databinding correct?
lblWeek.DataBindings.Add("text", ds, "week")
where week a fieldname? i dont know about text.

[citizenstitch]

still having binding problems. help.

[Shaggy Hiker]

I'm afraid I know just about 0 about data binding. The code I have used to fill datasets is what I posted, and that's the only way I have used them (I tend not to use them at all if I can avoid them, but as you have found, sometimes they are the right tool).