Click here to Skip to main content
15,908,776 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Syntax to create multi-dimensional arrays in VB.NET? Pin
Scott Serl10-Jun-05 18:43
Scott Serl10-Jun-05 18:43 
GeneralRe: Syntax to create multi-dimensional arrays in VB.NET? Pin
Carl Mercier11-Jun-05 3:10
Carl Mercier11-Jun-05 3:10 
GeneralRe: Syntax to create multi-dimensional arrays in VB.NET? Pin
Christian Graus13-Jun-05 12:17
protectorChristian Graus13-Jun-05 12:17 
GeneralRe: Syntax to create multi-dimensional arrays in VB.NET? Pin
Carl Mercier15-Jun-05 2:46
Carl Mercier15-Jun-05 2:46 
GeneralRe: Syntax to create multi-dimensional arrays in VB.NET? Pin
Christian Graus15-Jun-05 13:04
protectorChristian Graus15-Jun-05 13:04 
GeneralRe: Syntax to create multi-dimensional arrays in VB.NET? Pin
Carl Mercier15-Jun-05 15:32
Carl Mercier15-Jun-05 15:32 
AnswerRe: Syntax to create multi-dimensional arrays in VB.NET? Pin
uno freeware11-Jun-05 15:55
uno freeware11-Jun-05 15:55 
GeneralLittle problem in Vb.net Pin
eshban28410-Jun-05 9:33
eshban28410-Jun-05 9:33 
I have a field in SQlServer Database which name is "PublishingDate". In it, Date is stored in that format i.e

3/28/2005

In my vb.net program i use select query to fetch all the records of column "PublishingDate"

I use the query below to just select year out of whole Date and display result in a combobox.

"select distinct DATEPART(yy,publishingdate) from books"

Everything will be fine.

In Combobox it show all "years" like 2000,2001,2002,2003

I want that when user clicks on any year in a combobox like '2000', it will display results according to that query

Select * from books where publishingdate='" & ComVal.text & "'

But this query cannot display the result because in database date is stored in this format "3/8/2005"


Hope you got the meaning.

I use this query, but it cannot display the result.
SELECT * From books where publishingdate IN (select Datepart(yy,publishingdate)from books)

How can i do this?
Plz help me in this regard.

Eshban

EsHbAn BaHaDuR
GeneralRe: Little problem in Vb.net Pin
Christian Graus10-Jun-05 13:41
protectorChristian Graus10-Jun-05 13:41 
GeneralRe: Little problem in Vb.net Pin
Chemisus11-Jun-05 8:36
Chemisus11-Jun-05 8:36 
GeneralSaving Images in VB.NET Pin
rstat110-Jun-05 8:40
rstat110-Jun-05 8:40 
GeneralRe: Saving Images in VB.NET Pin
Christian Graus10-Jun-05 13:56
protectorChristian Graus10-Jun-05 13:56 
GeneralRe: Saving Images in VB.NET Pin
rstat110-Jun-05 13:59
rstat110-Jun-05 13:59 
GeneralRe: Saving Images in VB.NET Pin
MoustafaS10-Jun-05 14:47
MoustafaS10-Jun-05 14:47 
GeneralRe: Saving Images in VB.NET Pin
rstat110-Jun-05 14:48
rstat110-Jun-05 14:48 
GeneralActive X Control Pin
Anonymous10-Jun-05 8:09
Anonymous10-Jun-05 8:09 
GeneralRe: Active X Control Pin
Rizwan Bashir10-Jun-05 21:33
Rizwan Bashir10-Jun-05 21:33 
GeneralDatagrid property in VB.Net Pin
directred10-Jun-05 5:22
directred10-Jun-05 5:22 
GeneralRe: Datagrid property in VB.Net Pin
Rizwan Bashir10-Jun-05 21:40
Rizwan Bashir10-Jun-05 21:40 
GeneralVB.NET Code to identify the SQL servers in the network Pin
Devaloper10-Jun-05 3:56
Devaloper10-Jun-05 3:56 
GeneralRe: VB.NET Code to identify the SQL servers in the network Pin
Dave Kreskowiak10-Jun-05 4:15
mveDave Kreskowiak10-Jun-05 4:15 
Generalwhich image format is better Pin
Rizwan Bashir10-Jun-05 2:55
Rizwan Bashir10-Jun-05 2:55 
GeneralRe: which image format is better Pin
Dave Kreskowiak10-Jun-05 3:55
mveDave Kreskowiak10-Jun-05 3:55 
GeneralRe: which image format is better Pin
Rizwan Bashir10-Jun-05 21:50
Rizwan Bashir10-Jun-05 21:50 
GeneralRe: which image format is better Pin
Christian Graus10-Jun-05 13:44
protectorChristian Graus10-Jun-05 13:44 

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.