Click here to Skip to main content
15,868,016 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Upgrading VB6 to VB.net printing problem Pin
Sebastian Br.27-Feb-09 7:43
Sebastian Br.27-Feb-09 7:43 
GeneralRe: Upgrading VB6 to VB.net printing problem Pin
tbkfile27-Feb-09 18:36
tbkfile27-Feb-09 18:36 
QuestionDataset containing nullable datetime values does not like a null datetime? Pin
kriskomar27-Feb-09 4:56
kriskomar27-Feb-09 4:56 
AnswerRe: Dataset containing nullable datetime values does not like a null datetime? Pin
johnsontroye27-Feb-09 9:38
johnsontroye27-Feb-09 9:38 
GeneralRe: Dataset containing nullable datetime values does not like a null datetime? Pin
kriskomar27-Feb-09 9:59
kriskomar27-Feb-09 9:59 
AnswerRe: Dataset containing nullable datetime values does not like a null datetime? Pin
PoweredByOtgc28-Feb-09 5:07
PoweredByOtgc28-Feb-09 5:07 
GeneralRe: Dataset containing nullable datetime values does not like a null datetime? Pin
kriskomar1-Mar-09 6:00
kriskomar1-Mar-09 6:00 
GeneralRe: Dataset containing nullable datetime values does not like a null datetime? Pin
PoweredByOtgc1-Mar-09 6:32
PoweredByOtgc1-Mar-09 6:32 
you can still use the designer to bind your controls to the dataset, but I personaly would use an nTier approach and create a class to fill the dataset.

From the top of my head it will go something like this, but you may want to google sqlconnection and sqlcommand on the proper implementation

public class mydataleyer

public function FillDataset() as mydataset
dim results as new mydataset
dim con as new sqlconnection("server","database","username","password")
dim qry as new sqlcommand("select * from mytable")
con.open
dim rdr as datareader = qry.executereader(cn)
while rdr.read()
dim rw as datarow = results.tables(0).newrow
rw("datecolumn") = IIF(IsDBNull(rdr(0)),"01/01/1900",rdr(0))
results.tables(0).rows.add(rw)
end while
return results
end function
end class


from you form onload event

private sub myform_load(byval sender as object,byval e as eventargs) handles mybase.load
dim ldr as new mydatalayer
me.dataset1 = ldr.FillDataset
end sub

GeneralRe: Dataset containing nullable datetime values does not like a null datetime? Pin
kriskomar1-Mar-09 14:58
kriskomar1-Mar-09 14:58 
GeneralRe: Dataset containing nullable datetime values does not like a null datetime? Pin
PoweredByOtgc2-Mar-09 13:56
PoweredByOtgc2-Mar-09 13:56 
AnswerPartial fix for control not allowing null value to pass to dataset and database Pin
kriskomar3-Mar-09 6:45
kriskomar3-Mar-09 6:45 
AnswerRe: Dataset containing nullable datetime values does not like a null datetime? Pin
kriskomar4-Mar-09 7:05
kriskomar4-Mar-09 7:05 
GeneralRe: Dataset containing nullable datetime values does not like a null datetime? Pin
kriskomar5-Mar-09 4:58
kriskomar5-Mar-09 4:58 
Questionhow to do the custom installation of vb.net windows applications project ? [modified] Pin
pramod251727-Feb-09 2:08
pramod251727-Feb-09 2:08 
AnswerRe: how to do the custom installation of vb.net windows applications project ? Pin
Eddy Vluggen27-Feb-09 2:34
professionalEddy Vluggen27-Feb-09 2:34 
AnswerRe: how to do the custom installation of vb.net windows applications project ? Pin
Jon_Boy27-Feb-09 2:43
Jon_Boy27-Feb-09 2:43 
QuestionVB.Net and C# and VC++ in single project Pin
Samir Ibrahim26-Feb-09 23:35
Samir Ibrahim26-Feb-09 23:35 
AnswerRe: VB.Net and C# and VC++ in single project Pin
Smithers-Jones27-Feb-09 0:13
Smithers-Jones27-Feb-09 0:13 
AnswerRe: VB.Net and C# and VC++ in single project Pin
Jon_Boy27-Feb-09 2:38
Jon_Boy27-Feb-09 2:38 
AnswerRe: VB.Net and C# and VC++ in single project Pin
Dave Kreskowiak27-Feb-09 7:52
mveDave Kreskowiak27-Feb-09 7:52 
QuestionHow to send E-Mail from VB.Net from [modified] Pin
palathoti26-Feb-09 21:56
palathoti26-Feb-09 21:56 
AnswerRe: How to send E-Mail from VB.Net from Pin
Eddy Vluggen26-Feb-09 22:38
professionalEddy Vluggen26-Feb-09 22:38 
GeneralRe: How to send E-Mail from VB.Net from Pin
palathoti26-Feb-09 23:40
palathoti26-Feb-09 23:40 
Questionread from ini file Pin
dec8226-Feb-09 21:32
dec8226-Feb-09 21:32 
AnswerRe: read from ini file Pin
Eddy Vluggen26-Feb-09 22:40
professionalEddy Vluggen26-Feb-09 22:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.