20,285 Topics
 | |
| | I'm trying to load sum of columns to text boxes. but it give me this error: "Object cannot be cast from DBNULL to other types" this is code : query = "SELECT sum(fuel) as ttlfuel, sum(stationery) as ttlstationery, sum(salary) as ttlsalary, sum(vehicle_part) as ttlvp, sum(other) as ttlother FROM mcs.expenses WHERE … |
| | I got dannie web help and make best effort to get good idea. Finally I make this code. but This code okay for search data and load it to text boxes. but again I change some values and click update button It say "connection alredy open." this is search code …  |
| | Hi, I am trying to develop a software which can get information like listed bellow In System : -SERIAL NUMBER(847MY5N15) -UUID(4C4C4554-0134-3710-804D-B8C04F594E31) -BIOS VENDOR(Dell Inc.) -BIOS VERSION(A09) In Motherboard(Optional, but will be good if : -MOTHERBOARD VENDOR(Dell Inc.) -MOTHERBOARD MODEL(02XJP9) -MOTHERBOARD VERSION (A03) -MOTHERBOARD SERIAL NUMBER (/847MYN1/CN1296112402BB/) In CPU: -CPU MODEL(Intel(R) …  |
 | I'm having the below code which works fine. The code is for typing some text on a website text field. In my case my site only have 2 components( it one TextBox, and one Button) the app simply loads this site and then auto type in the textbox field then …  |
| | I'm coding button which name 'Load'. I coded it like this, Try Using cmd = New MySqlCommand(Query, con) Query = "SELECT first_name FROM custormer WHERE custormer_id='" & txtcustormeridforloanform.Text & "'" dr = cmd.ExecuteReader() While dr.Read() Me.txtcustormername.Text = Convert.ToString(dr("first_name")) cmd.ExecuteNonQuery() End While End Using Catch ex As Exception MessageBox.Show(ex.Message) End Try … |
| | Hi I am trying to export the contents of a datagridview to a text file but I only want to see the data that is visible. I have hidden certain non important columns which I do not want to export. Please could someone help me modify the code accordingly. Private … |
| | This is my search button code. but it give error. I enter custormer id and click search button it give this error "The text command text has not been properly intialized" and again I click on search button. that time it show correct data row. but again I entered new … |
| | Authentication to host for user using method mysql_native_password failed with message: Access denied for user @localhost (using password:NO) dear guys howto solve this? |
| | I'm new to vb.net :rolleyes: I have form and it contain two date time pickers(dtpfrom & dtpto) and lable (lbltotal) and button (btnview) I want to pick data between two dates from mysql table. mysql table name is 'daily_income' can anyone help me ? |
| | hi igot some erro with this code vb.net 2008 cmd.ExecuteNonQuery() error Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cmd As New OleDb.OleDbCommand If Not cn.State = ConnectionState.Open Then 'open connection if it is not yet open cn.Open() End If cmd.Connection = cn 'check whether …  |
| | this is my code for loading the data in my database going to my datagrid Private Sub Records_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connString As String = "Provider=Microsoft.Ace.Oledb.12.0; Data Source=" & My.Application.Info.DirectoryPath.ToString() & "\BackUp\Database3.Accdb;" Dim MyConn As OleDbConnection Dim da As OleDbDataAdapter Dim ds As …  |
| | Is it possible that when writing this: Dim ds As New DataSet Dim dt As New DataTable ds.Tables.Add(dt) Dim da As New OleDbDataAdapter da = New OleDbDataAdapter("SELECT * FROM [Football Questions]", con) da.Fill(dt) lblQuestion.Text = dt.Rows(0).Item(1) lblAnswer1.Text = dt.Rows(0).Item(2) lblAnswer2.Text = dt.Rows(0).Item(3) lblAnswer3.Text = dt.Rows(0).Item(4) lblAnswer4.Text = dt.Rows(0).Item(5) lblCorrectAnswer.Tag = … |
| | Hi Dw I have created a program to lock files and by default when a file is locked the file changes from being a folder to a lock. So what I want to do is to change the lock to my own image, just like how VLC do, it changes … |
| | I am creating a multiple choice quiz but I am not sure how to check if the answer selected is the correct one. I have If radAnswer1.Checked = True Then End If But do not know what to put after the "then". I am trying to compare the value in … |
| | I want to create Input method Editor (IME) of my Balochi Keyboard and when I run setup file of this Balochi keyboard and install, after that when i open Language and region from control panel and add Balochi keyboard then this Language Keyboard come in Language Bar of my or … |
| | I have a query result . need to pass the Query parmeter(Where----?) to text box based on this need to display the value in data grid If any one know provide the vb.net code |
| | Step-by-step 1) I’ll continue from the previous post. You can download a project file from the previous post at here – SampleMySQL (zip format). The project was created on Microsoft Visual Studio 2005. 2) Open the Design view of Form1. 3)Drag DataGridView tool from the Toolbox window to empty area … |
| | Hi, I'm writing code to connect to Oracle through ODP so I added a reference to the Oracle.DataAccess dll on my machine. Trouble is I'm writing a 64 bit app and I appear to have both x86 and 64 bit versions of this dll on my machine. No matter which … |
| | i did creat vb.net code for .aspx files, now i am looking for sql database connection for my project. exapmle: databasename: demo1 table_name: State user id: sa Password: 123 default.aspx - <fieldset> <legend>Table :</legend> <div class="Row"> <div class="textleft">Country Name :</div> <div class="textmid1"> <asp:TextBox ID="TextBox1" runat="server" BorderStyle="Solid" BorderWidth="1" BorderColor="#009933" Height="18px" Width="250px"></asp:TextBox> …  |
| | Dim arr1 As String If Left(arr1(i), Len(n) + 2) = n& ": " Then titleBar = String$(100, Convert.ToChar(0)) valid1 = Right(arr1(1), Len(arr1(1)) - 13) how to convert vb6 to vb.net ? Left String$ Right Private Declare Function ObjectFromLresult Lib "oleacc" (ByVal lResult As Long, ByVal riid As Guid, ByVal wParam … |
| | Hello Everyone!! just a newbie here looking for some advice. ready to accept any suggestion that I get. I wish to make a GUI for a specific feature of a lenel panel 2220. I'd like to have a list of the activity on badge reader. I have the Lenel set …  |
| | i have a datagridview with some columns and i want to check if column number (e.g "6") value is null remove the row even if the other columns on the same row has value for example : col1 | col2 | col3 mn | nder| john sa | | sayed …  |
| | i made a form with datagridview which get its values from excel file and make some changes on its columns to prepare it to be saved in sql database so i need your help to compare one datagridview column with listbox items and get the result in another column for … |
| | I am making a multiple choice quiz in vb with the questions and answers stored in an access database. When trying to display the question and answers on my labels, they don't change. Here is my code: Imports System.Data.OleDb Public Class Football_Questions Dim con As New OleDbConnection Private Sub Football_Questions_Load(sender … |
| | Hi I m currently working on windows application that is loading electoral roll pdf file. What I m trying to do is to get the data as per Sr. No., Epic No., Name, Father's / Husbands Name, Age, Sex, House No. and pincode. Data is available in 3 columns and … |
| | I have a new command in my connection 1 of my dataenvironment, but, when i drag the "Command1" to my form, i cant see the labels and textboxes , why? Please help me, its my homework  |
 | Just a quick question here for VB.NET developing with Visual Studio. I have an existing project (Project A) and I want to use portions of it as a foundation for another related project (Project B). How can I safely copy Project A to another location, rip out unnecessary forms, code, … |
| | A sub procedure in Visual Basic that sets the vertical and horizontal sizes of a form named DemoForm to half the vertical size of the screen and to three-quarters the horizontal size of the screen respectively. ******************************* A program that can be used to generate and display the following multiplication … |
| | I do see AutoClose as a property for primary ContextMenu items, but I observe the secondary menu items do not stay open. Does anyone have a solution for this? I did opt with Secondary menu item click handler to set AutoClose to False, and create a single handler to process … |
| | I am working on a program and I almost have it working the way I want except for two problems. The first is major; I can not for the life of me get my answer for the population to equal anything but zero. I have a feeling this is due … |
The End.