20,899 Topics
 | |
 | 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 …  |
| | Hello, I'm fairly new here and based on the help that i've seen people give I though this would be a great place to ask! Basically, I'm new with coding, so I decided to work with Minecraft - specific a Minecraft Server Starter. It has a built in text box … |
| | Hi everyone, I have an interesting situation at hand. I already succeeded in uploading files (.doc, .docx, etc) to both the database and a folder on the server. I can also download the files to client systems successfully without any issue. However, my manager wants people to be able to … |
| | can controls of vb.net be rotated? example: Panel1 rotated in 35 degrees. |
| | I just want to know, what exactly the difference between the functions CStr() and Str()? |
| | my code: command1.CommandText = "INSERT INTO table1,table2(value1...,value2..)VALUES('" ...... "')" how to save multiple table is one query? i tried this thing but it didn't work. anyone who can help me with this please.. thanks  |
 | Hello All, I need help in this... I am attaching a zip file which contains my project in Microsoft Visual Studia 2010 along with Crystal reports.... Please help me....its giving a lot of errors...and I dont know from where it is coming and why.... Urgent help.... |
| | hi, what i need to do is to get information from 2 tables and show it to the listview. for example, i want to get the surname, first name and middle name from the student_info table and the Payment_Status from the accounting_system. i don't want to show the information that …  |
| | i have a data grid,, connected in ms access via code, on its celldoubleclick event i have the code [CODE]Public Sub dgv1_CellDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgv1.CellDoubleClick Dim empid As Object = dgv1.Rows(e.RowIndex).Cells(0).Value display.Text = Convert.ToString(empid) editempfrm.ShowDialog() End Sub [/CODE] it suppose to display its content … |
| | Hello everybody. I hope I'll find help here. I didn't know where to put this topic: here, or on php or delphi forum. Because I don't know from what to start. I have a lot of data stored in Word document. Over 1500 pages. And I want to make a … |
| | Hi, I seem to be getting the error "Syntax error in UPDATE statement." when attempting to update my database through visual studio 2008, using forms. Here is the code for the connection: [CODE]Private Sub btnLoadDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadDB.Click Provider = "PROVIDER=MICROSOFT.ACE.OLEDB.12.0;" Source = "Data … |
| | Hi. Can you help on my project. My code in search button doesn't run. I am making a Directory System and the following information must appear when you click search button..Remarks,Telephone Number, First Name, Last Name,Address. Email me the code at <<Snipped>..im hoping for your help on my project..Im creating … |
| | Hi, i made an application using VB.NET 2010. i have 5 forms. i want to know how to make one common navigation (like in a webpage) for this application. Is it possible to have the menu and header static and loads each form in one dynamic container. I hope my … |
| | Ok so I have a program that can save user's input into a text file and load it back, but whenever I try to open the file and exit without selecting the file I get an error.(if i select the file and open it i don't get any errors). this …  |
| | im working on vb 2010 and ms access db.. just want to ask if a textbox with databinding can be used to search or filter data and display it to other textboxes with databinding on the same form? thank you.. |
| | Hello all, I'm Abel from Ethiopia, first time poster and hopefully a long term member. Let me get to my question and will introduce myself in another thread. I was given an Information Retrieval assignment and was asked to implement a simple version of an n-Gram. We have yet to … |
| | Hi, I am having a problem with the if statement that I created in my code. The condition should be: - Select Both Comboboxes (1&2) to print out a text in TextBox1 - If only One Combobox or No Combobox was selected, an error message appears and Nothing is printed … |
| | Hello all, Im new to VB so go easy on me :-D Im trying to autofill a html form and all textboxes and textarea is working ok.. I now have a problem with a combobox1. I added the items below to the combobox1. So whenever i choose one of those …  |
| | Hi I have a datagridview in my winform application and I have 2events related to it. one is [COLOR="red"]Cellformatting[/COLOR] which is formatting a row in datagridview as per different values. and another is [COLOR="red"]UserdeletedRow[/COLOR] event which allows to delete a particular row. but there is a conflict as I have … |
| | Im trying to move all files from "C:\SSIS\Test1\" that are new than 2 days old to the C:\SSIS\Test\" but for some reason it keeps skipping over the if statement marked in red. Any help please. Very amateur programmer here! [CODE] Sub Text() Dim sDay As DateTime sDay = DateAdd(DateInterval.Day, -2, … |
| | I have this OLEDB connection string connectionstring as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ data.toString & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2 I just want to know what is the meaning of HDR and IMEX, and what are their purpose on the connection string Thanks.. |
| | Hi all, Check this code and please tell me a solution.I have 2 buttons (Pizza & pepsi),the price should display in textbox8 when i click on button, here the price had shown in Textbox8,but it is not getting added with next price when i click second button. [CODE] Private Sub … |
| | 'why is that when i change something on one form, when i ran the program,the changes i made don't seem to take effect? example, i set a button's visibility to false, when i ran that form, the button still appears. even if i already saved it before running i already … |
| | Guys anyone knows a site where I can have free access to information regarding Visual Basic.Net? I am now applying for a programming job but I'm just worried that my knowledge gained from school might not still be enough. Thanks... |
| | hey anybody can guide me in order to get in to the cloud development which platform will be the best and easy one please |
| | I know to work with VB.net + crystal report + SQL server. But now i want to work with SQL server compact edition instead of SQL server. When we creating Crystal report it is asked provider in one moment. If we work with SQL server we select "Microsoft OLE DB … |
| | I was wondering if someone could help me, im looking to make a program to check if an item is in stock on a website, but im not too sure about how to go about it. Any pointers? |
| | I was just wondering if I can retrieve two tables from my database to one form? because i'm trying it but it doesn't seem to be working. just the first table i'm trying to retrieve is working. |
| | I have an application and an sql server i would like to add Registration Code for the system. that should include the number of user |
| | Ok I have Googled for the answer but couldn't find one. I want to run my project on another computer without visual studio. I have created a setup file but after installing also i need visual studio.Isn't there any another way round?  |
| | how to connect combobox to ms access database item ..............i need please say step by step and the database item are id name itemno 1 motherboard 5 2 keyboard 8  |
| | Some one help me here my problem is on the [CODE]conn.Open()[/CODE] it stated that "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to … |
| | I was just trying to compile a program from Sams Teach Yourself C#, I've done some before but just changes to an existing program. Now I'm trying to make my own. I get an error on the picShowPicture command. I believe it's in the System.Drawing namespace which I have a …  |
| | hai there!.. need someone help regarding vb 2008 as below!!...huhu 1.how to make connection between mysql and visual basic 2008. 2.how to write insert the query... please3 someone please help me with this.. i goin crazy already...huhuu :sad::S:'( |
The End.