20,285 Topics
 | |
| | Really need help please this is my code: Sub updteWS() Dim sql = "select Count(*) from ItemProduct where Code= ?" Dim cmd = New OleDbCommand(sql, conn) cmd.Parameters.AddWithValue("@Code", LVCart.Items(0).SubItems(0).Text) Dim result As Integer = Convert.ToInt32(cmd.ExecuteScalar()) cmd.Parameters.Clear() cmd.Dispose() If result > 0 Then For Each x As ListViewItem In LVCart.Items Dim Stocks_WS1 … |
| | Hi everyone, I have been strugling wit the "INSERT INTO" statement. I intend to insert the items that are in a datagridview into An Access Database when a button is clicked. I am using VB.NET 2008 express and Microsoft acces 2007. At first, I tried to use the listview, but … |
| | hi, I m using vb.net 2008 & mysql. i need to save array in 2 different datafield in the same database table. For eg: let consider dim n(10) as array & D1 as 1st data field, D2 as 2nd datafield now i need to save n(1) on D1 and n(2) …  |
| | Hi , i need a sample code for Export data from MS-SQL to Notepad.txt using vb.net in Pipe line format this is my sample table data ID Name Address 1 Meenu Meenuhouse 2 Ammu MeenuHouse 3 Chinnu Meenuhouse i need output like 1|Meenu|Meenuhouse 2|Ammu|Meenuhouse 3|Chinnu|Meenuhouse Can any one help me … |
| | hi. few days ago I open a microsoft azure account and create a virtual machine. download SQL server managment and do everything ready. open TCP port 1433 and my DSN name is btca.cloudapp.net now I cant connect with the database inside it... what to do. Im looking everything but nothing … |
| | hi. few days ago I create a Azure account and create a Virtual machine. download and install SQL server managment, open TCP port 1433. but cant connect to my app.. my DNS is btca.cloudapp.net but cant connect. tried to connect with DSN & IP but nothing happening. any suggestion? |
| | hi. few days ago I create a Azure Account and create a Virtual Machine install SQL server managment. open TCP port 1433. but now I cant connect to my app... my DNS is btca.cloudapp.net but cant connect the code with the database... please help me... |
| | Public Class Form1 Private Function getCrc16(b() As Byte, nLen As Integer) As UInt16 {&H0, &H1189, &H2312, &H329B, &H4624, &H57AD, &H6536, &H74BF, _ &H8C48, &H9DC1, &HAF5A, &HBED3, &HCA6C, &HDBE5, &HE97E, &HF8F7, _ &H1081, &H108, &H3393, &H221A, &H56A5, &H472C, &H75B7, &H643E, _ &H9CC9, &H8D40, &HBFDB, &HAE52, &HDAED, &HCB64, &HF9FF, &HE876, _ &H2102, … |
| | |
| | Hello everyone, i have the code below, it works fine but whenever i insert a student number that does not exist in the table, the rest of the textboxes will keep displaying data from the previous existing entry. This happens even when the i delete everything in the student number … |
| | |
| | |
| | Hi all! I have just developed an application on VB.NET with mysql. I then need to deploy this to clients workstations. The plan is to install mysql server on one computer and have all other clients connect to this. What do I need to install on the server and what …  |
| | how to mute mic/line output in vb.net? how to mute microphone in vb.net? |
| | how to find monitor brightness Level in vb.net? Change Display Screen Brightness. |
| | Hi,I wan to sort my added record on the top of datagridview.I had try a few way to sort it but it no function.*"attn_id"*is a primary key in database. using (TMPB_attn_DAL dalObj = new TMPB_attn_DAL()) { dataGridView1.DataSource = dalObj.GetRecords().Cast<TMPB_attn>().ToList(); dataGridView1.Refresh(); dataGridView1.Sort(dataGridView1.Columns["attn_id"], ListSortDirection.Descending); } when i run the above code it …  |
| | I import excel file and show on datagridview I want insert all row datagridview to mysql. But i receive error: Incorrect date value:'11/14/1991 12:00:00 AM' for column 'Ngaysinh at row 1. Mysql : i using date : yyyy/mm/dd datagridview show : mm/dd/yyyy. i don't know error: '12:00:00AM ' ???? column … |
| | Hello again. as some of you may know Im creating a software based on SQL dataserver, every code I use is good and work and I use this connection string Dim conn As Data.SqlClient.SqlConnection conn = New Data.SqlClient.SqlConnection("Data Source=192.168.0.100,1433;Network Library=DBMSSOCN;Initial Catalog=SS;User ID=Al;Password=altn") But the ip is the other pc (next …  |
| | I've got my code all ready to go, except what i want to do is have the 'btnSTART' button move the mouse to the selected coordinates, and Left Click down then Left Click up. Here's my code: Public Class Form1 Public Declare Auto Function GetCursorPos Lib "User32.dll" (ByRef lpPoint As …  |
| | Hi, I am having trouble with dropping a temp table. I was using it so many times in other projects but this time it went bad. The only thing different now is that I referred a string value from the main form to another form.The other form populates a dgv …  |
| | hi guys, i had an account on Daniweb but forgot password and recovery was a bit hectic so decided to crreate a new account. the previous username was emma etigu. i have a problem and need some help. below i have two tables from my dataset, i would like to … |
 | Group, I'm using the following code to read down to the third line of a text file. If it meets the criteria, I need to stop the read and then delete the file. However I'm finding it difficult to do this as everything I've tried has failed. Have you some … |
| | i connect mysql using c# and show database in datagridview I want when i click the row in datagridview, textbox, combobox , datetimepicker will show form datagirdview But mysql datetime : yyyy/mm/dd 00:00:00 ( 00:00:00 will default if don't write) Datagridview : mm/dd/yyyy i used code: datetimepicker1.DataBindings.Add("text", dataGridView1.DataSource, "Birthday"); and … |
| | I want to show only specify database table in datagridview.I had use dataGridView1.AutoGenerateColumns = false; but i don't know how to add the column.For example on of the column is "attn_id".How should i add it? here my code to connect database private void tmst_timein_new_Load(object sender, EventArgs e) { try { … |
| | hello. recently Im having this error. Why is this? why is that? PS: after enter a 2nd person in the database it has imported and the first person in. Sometimes when import the data fast, it upload the person, if it take for a while (~40 seconds or more) it … |
| | I am suppose to display 3 error messages,Premium Channels is a required field,Customer Type is a required field and If a business checkbox is checked an error message is suppose to display saying Business Customers must select 1 or more Connection." can anyone tell me why just the Business Customers … |
| | I have been working on a pig latin converter. If a letter starts with a vowel or number it should end with way if it begins with a consonant it should revert the letters so the first one begins with aeiouy like chair should be airchay. Everything in my program …  |
| | Hi group, I'm using VB.net to convert an output file (text) from a Linux based program into a file that will easily read in Notepad. I found some code in VB.net to do this conversion for UNIX that works "OK" (meaning fair but not perfect). It looks like this: txtLine … |
| | Hi group, I'm attempting to use a variable (i) to read the multiple files within a folder. However this doesn't seem to be working. Can you tell me what I'm doing wrong? For i = 0 To counter Dim objReader As New System.IO.StreamReader(getRestranName(i)) If System.IO.File.Exists(folderName) Then Do While objReader.Peek() <> … |
| | What I am currently trying to do is have the user press a button, upon pressing that button, the cursor turns into a crosshair. Wherever the user clicks next is the point recorded in the code. Any help is appreciated. |
The End.