20,278 Topics
![]() | |
"DELETE FROM tbl_status where id "= & selecteditem Hi .. i have a problem here.. the query i have for delete button is wrong.. i raelly don't know what is wrong with this code.. someone help please.. this what i've gone so far.. | |
![]() | Public Function analyzeTotalFilesSize(Path) As Integer Dim lookInDirectory As New DirectoryInfo(Path) For Each Directory As DirectoryInfo In lookInDirectory.GetDirectories analyzeTotalFilesSize(Directory.FullName) Next For Each File As FileInfo In lookInDirectory.GetFiles If _ListOfFiles.Exists(Function(x) x.ToString = File.Extension.ToLower) Then _SizeOfFilesToCopy += File.Length / 1024 End If Next If _SizeOfFilesToCopy < 1024 Then errorhere -------->> Return _SizeOfFilesToCopy.ToString("#,##0.00") & … |
i can't find the error converting data type varchar to numeric pls help.. i already wasted a lot of hours to identify this error. conn = New SqlConnection("Server=GEN-PC;Data Source=GEN-PC\SQLEXPRESS;Initial Catalog=Brgy;Integrated Security=True;") If ResidentialComboBox.Text = "" Or LNameTextBox.Text = "" Or FNameTextBox.Text = "" Or MNameTextBox.Text = "" Or GenderComboBox.Text = … | |
Hello, Can someone please point me in the right direction for using the Digital Persona Fingerprint system, the u.are.u 4500 one. I have imported the following statements; Imports GrFingerXLib Imports Microsoft.VisualBasic But then I don't know where to go from there. All I want to do is scan the fingerprint, … | |
Hi everyone, I am quite new to vb.net. Recently, I've been learning about Oledb commands and it's ability to save records in a form to a database. So, I started a project and now I am stuck. Here's the scenario: The form comprises of several comboboxes, a listview box and … | |
using vb.net and sql query i need to join multiple tables to view in one datagridview control .In each table i need to take only one field and want to dislpay all in the datagridview control...can anyone provide me the apat code for this | |
here a piece of vb code where i have a problem: If G_ObjConnectionTemp.State = ConnectionState.Closed Then G_ObjConnectionTemp.Open() End If ' at this stage the connection is verified to be open Dim Obj_CommandF As New OleDbCommand("delete from ficheclient", G_ObjConnectionTemp) Using G_ObjConnectionTemp Obj_CommandF.ExecuteNonQuery() End Using Dim xx = G_ObjConnectionTemp.State.ToString ' at this … | |
Imports System.Data.Sql Imports System.Data.SqlClient Public Class Form1 Dim connetionString As String Dim connection As SqlConnection Dim adapter As New SqlDataAdapter Dim sql As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connetionString As String Dim cnn As SqlConnection connetionString = "Data Source=obeng\obeng;Initial Catalog=mangementsystem;integrated security=true" … | |
Hi All, I have just completed my project in VB 2008 express edition. Now I want the project to be converted to .EXE so that I can deploy it on other computer / laptop. Could any one please help.... Regards, Ashwin | |
Hi All, I have got one scenario here in which I need to bind a DataGrid to a collection (array, ObservableCollection etc.). My Collection name is "WarningList" and the code is as follows :- **ViewModel :-** WarningList = {({result.WarningMsgCode, result.WarningColor})} **xaml :-** <data:DataGrid x:Name="gridSystemWarnings" Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2" DataContext="{Binding}" IsReadOnly="True" … | |
I have 2 forms , form one has a datagrid with 10 columns form 2 has a listview box with 4 columns i want to populate the listview columns with 4 of the values from a row in the datagrid when the row is selected and the 'add ' button … | |
I am making a quiz for my Computer Science class where there are keywords and definitions and the user has to match the correct keyword to the definition twice and until then it keeps on going while tracking the time taken. Both the keywords and the definitions have to be … | |
Hey Guys hiee, I am new to VB.net. I am making an application which should run on mutiple pc. In that application there are two main accounts 1) Admin Account and 2) Other User Account. I want multiple "Other User Account" user to connect/access application simultaneously. And tell me one … | |
A parking garage charges a $2.00 minimum fee to park for up to three hours. The garage charges an additional $0.50 per hour for each hour or part thereof in excess of three hours. The maximum charge for any given 24-hour period is $10.00. Assume that no car parks for … | |
Define a method Hypotenuse that calculates the length of the hypotenuse of a right triangle when the other two sides are given. The method should take two arguments of type Double and return the hypotenuse as a Double. Incorporate this method into a Windows application that reads integer values for … | |
Hello everyone! I am posting this code for anyone who may be having issues with connecting to a database. Feel free to use this code as you wish. This will be using the OLEDB library. [CODE] 'Imports Imports System.Data.OleDb Public Class Form1 'Declarations Dim con As OleDbConnection Dim cmd As … | |
Hi guys about my previous post on [Copy Selected rows from Datagrid to another](http://www.daniweb.com/software-development/vbnet/threads/471088/copy-selected-rows-from-datagrid-to-another) that was answered by oussama_1 and Deep Modi, I was wodering if is it possible to detect that there is a similar row between the 2 Datarids to avoid redundancy? Does it require a datatable or … | |
Hi I am using vs2008 Professional. Some columns of my dataset are presented in a matrix correctly. However,there is another dataset column I need to add. How can I insert a new column which is not an aggregate column to the right Thanks | |
i'm trying to INSERT simple data to database access 2007 using vb.net 2008 but when i click the button insert it say's Syntax error in INSERT INTO statement | |
Hi everyone, need some help with outlook. i need to extract information from outlook messages from default folder(inbox) to subfolders(including subfolders of subfolders) but it seems that i'm having problem on calling the folder from the outlook's default pst file. below are the codes i've already tried. outlookfolder = outlookmapi.Folders(folder_name) … | |
How can i know File property? ex: artist name, album, year, Lenth in hh:mm:ss this can not be done with the : my.computer.filesyste.getfileinfo(open.filename)."anthing" ex: "name" | |
how to insert y and n in database through checkboxes in a grid using telerik | |
I am studying vb.net through the help received through this forum. While I was making a small programme Out of curiosity/error I created a module.later I thought it is not necesssary.So I wanted to remove it.I searched in the project Tab But I could not see the Delete command.So I … | |
hi this is zaid ahmed my query is if person is declared a global variable and second local variable with a funtion with same in parent class so does this work. does anyone there to help me | |
Hi evryone... Can anyone give me a simple code to make an SMS gateway in VB.net please? I would be apreciate it.. much thanks=) | |
Hello, how to get id of selected row or clicked cell row in datagrid in vb6.0? Thanks | |
This has seriously baffled me. I have two text files one with keywords and one with definitions. What I need to do is read the textfiles into an array (or two) and assign the keyword from one with the correct definition. Then on one form the randomize the the keywords … | |
Dear All Master, please help me for my first program that i want to create...i have problem for save from datagridview to access database...everytime i try to save , only first line have save...another not save...sory for my bad english language...thank's here my code.... Sub simpen() Dim i As Integer … | |
i have 2 textbox in form1 as Name & Age and one datagridview in another form2 with column as Name & Age. I want to transfer data form these textbox to datagridview column. Please tell me the code. | |
Hi all! I have a USB Modem (dongle) made by ZTE. I normally use it for connecting to the interent. It also came with a dashboard/software that I can use to send & receive SMS and even make a call. I want to make an application with VB.NET that will … |
The End.