20,285 Topics
 | |
| | [CODE]Imports MySql.Data.MySqlClient Imports System.Data.SqlClient Module connection Public conn As MySqlConnection Public Sub xconnect() conn = New MySqlConnection conn.ConnectionString = "Server=localhost;User=root;Database=test;pwd=;" Try [U][B][COLOR="Red"]conn.Open()[/COLOR][/B][/U] MsgBox("Success") conn.Close() Catch ex As MySqlException MsgBox(ex.Message) Finally conn.Dispose() End Try End Sub End Module System.TypeInitializationException was unhandled Message="The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception." Source="System.Transactions" TypeName="System.Transactions.Diagnostics.DiagnosticTrace" … |
| | Guys anyone know how to stop or close a running program remotely through a vb.net program? I am already aware on how to run or open one using the System.Diagnostics.Process.Start method. I would be needing it in my next project Thanks |
| | I HAVE MADE A SIMPLE PROGRAM FOR INVOICES, e.g. THE TOTAL AMOUNT IS COMING 48,950/$, CAN ANY BODY HELP ME HOW TO APPEAR THIS AMOUNT IN WORDS "FORTY EIGHT THOUSAND NINE HUNDRED AND FIFTY. THROUGH MODULE. THANKS. |
| | Hello all, Is there a way of editing the ID3 tags(title,artist,album, etc) of mp3 files in Visual Basic. Any way of doing this via command prompt or audacity from the command line would also work. Thanks a lot and I obviously am no expert at VB so please be detailed …  |
| | Guys is there any way that I can create a program that has the ability to check spelling that are being entered by a user or even displays a definition of a word? For example, when a user keys in a word in textbox then displays a definition into another …  |
| | Guys I just want to ask why my KeyPress event is apparently not working. What I want is that when I press the letter m, the selectedindex property of my listboxes would change. Here is the code; Select Case Asc(e.KeyChar) Case 13 Try tray.ListBox1.SelectedIndex = tray.ListBox1.SelectedIndex + 1 tray.ListBox2.SelectedIndex = … |
| | how can i insert data from data base with selected Datagridview columns i have insert combobox to Datagridview and it can load data from DB now i need insert data to another columns in Datagridview when i change combobox items plzzz helpppppppppppppp |
| | Hello DaniWeb, I have a new idea for an app: I have an external harddrive and I usually backup my desktop with a cleanup folder which I usually move to the external harddrive. The problem is: when I search for a file (i.e. example.mp3) I will find multiple copies which …  |
| | Hi, I want to add a button (ButtonCalculate) to make the user select this button to generate the loop for calculating the sum. [CODE] Private Sub TextBox1Integer_TextChanged(sender As System.Object, e As System.EventArgs) Handles TextBox1Integer.TextChanged Dim OddSum As Integer = 0 Try Dim CountTo As Integer = TextBox1Integer.Text For Index As … |
| | i am having trouble linking 2 listboxes together... What i woud like to happen is a selecting from listbox1 to populate listbox2. Any ideas on what to do? thanks in advance |
| | i have this code in my btnsave..it can detect conflicts but after that a dialog box saying: An unhandled exception of type 'System.NullReferenceException' occurred in AppointmentSchedulingClient.exe Additional information: Object reference not set to an instance of an object. and it points to the green one below. [CODE] If Val(cbostart.Text) > …  |
| | This is my very first trigger and I'm not sure I have it set up correctly. I have a table called PayTypes. Here is my trigger syntax: [CODE] ALTER trigger payTypes_trigger on PayTypes AFTER INSERT, UPDATE, DELETE s PRINT 'AFTER TRIGGER EXECUTED SUCESSFULLY' [/CODE] I run this with a breakpoint …  |
| | guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: …  |
| | I built an app to create a night export of data. I am new to programming (basically I have found vb.net to be more powerful than SSIS) and I was looking for tips in improving my basic program. [CODE] 'Declared columns from SQL Script Dim Servicenumber As Integer Dim pilotarea … |
| | Hi Everyone, I am currently Working on a School Project which has the form of a stock update System. I am using an access 2007 DB and building my code in Visual Studio 2010. I am trying to get an Update Query to work and I am completely unsure on … |
| | How can I cause the Paint event to fire from a Form_Click() event? This is what I'm trying to do... [CODE] Public Class StrTests01 Private Sub StrTests01_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Click Dim ps As Graphics = Me.CreateGraphics() 'RaiseEvent StrTests01_Paint(sender, ps) End Sub Private Sub StrTests01_Paint(ByVal … |
| | What is the difference between window form application and WPF application? Also i want to know about WPF application. |
| | hey guys im really stuck, when i run y program if finds fields fill's them in and submits, but sometimes the page does not have them fields and i just want it to skip them if not found so it continues otherwise it crashes. my e.g field: WebBrowser1.Document.GetElementById("subject").SetAttribute("value", TextBox3.Text) please …  |
| | Hi, I am having the below situation ... In the form i will itemcode, quantity and rate controls.... If i click the add item button after putting values it should get saved in one temp table and should display in the side of the table. The fields should get automatically … |
| | Good morning, Here i am again, asking help to all of you that are able to help me, my problem is the following, i translated some code from C# to VB, mas the code in C3, what it does is change the wallpaper and it's style for Windows Starter, but … |
| | |
| | I'm trying to automate browser at google website, [URL="http://www.google.com/finance/option_chain?q=nflx"]http://www.google.com/finance/option_chain?q=nflx[/URL]. There are several expiration dates in the drop down list. If you choose one, the option table below is updated accordingly. The website script is listed below. [CODE]<div id="expirations" class="id-expirations float sfe-break-left"> <select> <option value="0">Jan 21, 2012</option> <option value="1">Jan 27, 2012</option> … |
| | Dear Friends i have an application using Oracle10g as backend database and visual Basic 2008 front end tool. my problem is i have one application where more thn one user are working on a particular form and when a button, named proceed, pressed it generate next number and stored in …  |
| | Hi, I'm working on a program and keep getting the error "conversion from string to integer is not valid" for one variable and "conversion from string to type double is not valid." I'm fairly new at vb.net and I thought if you converted it you'd be okay. However every time … |
| | I am writing a small program to quickly search through a archive. But i cannot figure out how to get it to filter. I got my regular fields like firstname,lastname, gender, birthyear, street, city, zip, phone. Which i can search through by just entering one of these fields. Then i … |
| | Hi guys, Have been trying this out for sometime with no success. I want to be able to use pdf printing application like pdfprinter to print my vb reports to and then save the reports to a particular location on my computer. Anyone with an idea how i'd achieve that? … |
 | in my combo box, I checked use data bound items and I think I properly set the necessary things... also I have retrieve button that has this statement [CODE]strsql = "select * from books where title='" & cmbTtle.SelectedValue & "'"[/CODE] and the error is type character '&' does not match … |
| | I have several programs that must write to [B]HKLM[/B] in XP and Windows 7/64 Pro. The programs work in VB6 but not in VB.Net 2008 on target machines. It does works on our development machine. Same exact windows. User is an Administrator. NOT using Run as. Both programs are using … |
| | Hello. I'm trying to create a software in VB.Net to disable the following from a Windows 7 pc. - Cut, copy, paste, rename, delete, open, print, share, create shortcut, open with, send to, properties. I want to give users the option of disabling them selectively/individually via checkboxes so those options … |
| | i can't install vb.net connector 6.4.4 help |
| | [CODE]<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <addon id="plugin.video.stagevu" name="StageVU" version="1.3.6" provider-name="AJ"> <requires> <import addon="xbmc.python" version="1.0"/> </requires> <extension point="xbmc.python.pluginsource" library="default.py"> <provides>video</provides> </extension> <extension point="xbmc.addon.metadata"> <summary>stagevu: Watch video</summary> <description>Watch what you have been searching on internet.</description> <disclaimer>The video add-ons hosted by my XBMC add-ons repository(aj add-ons) makes no warranties, expressed or implied, and hereby … |
| | HI ALL I HAVE SMALL PROPLEM I CANT SOLVE AND I THINK ITS SIMPLE I ONLY TRY TO FILL THE DATASET WITH TABLEADABTER BY SELECT WHERE IN FILL,GET METHOD BY SELECT STENAME, PATENT, RCOMER FROM FOURNI WHERE (RCOMER =@RCOMER) I ALWAYS GOT THE ERROR Error in WHERE clause near '@' … |
| | Hi, I have been trying to change the highlight color when the mouse gets on it of the stripmenu...how do I do that? Thanks in advance. |
| | Hi! I have this code in my program [CODE]sqlstat= "select bookNum from booktitle" sqlstat2="select bookNum, bookName from booklist where bookNum not in " & sqlstat & "and bookAuthor like '" ListBook.SelectedItem & "'"[/CODE] but it has "Incorrect syntax near the keyword 'and'" error... please help me with this... response is … |
| | I cannot figure out why this will not execute. For somereason it does not like my inner join I believe but it works perfectly in management studio. Any ideas? [CODE] Dim column_1 As String Dim column_2 As String Dim column_3 As String Dim TotalCol As String Dim D As String … |
| | hi, can someone help me? i am using vb.net2010 and mssql as my database. what i want to do is when i open the form, the database will auto increment the student id and show it on the text box. |
| | Hi, What's the problem in the below code... [CODE] Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter Dim cb As New OleDb.OleDbCommandBuilder(da) Dim dsNewRow As DataRow dsNewRow = ds.Tables("mr_head").NewRow() [/CODE] I am getting the below error : Object reference not set to an instance of an object. |
| | I have 1 Table Called "Menu" there are some textboxes and a combobox. I want to fill data in the Textbox called "Menu_Rate" on Selection of combobox selected item & coressponding rate of the Menu shoud be displayed in the textbox. [U]This is my Code[/U] [CODE]con.ConnectionString = "Data Source=localhost;Integrated Security=true;Initial … |
| | hi i am facing overwriting file in window mobile 6 professional. bellow are my code. when the system start loading: [CODE] Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim line As String Dim Lat As StreamReader = New StreamReader("\Program Files\please_must_be_ok\Resources\contact1.txt") line = Lat.ReadToEnd() TextBox1.Text = … |
| | I am writing an application which calculates profit from 3 column values. The SQL is as follows in vb dataset designer; [CODE]SELECT ID, Sale - (Weight * 20) * (Rate -5) AS Profit From AgencyRegister WHERE (DatePart('yyyy', ArrivalDate) = ?) ORDER BY ArrivalDate[/CODE] I want to add another column of … |
| | im working with vb2010 with ms access as its database and a newbie into programming. is there anybody who have an idea how to make a log in history.. i mean whenever you specify date from..to.. (e.g 01/02/2012 to 01/05/2012 ) on ur filter command it'll display on a listbox … |
| | Hi all! I use vb2010 and I try to filter a datagridview. I achieved to do this but not at the column of dgv like in excel.. I found information about datagriviewAutofilterColumnHeader library but i dont have this library and I dont know if it is ok fro vb2010. I … |
 | Well i don't know how to start, so i'll give some info to see if someone can help me start or give me a push or anything. I got a .txt file containing Example: 1 SN_MOB_THIEF_NPC 도적 0 0 盗贼 0 0 Thief 0 0 0 0 0 0 0 … |
| | Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection … |
| | Hi, I want to connect my vbform having two textboxes with a button.Each textbox will display some value from connected database in a loop (with interval of 5 sec for each value) on pressing button once. Front end :- Vb.net Database : MS Access Pls help me |
| | Whats up guys, So I am debugging my companies program that the previous programmer has created. It is buggy and an annoyance in my life and I want to get this done as quickly as possible. Ive already fixed some bugs and published the updated version onto our server. HERE … |
| | I have a form created in VB.net. It is used to get some information form a user. The form is not bound to any data source. A combobox on this form is used to enter a cost. I want the value entered by the user to be displayed using currency … |
 | [img]http://i.imgur.com/3CDjN.jpg[/img] i want add Listbox; all item's id's and 'song' text Sorry my english bad. Please help me |
| | I am using DotNetBar 10.0.3 AdvTree, (ThreeView), adn i wanted to load content in this AdvTree. I want to add a Node for all folder, and a Child Node for all document. One other think is that i want to hide the extension. Thanks a lot Have a nice day |
| | Hi, i'm doing an app to manage a music school and i'm inserting instruments and i have to create the program (what do you learn) of the instrument. I'm doing a RichTextBox. Now i have some problems: 1st - is to save what i write in the richtextbox in a … |
The End.