Search:

I'm creating a database application using VB.NET (2010), (OLEDB Connection, Access 2010 database). I've finished everything but reports. And I've got only two days, so don't have enough time to...

This is the first time I've ever built an user control. Following is the Control Prototype. (96605 has Resource and Designer as well)



Public Class DatePicker
Private BeingSet As Boolean...

Brackets!! That was not necessary.

Thanks anyways!!

I execute this SQL query with a single INNER JOIN


SELECT t1.bDay, t1.BillNo, t1.Remarks, t2.Quantity, t2.Quantity2 FROM tbl_Expenditure AS t1 INNER JOIN tbl_ExpDetails AS t2 ON (t1.Type = 4 AND...

Satisfied!

But I would still love to have ListBox class inherited. Thanks guys!!

This didn't need to be this tough - why wouldn't they allow to set us the heights to what we want. Why did they even have Height/ItemHeight as properties if those cannot be changed?? :\

I'm...

Hello.

I want to be able to change Height property for controls. Like Height for TextBox and ItemHeight for ListBox. But the controls won't let me change it. They set it back to their default...

Oh!! Right.. I had accidently UNCHECKED "ENABLE APPLICATION FRAMEWORK". Thanks

I've no idea. I don't think I changed any of the Project Properties, but suddenly controls on the form started appearing to have classic looks (like in Windows XP and earlier) while debugging. It...

I was doing other part of the project (I got limited time for its completion.) as I was awaiting reply.

Anyway, I shall try take it over from here. And get back to you, if I got stuck.
...

Cloning a control a modifying LOCATION property is better than writing 10 lines to assign the property.

But I agree with you.

And how can we You could inherit the desired control and add your...

I was wondering if we could clone all the properties of a control to another control (of same type).

For me, I want to clone the properties of the existing textbox to the dynamically created...

Serves my purpose, perfectly. Thanks!

I expected to find the TAG property for each item in the ComboBox. Since, there is not, I now expect it can herited to add the property.

I'm aware of it. I'm gonna do validation checks for that.

And I don't need to worry about the injection since the client is a noob. And why would he inject his own database? The system will be...

Okay!! That was the problem!!

Didn't think Access would reserve 'Day'.

Thanks anyway.

This object prototype lets you convert Nepali Date (i.e. BS) to English Date (i.e. AD) and vice versa and perform Unix Timestamp conversions

Limitation: Only works between the range 1994 AD - 2033...

Yeah. Day is the valid name.

DataBase is a class with connection strings and methods. That is not the part to worry. Woks perfect in other parts of my project.

huh??



Yeah, I MessageBoxed the queryString and it looks SYNTATICALLY fine.

Dim DC As New DateConverter(Now.Date)

Dim day As Double = DC.GetUnixTimestamp(DC.ToAD(StrToDate(txtDate.Text))),
BillNo As Double = Val(txtBillNo.Text),
...

Okay. I update my code to this. And now it says Syntax error (missing operator) in '?Name'.



Dim con As OleDbConnection = New...

Its been almost two hours I've trying to solve this issue. I googled and tried many different sites and tired solutions they suggested but none helped.

Actually, I'm trying to insert a null value...

Well, what you said is true. I could just add the row into the datagridview with the existing records that just got inserted into the database. But sometimes it is better to do as I said. For i.e....

Thanks. I'll do your way the next time. Right now, I'm in hurry to finish this. And I got another problem. After the row is inserted , I need to show the changes by retrieving rows again from the...

Well, the problem I figured out here was APOSTRHPHES in GENDER field which is a boolean field.

Well, the problem I figured out here was APOSTRHPHES in GENDER field which is a boolean field.

And I guess, I don't have to worry about code injection much since I'm making the application for the client. And I'm not saving the access code in the database. :)

I'm confused. You said it SQL. (I was not sure about the .ExecuteNonQuery I used which VS says 'executing a SQL statement.).

Hello everyone.

I googled a lot about this but results didn't help.

However, I was able to read records from the database witht the following codes that google gave me.



Dim con...

Okay. That underscore was problem. And yes Jet didn't recognize the database format too. I switched it to ACE and now works fine. Thanks. :)

Well, thats ridiculous.

Yeah. I checked placing a MESSAGEBOX.SHOW. Message box would show up but those codes didn't work.

Hello guys!

This is the first time ever I'm connecting to a MS Access Database. I'm using Microsoft Jet OLEDB 4.0 engine.

This is my connection string.


con = New...

Well, that works. But why isn't that code woking in _CellMouseDown??

In DataGridView, I want entire row (entire cells) to be selected when one cell is selected.

I'm using this piece of code to acheive this.


Dim i As Integer
For i = 0 To...

Okay. That wasn't hard actually.


DataGridView.Rows(index).Cells(index).value

Thanks.

I'm using DataGridView without binding it to any source. I want to add all data manually.

I got the way to add a new row.

empDataGridView.Rows.Add() 'empDataGridView is the name of...

Okay. I set the COMPILE TARGET to AnyCPU and it works fine now.

The thread is resolved. Thank you all

Yeah. This code reads the value though the key doesn't appear to be created in the registry editor. I tried reading value but it returned empty. Is it because I ommited .ToString??

And yes, I have...

It doesn't work for me.. What might I have forgotten?? What could prevent from writing registry??