Re: Incorporating setup with other EXEs - Visual Basic Discussion Boards

First Prev Next

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 | :(

Re: Function in Linq

Richard MacCutchan28-Dec-13 23:15

Richard MacCutchan

28-Dec-13 23:15

You already posted this in the LINQ forum; please do not cross post.

Veni, vidi, abiit domum

VB Photo Screensaver

Nate Schoonover27-Dec-13 17:33

Nate Schoonover

27-Dec-13 17:33

Hello all!
I am working on a program that I hope will get me more familiar with Visual Basic. I have done lots of programming in other languages, and tons of VBA programming, but this is the first time I am trying to make something completely in VB.

The project is a screensaver that displays photos from a specified folder. The photos should pan and zoom in a pleasing fashion. Eventually I would like to add a fade effect between photos.

To get started I found an excellent photo screensaver project here:
http://blogs.msdn.com/b/vbteam/archive/2009/01/23/an-updated-screensaver-example-matt-gertz.aspx?Redirected=true[^]

Matt Gertz put together a fantastic project that does almost exactly what I want. So I modified the code a bit and use a second timer(1ms) on the form to control the animation of the images. Clearly I have no idea what I am doing, but I did get the basic sliding and zooming effects using things like:

Me.PictureBox1.Left = Me.PictureBox1.Left - 1
Me.PictureBox1.Height = Me.PictureBox1.Height + 1
Me.PictureBox1.Width = CInt(Me.PictureBox1.Height * SizeRatio)

Now that I have thoroughly wet my toes in VB, I wanted to stop in and ask the experts. I know that I am going about this image moving thing all wrong. I should probably be using some kind of ActiveX or OpenGL, or some other graphics engine.

Would any of you be kind enough to point me in the right direction?

Some sample VB projects would be immensely helpful.
In the meantime I will continue to play around with this. There are many flaws that I am happy to discuss if anyone wants. I could send the entire project I have edited if it would be helpful.

Thanks for your time and I look forward to your replies.
Nate

(It's probably worth mentioning that I am running VB Express 2010 on Windows 7 64 Pro.)

Re: VB Photo Screensaver

Eddy Vluggen29-Dec-13 3:13

Eddy Vluggen

29-Dec-13 3:13

Member 10488758 wrote:
I know that I am going about this image moving thing all wrong.

Nope, sounds like a good idea to use controls for this purpose. They're not optimized to be animated though. There's a different set that is, but more on that at the end of this post.

Alternatively, you could check out the forms' properties; it has an OnPaint[^] handler that you can override. You could nicely draw a bitmap offscreen (in a separate thread) and paint it when ready.

Protected Overrides Sub OnPaint(e As PaintEventArgs)
	MyBase.OnPaint(e)
	Using b = _generation.GenerateBitmap()
		e.Graphics.InterpolationMode = InterpolationMode.NearestNeighbor
		e.Graphics.PixelOffsetMode = PixelOffsetMode.Half
		e.Graphics.DrawImage(b, 0, 0, Width, Height)
	End Using
End Sub

Member 10488758 wrote:
I should probably be using some kind of ActiveX or OpenGL

You'd like to dive into the world of WPF[^]. It also uses Forms and Controls, but these are a bit more modern, and rendered using DirectX. Additionally there'll be easier animations, gradients and more of the like Smile | :)

Found two articles on CodeProject related to WPF Screensavers, but both are aiming at C#. There's no specific example for VB.NET (hint, hint)

WPF: A 3D screensaver written in WPF[^]
Another Screensaver with WPF[^]

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Last Visit: 31-Dec-99 18:00 Last Update: 4-May-24 1:25

Refresh

ᐊ Prev 1...300 301 302 303304305 306 307 308 309 Next ᐅ

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