Visual Basic Discussion Boards

First Prev Next

Re: DatagridView not display any data

Ron Beyer9-Jan-14 5:13

Ron Beyer

9-Jan-14 5:13

BETWEEN is a mathematical comparison, when used on strings it simply selects, alphabetically, if the row is between the two values. Because you changed your date column to a char column, its no longer a date and between doesn't mean between the two dates, it means between the two strings alphabetically.

You really need to have that be a date column to use the BETWEEN correctly.

Re: DatagridView not display any data

Biplob Singha Shee9-Jan-14 6:28

Biplob Singha Shee

9-Jan-14 6:28

Hi Ron,
Thank you for your reply. I understood the BETWEEN comparison. I would like to say that, if I make the datatype of the field "date", it never displays any data. I don't know why. Is there any fault in my code ? Another thing is, if I convert the string in to date then is it possible to calculate ?

Re: DatagridView not display any data

Biplob Singha Shee9-Jan-14 6:32

Biplob Singha Shee

9-Jan-14 6:32

Sorry, it is not possible I think because how can I retrieve the database datatype string in to datetime. So what should I do, make the field datatype "Date" or "DateTime" ?

Re: DatagridView not display any data

Biplob Singha Shee9-Jan-14 6:52

Biplob Singha Shee

9-Jan-14 6:52

Ok, now I changed the DataType in to Date and changed the dates in to "yyyy-MM-dd" format in the database and changed my code for MySQL Date format...

Dim DateFrom As String = Convert.ToDateTime(DtpFrom.Value).ToString("yyyy-MM-dd")
Dim DateTo As String = Convert.ToDateTime(DtpTo.Value).ToString("yyyy-MM-dd")

Now it retrieving the data correctly in between two dates but a new problem arises. The report date field not showing any date.

While viewing the datasource of crystal report (XML), the schema shows...

XML

<xs:element name="IncDate" msdata:DataType="MySql.Data.Types.MySqlDateTime, MySql.Data, Version=6.6.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" type="xs:anyType" minOccurs="0" />

and the data shows (in XML)

XML

<IncDate xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
     <TimezoneOffset>0</TimezoneOffset>
     <Year>2013</Year>
     <Month>12</Month>
     <Day>25</Day>
     <Hour>0</Hour>
     <Minute>0</Minute>
     <Second>0</Second>
     <Millisecond>0</Millisecond>
   </IncDate>

What should I do ?

Please note that in my ConnectionString the Allow Zero Datetime is set to "True". Is this the problem ?

modified 9-Jan-14 13:19pm.

Re: DatagridView not display any data

Dave Kreskowiak6-Jan-14 9:21

Dave Kreskowiak

6-Jan-14 9:21

Biplob Singha Shee wrote:
If yes, then in which format ?

That's the entire point behind using a PARAMETERIZED QUERY. You don't have to worry about the format AT ALL!! It's automatically handled by the Parameter object.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: DatagridView not display any data

Biplob Singha Shee6-Jan-14 9:27

Biplob Singha Shee

6-Jan-14 9:27

Hi Dave,
Thank you for your answer. I am trying to solve this problem with parameterized queries however there is something wrong in my code I think. Let me check this first.

Thanks again,

Regards,

Biplob

COM component

dharmendra113-Jan-14 20:01

dharmendra11

3-Jan-14 20:01

What is COM,DCOM,COM+ component with Examples.

Re: COM component

Richard MacCutchan3-Jan-14 22:38

Richard MacCutchan

3-Jan-14 22:38

Use Google, it will find you many examples.

Veni, vidi, abiit domum

Incorporating setup with other EXEs

SPSandy2-Jan-14 20:27

SPSandy

2-Jan-14 20:27

Hi,

I have checked quite a few sites and articles but am not able to figure out how to solve my problem. The problem is:

I am creating a setup for a project. In that I want to include 2 more EXEs which will perform while the setup is run. 1. Wirting Serial number into the registry and 2. Installation of MySql.

I have tried with Custom Action but it copies the Serial Number Registration EXE in the folder where the installation is taking place. This I don't want. It should run the file and then remove it.

If anybody can help me in this I will be obliged.

Re: Incorporating setup with other EXEs

Bernhard Hiller2-Jan-14 21:50

Bernhard Hiller

2-Jan-14 21:50

SPSandy wrote:
it copies the Serial Number Registration EXE in the folder where the installation is taking place

That's OK - add another custom action which runs that executable, and one more which removes it.
As for the MySQL installation, you could try a precondition for your setup.

Re: Incorporating setup with other EXEs

SPSandy2-Jan-14 23:21

SPSandy

2-Jan-14 23:21

Thanks for the suggestion. I did that but the setup gets abandoned once I remove the EXE.

Re: Incorporating setup with other EXEs

Heriberto Lugo5-Jan-14 20:14

Heriberto Lugo

5-Jan-14 20:14

I think he meant add an action that removes the exe after set-up is complete..

Recovering VB.NET code

Tim Carmichael2-Jan-14 7:37

Tim Carmichael

2-Jan-14 7:37

I just found out a VB.NET DLL application was not, as I thought, put into SourceSafe. I do have the complied code (DLL, PDB, XML). Is there anyway I can recover the bulk of the original .NET code?

The folders were supposed to be backed up, but obviously weren't...

Thanks in advance,

Tim

Re: Recovering VB.NET code

Ron Beyer2-Jan-14 7:52

Ron Beyer

2-Jan-14 7:52

Download JetBrains DotPeek[^], it has an option for decompiling back to a project. As long as the original project wasn't obfuscated it should produce workable (or close to it) code.

Edit: JetBrains produces C# code, you can use any number of C# to VB converters to convert it back to VB.

Re: Recovering VB.NET code

Tim Carmichael2-Jan-14 8:36

Tim Carmichael

2-Jan-14 8:36

Thanks for the information; working on the recovery and will advise of my results.

Graphics

KanSanRag2-Jan-14 4:03

KanSanRag

2-Jan-14 4:03

How to plot sin wave in vb.net

Re: Graphics

Chris Quinn2-Jan-14 5:03

Chris Quinn

2-Jan-14 5:03

Try this link[^]

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Data repeater

tsunamigang31-Dec-13 2:24

tsunamigang

31-Dec-13 2:24

What is the exact use of data repeater??

Re: Data repeater

thatraja31-Dec-13 2:50

thatraja

31-Dec-13 2:50

Please add "Google search" to your new year resolution(s). Thank you
DataRepeater Control for Windows Forms[^]

thatraja

Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute

datagrid view

tsunamigang31-Dec-13 1:25

tsunamigang

31-Dec-13 1:25

how to fill the values from a sqldataadapter to datagridview in vb.net

Re: datagrid view

Gandalf_TheWhite31-Dec-13 1:40

Gandalf_TheWhite

31-Dec-13 1:40

You can check this article, it shows how to populate data from SQL to DataGridView

http://devpod.wordpress.com/2011/12/08/programmatically-populate-a-datagridview-with-data-from-ms-sql-in-vb-net/[^]

Believe Yourself™

Re: datagrid view

tsunamigang31-Dec-13 1:52

tsunamigang

31-Dec-13 1:52

Thanks bro

Crystal report not generated.

pankaj1985tripathi29-Dec-13 23:17

pankaj1985tripathi

29-Dec-13 23:17

I have using 64 bit system. i am using crystal report but report viewer not supported in 64 bit system. (Server 2008 R2)please tell me any answer.

Pankaj tripathi

Re: Crystal report not generated.

thatraja29-Dec-13 23:43

thatraja

29-Dec-13 23:43

pankaj1985tripathi wrote:
I have using 64 bit system. i am using crystal report but report viewer not
supported in 64 bit system.

You didn't mention about Crystal reports version. Based on your message, you should use 64-bit runtime in that system. Check similar issue with answer
Crystal Report For 64 bit Operating System[^]

Check here & for more details you could try their forums
SAP Crystal Reports, developer version for Microsoft Visual Studio: Updates & Runtime Downloads[^]

thatraja

Function in Linq

alirezamansoori28-Dec-13 20:36

alirezamansoori

28-Dec-13 20:36

Dim Query = From T1 In DataTable1 _
            Join T2 In DataTable2 On T1("ID_DataTable1") Equals T1("ID_DataTable2") _
            Select (Function(p, index) New With {.RowNumber = index+1})

no row get
Frown | :(

Last Visit: 31-Dec-99 18:00 Last Update: 22-Sep-23 11:38

Refresh

ᐊ Prev 1...296 297 298 299300301 302 303 304 305 Next ᐅ

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