20,284 Topics
 | |
| | Dear Experts I use following codes to retrieve data from table, but get error Conversion from type 'DBNull' to type 'String' is not valid. [CODE] str = "Select * from gpass where vou_no= " & Val(Me.txtGat.Text) & " And Date = '" & Me.txtDat.Text & "'" dt = GetTable(str) If …  |
| | Dears [CODE] Private Sub DataGridView1_CellLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellLeave If e.ColumnIndex = 0 And e.RowIndex = 0 Then MsgBox("this is first coulmn") End IfEnd Sub [/CODE] IF cursor leaves column 0 and row 0 then it displays msgbox but I want to check where column … |
 | Hello, I would like to list items from a database into a list but like to make it look clean. For example if database contains Column1, Column2 John,Smith Joe, Bloggs I want to list them like this John Smith Joe Bloggs Not like this (currently) John Smith Joe Bloggs Any … |
| | Hi i tried the same.. but its not displaying any data from database [CODE] Public Class Editdetails Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim cn As New System.Data.OleDb.OleDbConnection Dim cm As New System.Data.OleDb.OleDbCommand Dim form As New Fielddetails Dim rd As System.Data.OleDb.OleDbDataReader Dim tbl_name … |
| | Hello again. i have encountered another problem. it is very hard to find out how to make a hotkey from several keys, like a+b+c. i would like the code for that. and i also need the code for a "randomizer" that always changes. so a have this label i need … |
| | Hello Sqlserver MyTable has following data Vou---------date---------qty 1-------25/12/2009------5 2-------25/12/2009------4 1-------26/12/2009------8 2-------26/12/2009------3 3-------26/12/2009------2 [CODE] str = "SELECT date, SUM(Qty) AS Qty, FROM mytable GROUP BY Date" dt = GetTable(str) [/CODE] These codes display following result date--------------qty 25/12/2009------9 26/12/2009------13 Now I want to add sno column in result as Sno--------date---------qty 1------25/12/2009------9 2------26/12/2009------13 … |
| | Hi All's, I trying to develop new virtual keyboard for my on screen application using vb 2005. I can send a letter to cursor but just form one time only....how to send key to activewindows application at current cursor?...can anyone help me plz... This is my coding:[CODE] SetActiveWindow(8975651603260375040) If CheckBox1.Checked … |
| | i'm making program to send picture through socket programming. now my program only can send to 1 destination using destination's IP address. i'm trying to develop the program, so my program can sending picture to many destination. with code below, i still cant send to many destination. only the 1st …  |
| | Hi there. Please i have a little problem with a report i want to generate in a program i've written. The program is to be used to check the attendance of students and at the end of a month of checking the attendance, print a report of how many times … |
| | Hello good Teachers I have a datagridview with 3 columns. the second column is a read only . When I leave column 1 I would like to go directly to column 3. For this, I got following codes from somewhere but I need these codes in vb.net format, please help … |
| | Hello Everyone Sqlserver Table1 has following data Sno---------date---------qty 1-------25/12/2009------5 2-------25/12/2009------4 1-------26/12/2009------8 2-------26/12/2009------3 3-------26/12/2009------2 I want to get following result Sno---------date---------qty 2-------25/12/2009------9 3-------26/12/2009------13 That is grouping on date. Column1 =count date Column2 =date Column3=sum of qty What command should I write to get above result Please help |
| | could anyone please help me with this1. Create a simple Times Table program which will allow the user to enter an integer value n (between 1 and 20) into a textbox. On the click of a button output to a label the n times tables. Use a For…Next loop to … |
| | can any body provide small vb.net project with documentation and coading that can represent in my resume |
| | Hello, I can pull 3 tables data into my program and read from all of them, i can update all 3 datasets but when it comes to updating the actual database i can only send the updates from the last dataset. [CODE] Imports System.Data Dim con As New OleDb.OleDbConnection Dim … |
| | Hello i have a problem, i need the code for tracking the mouse movement in VB 2008. my program needs to make a pop-up window when the mouse have moven an inch ( ex.) some code suggestions is needed, thank you - Martin |
| | Hello. i need a code for, lets take an eksample when the curser has moved 32 px, then a pop-up box needs to pop up and say " you have moved 32 pixels!" it also need to work out side of the form. - Martin |
| | Hello, I am using the Visual Studio Web Developer 2008 for programming in VB.NET and i have some problems: 1. Sometimes it stops highlighting the text. 2. Is there an option to refresh the Intellisense of the page? 3. When i am including files to my page, its say variable … |
| | hi everyone! Got some problem here. I really need help. I'm trying to have a shortcut key for my button, w/c has a random text. So, using the access key "&" wont work for me. Here's the original code: [CODE]Button1.Text = Mid(ChoosenWord, PickedSeq(0), 1) Button2.Text = Mid(ChoosenWord, PickedSeq(1), 1) Button3.Text … |
| | Hello all, I am creating a project for myself to practice Database connectivity, updating, deleting and adding items. I am having an issue updating one of the tables i have added, within a table there is a column called Today's Date which will contain the date the last time the … |
 | what i did was i use a select statement in opening multiple IE just for testing but the main function is what you put number on a textbox then the number the IE's will open for example i put 100 on textbox then when i click a button then 100 … |
| | Dear Experts DataGridView has 3 columns as Sno----name----marks While entering data, if sno column is empty and user press Enter or Tab then Focus must go to me.textbox1 Please help |
| | Hi All, How to calculate pixel intensity in Candela using RGB values? Thanks, Shrini |
| | I made a query for inserting a value from text box to MS ACCESS db [CODE] sql = "INSERT INTO Equipment (port_number,display_name,equipment,tonnage,user_privilage) VALUES (" & CLng(txtPort.Text) & ", '" & CStr(txtDisplay.Text) & "', '" & CStr(txtCA.Text) & "', " & CLng(txtTonnage.Text) & ", '" & CStr(cmbUser.Text) & "')"[/CODE] Actually I … |
| | Dear Developers How to enable "Autio Hide" command for Solution Explorer Window Please Help |
| | i created a smartdevice project,,(target platform =pocket pc;device=emulator; editor= vs2008). Without writing any code additional to template generated by vs2008 ; hit F11 (step into) ; Then vstudio asks to locate a source file named 17d14f5c-a337-4978-8281-53493378c1071.vb. i dont know what this file is; same problem does not occur if i … |
| | I currently am working on a project for work that deals with WSDL. The client has sent me the WSDL in XML form, so I was wondering can I even use this with VB .NET 2003 or do I have to use the "Add Web Reference" feature and add the … |
| | I need help urgently for 3-tier coding in retrieving data from database and display it in label. It would be a great help if anyone solve it for me. thanks [B]I got the code for data access layer but im not sure if it's right:[/B] [code] Public Function getFeedbackQ(ByVal Question1 … |
| | Dear Experts I am using following codes to format datagridview column headers, that works fine. My questions are 1) how to make all headings bold? (bold header row) 2) how to apply specific font to heading row 3) how to apply specific fontsize to heading row 4) how to apply … |
| | I have an assignment that asks me to create an application that lets the user enter a word or phrase, then displays the number of vowels found in that word or phrase. Here's what I have so far: [CODE]Dim mystring As String = Me.txtenter.Text Dim chars As Char() = mystring.ToCharArray() …  |
| | I have always used the API for Vb.net from Decaptcher.com and have always sent the Captcha by sending an actual url to them as you see in the code below. Or maybe it uploaded the image anyway to them (I use the Webbrowser Control) I'll use for example this: Code: … |
The End.