jireh

To display a DataGridView column as Read Only I use: [CODE]DataGridView.Columns[0].ReadOnly = true;[/CODE] Is it possible to display a column as boolean checkbox type. The data is yes/no but I want them displayed as a checkbox. Something like: [CODE]DataGridView.Columns[2].CellType = Boolean;[/CODE] but that doesnt work..'bool' is a 'type' but is …

This is a very simple login form. I set it up so that the form won't close until it's cancelled or a valid username and password are entered. I chained the check for the username and the check for the password, so that if the username doesn't pass the password …

I start programming in Vb6 a few weeks ago, and I have a big problem now… When I like to insert Date in .dbf table from my VB6 Application, I get the error: [COLOR="Red"][B]Malformed GUID. In query expression[/B][/COLOR] My SQL string: [COLOR="Green"]strSQL = "[B]INSERT INTO stok_sme (Date_time) VALUES ({^" & …

Hello, I am a new to vb.net and daniweb I am working with an application (A Small game) in which on special days, there is a sale in the game market, which is with game money. For it, I Have a boolean data type in the settings (My.mysettings) named special. …

Hi, I wanted to update a table in access db using right outer join.I created a temp table,copy the structure from the destination table and used it to store values from an excel file.And using right join tried to update the destination table making the temp table as a source.It …

Im just curious what is wrong in my code, when i click the void button an error is shown, but it runs smoothly when the void button is not click. Here is my code, thanks for your help guys! Public Class Pizza Private Sub rdPrimo_CheckedChanged(sender As Object, e As EventArgs) …

I want a set of not the same numbers to be added to a listbox, if there are any numbers that are the same, then they won't be added. I tried: If (Number1 = Number2) Or (Number1 = Number3) Or (Number1 = Number4) Or (Number1 = Number5) = False Then …

This is my code Dim dblPrice As Double = 0 Dim dblTotal As Double = 0 Dim strTotal As String dblPrice = CDbl(txtPrice.Text) intQuantity = CInt(txtQuantity.Text) dblTotal = (dblPrice * intQuantity) strTotal = Format(dblTotal.ToString("N2")) If chkDessert.Checked = True Then strTotal += 5 End If If chkDrink.Checked = True Then strTotal …

I have a column named Emp_Id and set as primary key (not Auto Incr).I am trying to generate an ID (employee) and save it into a SQL database. The logic goes this way: Generate the id number with a prefix plus the number (i.e. EMP0001). Display it on a textbox …

Hi guys, I need assistense in comparing whether values of a listbox and datetime picker are not equal. thanks.

I'm new to this site so please excuse any errors in etiquette or format. I have Visual Basic 4.0 (Please don't laugh!). It works fine on my desktop but when I installed it onto my new laptop running Windows Vista I get an error message " 'olepro32.dll' could not be …

I am currently working on a project that involves saving a picture to a sql database. I have done quite a bit of research on this and have found a lot of useful stuff but nothing where I can actually develop some code from. Simply put, it is a datagridview …

I have a dataTable with records and I want to insert those records in another table in database, so I was writing adapter.insertcommand="Insert into SourceTable(select * from " & DataTable &")" but this code does't work. help me out...

greetings! When i First start my VB6 program with data report it works fine. The report displayed directly. but when i try to open other programs in other directory and then when i re-run my program in data report operation a msgbox appear "Please Enter MS Jet OLE DB Initialization …

im just a noob vb programmer and im now making a thesis project (library system) im just wondering if any1 know how to do that (see title) in visual basic coz im planning to put that in our text box for searching books or student info for easier searching. help …

hi guyzz i wanted to remove item in the lisview using the for each i want to delete multiple item with similar field in the listview. any help.. for this problem.. it could be possible ? i have here code but it delete only selected item in the listview. (ListView1.ListItems.Remove …

hi i need to connect a vb application to a mysql database which is in a remote server plz suggest solutions thank u very much

when user login it will check if user exist in database or not what is wrong with this code Dim a As New System.Data.DataView Dim b As New System.Web.UI.DataSourceSelectArguments Dim usname As String Dim password As String SqlDataSource1.SelectCommand = " select usname , password from userinfo " a = SqlDataSource1.Select(b) …

Hello, Cab I ask some help for my project? I'm using datagridview to add, edit and search items in ms access table. I already fixed the search button to work and it displays the selected row when I enter the ID value on textbox. My problem now is how will …

Hi friends! I have a piece of code that I think should be working just fine, but I wonder why it doesn't work, and I get an "Syntax Error in INSERT statement" error message. Here is the code to affect a table called "Users" in my Access database. Dim cmd …

If I want to transfer var1 in form1 to form2 to be used in an alogrithm how do I do this? I have tried importing the form and then using the variable - no success. I have tried something to this effect form1.var1 - Get the error that var1 is …

Hi, i need help when i press the save button on a form that i have created (i have no save dialog etc yet) then it saves that form with all the information in their corresponding boxes when i open it again. Example: I fill in the form then i …

I keep getting a NullReferenceException. Any help would be great! Private Sub fillpub(ByVal argPubID As Integer) Dim drpub As _books_Fall2012_A2DataSet.PublishersRow drpub = _books_Fall2012_A2DataSet.Publishers.FindByPubID(argPubID) If drpub.IsNameNull Then txtPublisher.Text = "" Else txtPublisher.Text = drpub.Name End If If drpub.IsAddressNull Then txtAddress.Text = "" Else txtAddress.Text = drpub.Address End If If drpub.IsCityNull Then …

I Want to make my program search and delete.. Iam Using MS ACCESS 2010 Public Class main Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click AddProd.Show() Me.Close() End Sub Private Sub TblInventoryBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Me.Validate() Me.TblInventoryBindingSource.EndEdit() Me.TableAdapterManager.UpdateAll(Me.InventoryDataSet) End Sub Private Sub …

[FONT=Comic Sans MS]Hi everyone, I'm shreya. I'm doing my bca (bachelor in computer applications)-4th sem. I'm required to do a mini project on dbms using msaccess and backend as vb. I'd be glad if you can suggest a project. I have 3 months to complete this project. I hope I'll …

please i need a code that can help me search records from a table in vb.

anyone who can help me regarding how to read data from .dbf files recordwise.

hey im trying to create a program where the user will type in a number then choose the units its in and units it will be converted to from 2 comboboxes. The output should be changing as different units are clicked without a button.Please tell me how to fix my …

Hey Guys! I'm about done with a personal application im making for my small furniture factory. I'm having a little problem retrieving the total sum of my employee's loans discounts.It comes up perfectly using the statement: "SELECT sum(TotalDiscount)as TotalDiscount FROM EmployeeDiscounts WHERE EmployeeID=val(" + Me.txtEmployeeID.Text + ")and PayRollID=val(" + Me.TxtPayrollID.Text …

how do i delete all the data which is stored in the sql table???? i want to delete only the data present in one table without dropping the table when i click on the command button in vb6 plz help :(:(:(:( its really urgent