20,279 Topics

Member Avatar for
Member Avatar for Tinnin

Hi All, I've tried the following to format my date in 'dd/mm/yyyy' instead of 'dd/mm/yyy hh:mm:ss' when importing data from csv to DataSet. CONVERT(VARCHAR(10), [dateColumnName], 103) AS [DD/MM/YYYY] and CONVERT(DATETIME, [dateColumnName], 101) AS [DD/MM/YYYY] Both give me the error: Undefined function 'CONVERT' in expression What would be the correct method …

Member Avatar for Tinnin
0
548
Member Avatar for san.ssj

Hello, As mentioned in the title I wanted to generate a data report and found this bit of code on microsoft page. http://code.msdn.microsoft.com/vstudio/VBWinFormPrinting-ca19810f Hoping Im correct, Private Sub printDocument1_PrintPage(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) Dim f As Font = New Font("Vanada", 12) Dim br As SolidBrush = New …

Member Avatar for Begginnerdev
0
155
Member Avatar for kumar_g

Hi Freinds I am programmer in VB.net & wanted to make a software Well this is a common problem. Consider there are 2 friends A & B One day A requires an urgent document which is there in B's laptop But unfortunately B is out for some work & will …

Member Avatar for Begginnerdev
0
263
Member Avatar for SLMQC

I am new to VB and working on a homework assignment that I’ve seen posted in years past. The threads were aged a year or more so I’m starting a new discussion. I am writing a program that allows me to enter sales for 5 stores and display a bar …

Member Avatar for tinstaafl
0
332
Member Avatar for tunavis

Public Class Carwashform Const EXTERIOR1_String As String = "Hand Wash" Const EXTERIOR2_String As String = "Hand Wax" Const EXTERIOR3_String As String = "Check Engine Fluids" Const EXTERIOR4_String As String = "Detail Engine Compartment" Const EXTERIOR5_String As String = "Detail Under Carriage" Const Interior1_String As String = "Fragrance" Const Interior2_String As …

Member Avatar for Reverend Jim
0
640
Member Avatar for mrkm1188

I'm creating a form for employees to fill out and submit work orders but only employees in a certain security group in AD are allowed to use the program. Can someone give me the basic overiview of how i would write code for checking the users current windows credentials (the …

Member Avatar for Begginnerdev
0
149
Member Avatar for pbedford83

Hello everyone, I hope someone can explain something to me. Im a Junior Developer with very limited knowledge in VB.net, but I am self teaching. I will soon have projects to do whilst at work, and although my coding is pretty ok now, one thing eludes me, and I cant …

Member Avatar for TnTinMN
0
249
Member Avatar for somjit{}

hi everyone :) im hoping to learn a healthy amount of vb10/12 by the end of the month. mainly to improve my cv and get a better shot at jobs. originally wanted to learn vb6 for a college project , but after a post in daniweb , my ideas are …

Member Avatar for somjit{}
0
315
Member Avatar for vishnation

hi all i am making a tabbed notepad and i have added RichTextBox At runtime.now i want to add it's sub procedural but i don't know how to add sub procedural at run time. i want to addd sub procedural with handle textchanged event. i had added follwig code for …

Member Avatar for tinstaafl
0
248
Member Avatar for Purrenhage

I am creating a program that make a person select different options and in other boxes it will populate the choice the person makes. Example is the program is fora car wash and if you choose standard or deluxe it will show in the other boxes what comes with that …

Member Avatar for tunavis
0
198
Member Avatar for Papa_Don

Group, I need to use Function keys within a form I've created. The problem I'm having is determing the correct routine to fire it off. Here's what I'm attempting to do: In Form1 (actually called "OrderEntry2"), I want to give the user the option of keying in a part number …

Member Avatar for Papa_Don
0
407
Member Avatar for bklynman01

I have a program I wrote a few years ago that interfaces largely with MS Excel. At the time my company used Office 2007. We have since upgraded to 2010 with no problems. However, I had to make some adjustments, and now I can not compile. The error is Error …

Member Avatar for bklynman01
0
179
Member Avatar for jsteele623

First, I need to read from a text file and display the results in a textbox. The text file is two columns, 18 rows, with the first column a certain ingredient and the second the amount of that ingredient remaining. Depending on what is ordered, the amounts in the list …

Member Avatar for tinstaafl
0
133
Member Avatar for Tinnin

Hi all, I'm trying to bring up a table of data using a select query to create a DataSet that I'm displaying in a datagrid. When I use SELECT * FROM myTable it works fine, but when I only want the specific columns SELECT URN, 'CanX Reason', 'Date to take …

Member Avatar for Tinnin
0
171
Member Avatar for androidz

Hi danibians, wonder where i got this error. it got error after it reads the runcompleted process. here is my code Hi Everyone, Hope you could help me with this. I got an exception error saying "Exception has been thrown by the target of an invocation." here is my code: …

Member Avatar for androidz
0
436
Member Avatar for Djmann1013

Why does this error occur? Here is my code: Imports System.IO Public Class Form1 Private Sub Button1_Click_1(sender As Object, e As EventArgs) Handles Button1.Click OpenFileDialog1.Title = "Select Image" OpenFileDialog1.InitialDirectory = "C:\temp" OpenFileDialog1.FileName = "Image File" OpenFileDialog1.Filter = "JPEG Images (*.jpg,*.jpeg)|*.jpg;*.jpeg|Gif Images (*.gif)|*.gif|PNG Images|*.png" OpenFileDialog1.ShowDialog() End Sub Private Sub OpenFileDialog1_FileOk(sender As …

Member Avatar for Djmann1013
0
1K
Member Avatar for aarviii

**please help me. i need to take each string in each column of my datagridview** `roivic lanoria ASRock 2.4 GHz Dual Core SSD 160 GB` **and look like this in my datagridview** `roivic lanoria|ASRock|2.4 GHz|Dual Core|SSD|160 GB` **these strings are from a text file. help please.**

Member Avatar for Reverend Jim
0
250
Member Avatar for silvercats
Member Avatar for dinesh012

I have a Database It created in Ms accsses how can i set a fix path to connct the database when i install the setup in another computer? plz help..?

Member Avatar for Begginnerdev
0
263
Member Avatar for manoj_582033

Friends, I Have a Datagridview in My Form, i am Using Combobox on datagridviewcellbeginedit event, it's Working But In this condition i am not able to using combobox_textchanged event, Suggest me any Idea....

Member Avatar for Begginnerdev
0
84
Member Avatar for Papa_Don

Group, I'm thinking I may want to use the Date data type in SQL Server. However I'm still very unclear how to read, write and compare using this kind of data type. I realize this has a time component which is of no importance right now (it will be later …

Member Avatar for Papa_Don
0
232
Member Avatar for Papa_Don

Group, I'm having an issue with SQL Server that has me baffled. I need help. When I originally loaded SQL Server 2008 Express and created my database, I called it "DataDesignSolutions". The tables were created through VB Studio 2010 Express. It's path was "C:\User\Don\Documents\DataDesignSolutions.mdf". I'm not sure how, but somewhere …

0
159
Member Avatar for aarviii

**how can i read a specific text from a text file back to a textbox?** **so here are the text** `heburn@YAHOO.COM, TAGUIG, 9460593, ASRock, 2.4 GHz, Dual, Core, HDD, 160 GB,5, 200, 2 GB, 2,512 MB, YES` **and i just want get the text** `TAGUIG` and `HDD`

Member Avatar for Reverend Jim
0
458
Member Avatar for grgrl

I would like to know how to take selected information from a listview and add them to a .dat file This is what i got so far but it is to save into a text file Sorry for any mistakes i am a noob Private _filepath2 As String = Application.StartupPath …

Member Avatar for grgrl
0
2K
Member Avatar for jakewebb

Hi the problem I am faced with is after adding around 35 video files of both .avi and .mpg with a total file size of around half a gig to the resources of my project, I get an error message on debug telling me "Error 1 Unable to write to …

Member Avatar for tinstaafl
0
1K
Member Avatar for ChargrO

Hi guys im writing a program and was wondering what the code would be to prompt for a password when pressing a button ie. I have a button that checks who earns the most money and only certain people have access to that button through a password.

Member Avatar for Mr.M
0
158
Member Avatar for savedlema

Hi all! I use VB.NET + Mysql. I have two tables (tblstudents & tblpayments). I want to view payments details of a selected student. Thus, I'd like to select some values (firstname,middlename,surname) from tblstudents and (all values from tblpayments WHERE class = @class -I know how to deal with @class, …

Member Avatar for savedlema
0
536
Member Avatar for Kujee

I am new to VB. Currently i am doing a Stock manage program with VB and SQL 2008. When Receive new stock from Supplier,I put recive item in a winform with DataGrid view. some thing like this **Item Description Received Qty UnitPrice Total** 1001 Acer Laptop 10 455 4550 1005 …

Member Avatar for Kujee
0
448
Member Avatar for Papa_Don

Group, After asking what seems to be a thousand questions, clearly there is so much more to learn about Visual Basic. So this prompts my "Today's Question": Are there some good online courses or classes at a local college that I can take? By the way..... I live in the …

Member Avatar for Papa_Don
0
179
Member Avatar for jayrbete

Can you help me about inserting video in resources of visual basic and how to call it and play in my media player in a form..because i have media player in my project and my problem is how can i insert video and call it from resources... i hope you …

Member Avatar for jakewebb
1
4K

The End.