20,279 Topics
 | |
 | Hey guys i need some help on how to Subtract the Dates i used a readline for sotring the number of fines per day on a txt file....now i wanted to know how do you subtrack the date the book borrowed and the date it was returned then multiplying the … |
 | Hi all, I have a procedure that compares release dates to file download dates. I have a download folder that is added to a string Dim strFilePath = "\EconomicDBTemp\DownloadedCSVs\" I've removed the directory but the folder DownloadedCSVs is where I need to search each csv file. However, I am unsure … |
| | Good day, I keep running into a very persistent "Could not fine installable ISAM" error when trying to connect to an Excel sheet (office 2010) by opening an OledbConnection Here's my connection string: Dim strCon As String strCon = "Provider=Microsoft.ACE.OLEDB.12.0;ACE OLEDB:Database Password=" & strEnter & ";Data Source= " & strExcel … |
| | I need some help here. I am writing a little desktop app that monitors my ToDo database and whilst it works great when run once, it kind of freaks out when I run it from a timer. As in all the labels start repeating. Below is the entire code. Imports … |
| | Hey guys its me again...im having some problems modifying the data in the DataGridView The error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where UserID='3'' at line 1 and it highlight this … |
| | Hey guys i need some help on how to create a connection of a relationship between two forms...for example I have a DataGridView on another form....with a search button.. if i click the search button another window will pop out with a text box lable "Look For:" and a combobox … |
| | Hey guys im having problem with the registration form that i created the error shows after i tried some error handling if the username already exists this is the error message: `{"Invalid attempt to Read when reader is closed."}` and this is the error highlight `While mydr.Read()` Heres my code … |
| | Friend Sub Inventory_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'Connect to database dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbSource = "Data Source= C:/Inventory.mdb" con.ConnectionString = dbProvider & dbSource 'Open database connection con.Open() MsgBox("Inventory is opened now") 'Import the data on tables sql = "SELECT * FROM Brands" sql1 = "SELECT * FROM … |
| | I have problem with making my program works on windows startup. Here's the code: Sub RunAtStartup(ByVal PutAtStartup As Boolean, ByVal Name As String, ByVal Path As String) Dim StartupPath As String = "Software\Microsoft\Windows\CurrentVersion\Run" Dim myKey As Microsoft.Win32.RegistryKey myKey = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(StartupPath, True) If PutAtStartup = True Then Try myKey.SetValue(Name, Path) Catch … |
| | If someone can tell me what I'm doing wrong I would greatly appreciate it. I have a listbox of all the US states and an array of the capital of all the states. What I'm trying to do is when the state is selected and the button is clicked, then …  |
| | Here's an example, but Visual basic gives me an error when trying to run it. Say I wanted to ask the user for their name, then display it like: "Hello there" strName By the way, my CDs finally came Friday, so I have VB .NET, but this was done in … |
| | AoA I am Inserting Data From DataGridview to Sql2005.It Insert Perfectely. The Problem is that when i insert record it alway insert 0 row with my other rows The Code is below try { string con = "Data Source = FLOWER-PC;Database = MYFIRSTDATABASE;Integrated Security = True"; SqlConnection cn = new … |
| | Imports System.IO Imports System.Net.Sockets Imports System.Text Imports System.Net.Security Public Class Form1 Dim PopHost As String = "my mail server" Dim UserName As String = "my user name" Dim Password As String = "my password" Dim PortNm As Integer = "110" Dim POP3 As New TcpClient Dim Read_Stream As StreamReader Dim … |
 | hay pros i have a problam..i need to create a line report based on a stored proc everythings working fine..but in original result set i have a 44 records ..in my line chart i have all the bars but not labels.. my quary returns ArtistName and number of albums ex.. … |
| | iam coding a program to store textbox data into an array, iam using bounds inorder not to erase the previous data. and it is saying it needs an end of statement. Please help. Thanks. This is the code: ReDim Preserve strArrMonth (LBound (strArrMonth)) to UBound(strArrMonth)+1) strArrMonth (UBound(strArrMonth)) = textBox.Text  |
| | 'Inline Code Example HereHello i'm having this error message when adding to multiple table: '"The DataAdapter.SelectCommand property needs to be initialized." 'I need to have my data saved into both table(tblStudentInfo, tblPayment) when btnFinish clicked. Please 'help, i'm working on this for days and haven't had any luck. 'For reference … |
| | I have a RTF textbox that contains multiline text. I would like to extract the text only from this box to put in an e-mail. I know that RTFBox.Text will return the plain text but it seems that it strips out the CRLF's as well and I need to keep … |
| | I was doing xaml with vb coding in vb 2010 I create a datagrid and linked itemssource with table adapter, and also I modify a columns to checkbox datagrid columns. Problem now is I checked the checkbox value in the columns in datagrid but through button check the data grid … |
| | i want to initialize my id column of my databse tables by 1 again when i empty the table..i tried this code but it is not working.. Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick 02 Dim i As Integer 03 04 i = DataGridView1.CurrentRow.Index 05 … |
 | I am trying to insert new records into an Access DB and getting some weird stuff. I get the data from a DBF table and load that into a dataset table and DataGridView with no problems. Then I loop through the ds.table and insert it into the DB with this … |
| | I am developing a software that creates controls during runtime. I have used panels to place those controls. I use LABEL and a CHECKBOX to be created in runtime as sepecified by the user. They align one over the other as the checkbox over the label. [This is to allow … |
| | Hey guys im having this error on my codes but seems to work on the other new projects it always highlight the .ExecuteNonQuery `{"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at … |
| | Hi, i have a problem making my program share infos with his clone... Let me explain :) I execute my program twice, and i want it to share text like a messenger (on a single computer) and the problem is, i don't want it to be one program with 2 … |
| | Passing parameters into a Crystal Report. If a Crystal Report has a list of Discrete Values how do you know? If the report has just a list of parameters how do you know? What field tells what kind of parameters? |
| | Hi Using VB.NET I created an excel sheet with list of items in dropdownlist. Using the below code With xlWorksheet.Range("A2", "A101").Validation .Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:=[COLOR="Red"]"Construct,Testing,Review,Look Ahead Meetings,Process Audit,Process Improvement,Project Monitoring and control,Project Planning,Project Setup,Project Team Management,RCA Activities,Re-Estimation,Review,Review-Rework,Senior Management Reviews, Testing,Testing Rework,Training, Work Product Audit"[/COLOR]) End With But i can able … |
 | I have been searching and having no luck...So anyway, what I need is a way to copy tab1's controls or items (like textboxes,datagridview etc) and then have them pasted into a new tab. This would be done through a "New Tab" button. When that button is pressed, a new tab …  |
| | I am trying to change the color of individual cells in a datagridview based on values from the columns. If the CDRGvalue is not blank and the ALOSvalue is greater than the PLOSvalue then I need to change the individual cell back color for the ALOS column (colALOS) and the … |
| | I am making a program for school where the user has to choose a chapter to learn. when the user has choosen one i want to use a text file where all the words are in: for example In the program you choose chapter 5 then the program has to … |
| | hi i want to write a program having three text box in each text box i wanna right a number and when i click a button i want to show in a message box the the smallest number first followed by the larger number and last the largest using the … |
| | I am Working on a project in VB.net and created an application for sending bulk sms to mobile phones through internet.I created a code and tried to send sms.But it dosen't work properly.When i tried it for a single sms, it is getting so much delay to receive the message.Is … |
The End.