20,899 Topics
 | |
| | When I run this I get an error saying that the sql syntax is wrong. [U]Field types are:[/U] [B]Time:[/B] Text [B]Date:[/B] Text [B]SalespersonID:[/B] Integer [code=vb.net] Dim sqlWrite As String = "INSERT INTO Audit (Time, Date, SalespersonID) VALUES('" & CType(lblTime.Text, String) & "','" & CType(lblDate.Text, String) & "','" & SalespersonID & … |
| | hi, iam new mysql with vb.net , i am install mysql in my machine 3 more user have to access the mysql database , my question is that , i need to install mysql in all the client machine? looking forward ur suggestions kannan |
| | Is there any way to identify the specific instance of word that a vb.net applcation creates [code] objWord = New Microsoft.Office.Interop.Word.Application objWord.Documents.Open("C:\TestFile.rtf") objWord.Visible = True [/code] In the text above how can identify this instance of word to close it after a specific event or period of time. |
| | Hi, I am trying to write the syntax using a FOR loop to sum numbers base on user input from a console apps. The user enters the total amount numbers to add 2 for eg then the actual numbers to add 4 and then 4 for eg. so the using … |
| | Is there any way for an application to wait for a period of time and then kill a file? |
| | Hi guys. I have now looked at hundreds of articles and forums for solutions. I have the following forms: A db selector form. The form has a combobox where I want to load the connections(connection name) you want to use to connect to a sql database. I need the user … |
| | help me how to open a tab page in tabcontrol by using coding |
| | All, I have been working a vb6 app since 1999 and it has over 100 forms that work with ADO - COM and am looking for a simple way to access MSAccess for each form. Some forms have several old ADO connectors using late binding to connect the the database … |
| | Hi I'm currently using data binding, combo boxes, grids... I need to filter the data in a DataGridview depending on a value selected in a combo box. The combo is bound to a table, displaying data from a particular column, while the datagrid needs to "query" a second table "...WHERE … |
| | Hello: I hope I'm in the correct forum for this question: Does anyone know if the .net api for autoCad allow you to work off the internet; or rather, it for developing in client/server environment only. Thanks, Proctor |
| | hi, I'm trying to make a AutoCad tool palette with some tools, from VB.Net, i have been roaming through nets for some materials & help, but i coud'nt get atleast one also, so if U know any resource regarding this please forward it to me, thank U in advance, bye...................Prakash.C |
| | I have a a process that loads a datset and prints it in VB.net. I need to make this available to avb6 legacy application. Does anyone know how to do this? |
| | [B][I]iam doing project in vb.net with mysql any one help me how to create setup for project[/I][/B] |
| | I want to retrieve data frm my DB in a datacombo what event nd property shud i use plz help me with the single line code to retrieve data  |
| | i have this project. it calculates the checkout an hotel. first i need it to calculate the first subtotal which is costpernight*numberofnights. and second additionnal charges. its telephone+laundry+roomservice. thats my first step it should be done wihout any button it should appear to the user from inputing the values for …  |
| | I'm trying to determine why I receive this error message when attempting to update the database.."Syntax error in UPDATE statement", please assist! Thanks! [code=vbnet] Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click Dim SQLStmt As String Dim UpdateOK As Integer If txtFirstName.Text = "" And txtLastName.Text …  |
| | [B][I]help me .... how to clear data in specific column in vb.net[/I][/B]  |
| | I need the code on how to read and manipulate text in a textbox get the date in month#day# format and the process and output in the same box upon Enter |
| | Can someone please tell me why I'm receiving these error messages when attempting to take on customer data from a flat file: - Error 1 Name 'OpenFileDialog1' is not declared. - Error 5 Overload resolution failed because no accessible 'Split' can be called without a narrowing conversion: 'Public Function Split(separator() … |
| | Hi, I m making a telephone directory using VB and MS-Access.i have taken code from net and made some changes in it.After that i made new table in access but i m getting old table's column name (which already exists with d code downloaded fron net) and new table's content.can … |
| | [B][COLOR="Green"]IN MY FORM THERE IS TWO DATATIMEPICKER AND ONE BUTTON WHILE CLICKING THE BUTTON MESSAGE SHOULD DISPLAY TIME DIFFERENCE BETWEEN TWO DATETIMEPICKER.............................................. ANY ONE HELP ME BY SENDING CODING[/COLOR][/B] |
| | Guys I know there is a way of only writting 2 lines of code in VB.Net when Connecting to a database that are [ICODE]DataAdapter.fill(Dataset, "Tablename") [/ICODE]and then u can have all the buttons required such next, delete, previous, last and so forth without adding them but I dont know how … |
| | First off let me start by saying I'm not a programmer, but envy those who can. My programming style consists of find someone elses code or tutorial and making it fit my own. Currently I'm working on a project where I can send a command from another computer thru the … |
| | What is wrong with this code? All I want to do is display photos for a slide show, with about 5 seconds pause between photos. It will only show the last photo. The photo directory and file names are contained in the ComboBox. (I thought I posted this wrong, so … |
| | Hi there Sorry if i have posted this on the wrong area. I have a problem with a simple query shown below [code=sql] SELECT * FROM Disney WHERE Upper(COLNAME) LIKE UPPER('%' || SEARCHSTRING || '%'); [/code] My problem, The colname variable is not being recognised as a column name for … |
| | [I][COLOR="Red"][/COLOR][/I][B]any one help me how to store image in database in vb.net coding[/B] |
| | [B]any one help me how to store image in database in vb.net coding[/B] |
| | I need to store date from my application in to my database which created in MS Access now i use datetimepicker in my application created in VB.net 03 what shuold be the necessary code required for it plz help me with code snippet... |
| | i am facing the same issue but it kinda different as yes am doing an E-commerce project coding with ASP.NET and VB.NET using Dream Weaver. i require some validation if this is the best way to go? or if u fellow learned fellows have a more better idea that i …  |
| | Im doing an application that runs on vb.net using oracle database. The function that i did is to select 3 combo boxes for the information to come out. The problem is i can only retrieve the records from the first selectedindex=0 of the ifelse statement and not from the others. … |
| | I am writing a simple application in VB.NET to view JPG files. I have a slide show option, and can only get my PictureBox1 to display the last photo. ComboBox1 contains the directory and file information for each file. Here is my code. Thanks for your help! Private Sub cmdSlideShow_Click(ByVal … |
| | I need help to fixe my code for date convert to letter . I made a Pulic class where i identify day , month , year as integer . After i call a funtion to flash them on screen in little form . Now i need to convert this date … |
| | There are two versions of my application. First runs on a local server and the second version runs on a client machine. The application on the local server performs that following tasks 1. Pulls data from an online Mysql database and stores it in a DataSet 2. Makes changes in … |
| | [B][B][COLOR="Red"]:) [I][/I][/COLOR][/B][/B] |
| | in vb.net how to display current year in textbox |
| | Hey Guys, im a fairly novice programmer I would just like to hear some views / opinions on how you would go about implementing the following: I need my program to save data to a textfile giving the file a name and adding a number to the end eg filename_1.txt. … |
| | how do i output like datetimepicker.text to a listbox... I tried datetimepicker1.text but it did not work....can someone help me please my code is like this... Rpanel.Hide() Plistbox.Items.Add("Customer Name" & ControlChars.Tab & _ ControlChars.Tab & "Booking Date" & ControlChars.Tab & _ ControlChars.Tab & "Booking Time") Plistbox.Items.Add(Bcusname.Text & ControlChars.Tab & _ … |
| | Please help me with my project When the form loads it will connect to serial com and retrieve the number of chinups from a PLC and store it a variable called 'int' there is a textbox in the form called 'txtname' and a button called 'ok' My question is when … |
| | hello guys, i need help assigning details in a listbox to a button, therefore changing the buttons color....any idea...i manage to do something here.... [code] PListBox1.Items.Add("Customer Name" & ControlChars.Tab & _ "Booking Date" & ControlChars.Tab & _ ControlChars.Tab & "Booking Time") PListBox1.Items.Add(Bcusname1.Text & ControlChars.Tab & _ ControlChars.Tab & ControlChars.Tab & … |
| | hey .. I need a help .. How can I find out how many macros are present in an excel file using excel objects in vb.net .. DO u hv any idea about it?? |
| | [B][COLOR="Green"]how to display two fields in checkedlistbox from database i want to display empid,empname any help me[/COLOR][/B][B][/B] |
| | PLZ HELP ME OUT ON THIS...ITS VERY URGENT..... Hi...plz help me out on this...i have stuck up here for past many days... 1) Plz tell me how to update the Database Table from the datagrid... here is my code : ITS A ATTENDANCE FORM CODE... I AM RETRIVING MY ATTENDANCE … |
| | [B]any help me urgent i have a list box in my form in that i want to display empname and empid from database[/B] |
 | :'( please help... i want to know the syntax in the checkbox and option button.... any idea please.... :?: |
| | [CODE] Imports System.Data.OleDb Module Module1 Sub Main() Dim Cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\mibase.mdb;Persist Security Info=False") Cn.Open() Dim comando As OleDbCommand comando = New OleDbCommand() comando.CommandText = String.Format("SELECT Telefono FROM empleados ") comando.Connection = Cn Dim lector As OleDbDataReader lector = comando.ExecuteReader Do While lector.Read Console.WriteLine(lector("Telefono")) Loop Dim nombres As New … |
| | Hi, I made a form having control reportviewer and when I run my web I got the following error: Failed to map the path What is the problem I neeeeeeeeeeeeeeeeeeeed Help quickly please :( |
| | I need to average the numbers in the array and display and also detemine the letter grade and display. I've managed to average the numbers but I am unable to display the lettergrade, (won't compile) I think it has to do with "Average Grade" being a constant string This is … |
| | Dear friends I am electrical engineer of 54 yr age. Recently, I have developed interest in vb6. Vb.net is too complex for me to understand. At present I am trying to develop a software in which family details are to entered. family.mdb is having tables, name, place & family. To …  |
| | Hey, I was wondering if anyone knew of a way to have a vb.net app that can load a batch file, and run it inside the vb.net app. Something like, when you open the application, you will see a blank window with a big button that says "Start Batch File" … |
| | Hi All, I have a program trying to use mousehover to pause the autoscroll. It is a widows form called: lstOutput System.Windows.Forms.1 Below is how it is in my code. Public Sub lstOutput_MouseHover(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstOutput.MouseHover 'Public EventMouseHover As EventHandler lblPauseScroll.Text = "Output Paused" … |
The End.