Click here to Skip to main content
15,886,038 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionPlease Help Pin
Noufe3-Feb-09 0:50
Noufe3-Feb-09 0:50 
AnswerRe: Please Help Pin
Dave Kreskowiak3-Feb-09 2:03
mveDave Kreskowiak3-Feb-09 2:03 
GeneralRe: Please Help Pin
Noufe3-Feb-09 22:26
Noufe3-Feb-09 22:26 
GeneralRe: Please Help Pin
Dave Kreskowiak4-Feb-09 2:07
mveDave Kreskowiak4-Feb-09 2:07 
QuestionTextBox focus on loading form Pin
Richard W Allen3-Feb-09 0:00
Richard W Allen3-Feb-09 0:00 
AnswerRe: TextBox focus on loading form Pin
Richard W Allen3-Feb-09 2:01
Richard W Allen3-Feb-09 2:01 
QuestionDateTimePicker Pin
vijay24822-Feb-09 21:45
vijay24822-Feb-09 21:45 
AnswerRe: DateTimePicker Pin
Rupesh Kumar Swami2-Feb-09 22:32
Rupesh Kumar Swami2-Feb-09 22:32 
There are two method for store value in database

first one is execute following query

str="insert into tableName(dateFieldName) values(#" & datatimepicker1.Value & "#)"

second one is use parameterized query as following

Dim QueryText As String<br />
  Dim QueryValue As String<br />
  QueryText = "INSERT INTO tableName(dateFieldName)"<br />
  QueryValue = "Values(@dateValue)<br />
  Dim com As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand<br />
  com.Parameters.Add("@dateValue", OleDb.OleDbType.Date, 16).Value = datatimepicker1.Value 'here you can use length as you wish<br />
   com .CommandText = QueryText & QueryValue<br />
  com .ExecuteNonQuery()


in above two method i assume you can manage connection object. If have any problem, then let me know

Rupesh Kumar Swami
Software Developer,
Integrated Solution,
Bikaner (India)

My Company
Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11

GeneralRe: DateTimePicker [modified] Pin
vijay24822-Feb-09 23:03
vijay24822-Feb-09 23:03 
QuestionModifying user defined structures in a collection Pin
Jay Royall2-Feb-09 21:43
Jay Royall2-Feb-09 21:43 
AnswerRe: Modifying user defined structures in a collection Pin
Tony Richards2-Feb-09 23:47
Tony Richards2-Feb-09 23:47 
GeneralRe: Modifying user defined structures in a collection Pin
Jay Royall2-Feb-09 23:59
Jay Royall2-Feb-09 23:59 
GeneralRe: Modifying user defined structures in a collection Pin
supercat93-Feb-09 6:04
supercat93-Feb-09 6:04 
GeneralRe: Modifying user defined structures in a collection Pin
Guffa3-Feb-09 13:51
Guffa3-Feb-09 13:51 
GeneralRe: Modifying user defined structures in a collection Pin
Jay Royall3-Feb-09 22:06
Jay Royall3-Feb-09 22:06 
GeneralRe: Modifying user defined structures in a collection Pin
Jay Royall3-Feb-09 2:21
Jay Royall3-Feb-09 2:21 
QuestionI would love to learn how to use my compiler.. It is of a strange new language to will anyone volenteer to help teach me ? Pin
sweldon0012-Feb-09 19:48
sweldon0012-Feb-09 19:48 
AnswerRe: I would love to learn how to use my compiler.. It is of a strange new language to will anyone volenteer to help teach me ? Pin
Jay Royall2-Feb-09 21:51
Jay Royall2-Feb-09 21:51 
AnswerRe: I would love to learn how to use my compiler.. It is of a strange new language to will anyone volenteer to help teach me ? Pin
EliottA3-Feb-09 2:39
EliottA3-Feb-09 2:39 
Questionclear variables Pin
aswd2-Feb-09 18:12
aswd2-Feb-09 18:12 
AnswerRe: clear variables Pin
MohammadAmiry2-Feb-09 18:22
MohammadAmiry2-Feb-09 18:22 
GeneralRe: clear variables Pin
aswd2-Feb-09 18:26
aswd2-Feb-09 18:26 
GeneralRe: clear variables Pin
Dave Kreskowiak2-Feb-09 18:36
mveDave Kreskowiak2-Feb-09 18:36 
GeneralRe: clear variables Pin
aswd2-Feb-09 18:41
aswd2-Feb-09 18:41 
GeneralRe: clear variables Pin
Christian Graus2-Feb-09 19:18
protectorChristian Graus2-Feb-09 19:18 

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.