20,284 Topics
 | |
| | 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 … |
| | 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 … |
The End.