Visual Basic

Unbound Checkbox column in DataGridView

31-Oct-09 12:07

I want to filter datagridview using 2 textboxes which filters the DGV according to the values entered in them. For example:

Suppose i have following dgv and
There is nametextbox where i type in "V" and i get following results.

Name Mobile
----- ------

Vikki 9861054321
Vinni 9546743243
Valter 3211243 etc...

Now i type into mobiletextbox "9" and i get following results:

Name Mobile
----- ------

Vikki 9861054321
Vinni 9546743243

and when i type "5" i.e. it becomes "95" and then i get following results :

Name Mobile
----- ------

Vinni 9546743243

For which i pass the following code in the text change event of both textboxes:

ClientProfileBindingSource.Filter = String.Format("Name LIKE '{0}%' AND Mobile LIKE '{1}%'", NameTextBox.Text, MobileTextBox.Text)

But this aint giving me results.. any thoughts on this?

LuxCoder31-Oct-09 11:55

Re: Unbound Checkbox column in DataGridView

31-Oct-09 11:55

Hi,

I have added an unbound checkbox column to my DGV. I have two questions on handling it:

1. How to have a checkbox on this Column header, which on checking must check all the rows in the DGV and vice versa?

2. How do i know what rows are selected?

Please help.

Henry Minute31-Oct-09 12:17

31-Oct-09 12:17

Take a look at this[^], from a quick look it seems to solve both your questions. It is in C#, unfortunately, but the syntax is sufficiently close to VB that you might well be able to understand it.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Inserting values into DB

LuxCoder31-Oct-09 11:44

31-Oct-09 11:44

Hi
I am passing the following code to insert values in my DB table directly:

Private Sub SaveButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveButton.Click
        Using connection As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=D:\ProjectMW\MachineWale\MachineWale\DatabaseMW.mdf;Integrated Security=True;User Instance=True")
            Using command As New SqlClient.SqlCommand("INSERT INTO [MachineProfile] ([MachineID], [Category], [Type], [Brand], [Model], [Quantity], [SalePrice], [RentalRate], [ListingDate], [Agent], [Availability], [PurchaseDate], [Kmsrun], [HoursRun], [ChasisNo], [EngineNo], [OtherSpec], [WebEntry], [Ownership]) VALUES (@MachineID, @Category, @Type, @Brand, @Model, @Quantity, @SalePrice, @RentalRate, @ListingDate, @Agent, @Availability, @PurchaseDate, @Kmsrun, @HoursRun, @ChasisNo, @EngineNo, @OtherSpec, @WebEntry, @Ownership) where [MachineID] = '" & TextBox1.Text & "'", connection)

                command.Parameters.AddWithValue("@MachineID", TextBox1.Text)
                command.Parameters.AddWithValue("@Category", ComboBox2.Text)
                command.Parameters.AddWithValue("@kmsrun", TextBox10.Text)
                command.Parameters.AddWithValue("@Type", ComboBox3.Text)
                command.Parameters.AddWithValue("@Brand", ComboBox7.Text)
                command.Parameters.AddWithValue("@Model", ComboBox8.Text)
                command.Parameters.AddWithValue("@Quantity", TextBox7.Text)
                command.Parameters.AddWithValue("@SalePrice", TextBox17.Text)
                command.Parameters.AddWithValue("@RentalRate", TextBox18.Text)
                command.Parameters.AddWithValue("@ListingDate", TextBox19.Text)
                command.Parameters.AddWithValue("@Agent", ComboBox6.Text)
                command.Parameters.AddWithValue("@Availability", ComboBox4.Text)
                command.Parameters.AddWithValue("@PurchaseDate", DateTimePicker1.Value)
                command.Parameters.AddWithValue("@HoursRun", TextBox11.Text)
                command.Parameters.AddWithValue("@ChasisNo", TextBox12.Text)
                command.Parameters.AddWithValue("@EngineNo", TextBox13.Text)
                command.Parameters.AddWithValue("@OtherSpec", TextBox15.Text)
                command.Parameters.AddWithValue("@WebEntry", ComboBox5.Text)
                command.Parameters.AddWithValue("@Ownership", ComboBox1.Text)
                connection.Open()
                command.ExecuteNonQuery()
                MsgBox("Updated")

            End Using
        End Using
    End Sub

But i am getting this error after executing as:

Incorrect syntax near the keyword 'where'.

What could be possibly wrong?

LuxCoder

Henry Minute31-Oct-09 12:05

31-Oct-09 12:05

Try changing your command to:

            Using command As New SqlClient.SqlCommand("INSERT INTO [MachineProfile] ([MachineID], [Category], [Type], [Brand], [Model], [Quantity],
 [SalePrice], [RentalRate], [ListingDate], [Agent], [Availability], [PurchaseDate], [Kmsrun], [HoursRun], [ChasisNo], [EngineNo], [OtherSpec], [WebEntry], 
[Ownership]) VALUES (@MachineID, @Category, @Type, @Brand, @Model, @Quantity, @SalePrice, @RentalRate, @ListingDate, @Agent, @Availability, @PurchaseDate, 
@Kmsrun, @HoursRun, @ChasisNo, @EngineNo, @OtherSpec, @WebEntry, @Ownership) where [MachineID] = <big>@MachineID</big>", connection)

Luc Pattyn31-Oct-09 12:06

Luc Pattyn

31-Oct-09 12:06

AFAIK an INSERT statement does not take a WHERE clause. New records just get added to a table.
Ref.[^]

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

LuxCoder31-Oct-09 12:11

31-Oct-09 12:11

Well the intention is to edit an existing datarow populated on my form where the Primary key is the textbox.text....

Christian Graus31-Oct-09 12:08

Christian Graus

31-Oct-09 12:08

You should buy a book on SQL perhaps.

The update command appears to be what you want. You do realise that putting your sql in your presentation code makes for an unmaintainable mess, right ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

LuxCoder31-Oct-09 12:13

31-Oct-09 12:13

Can you give me an example of Update command?

LuxCoder31-Oct-09 12:45

create somthing like this see the example pl multi select

31-Oct-09 12:45

okay thanks i got it. Update command is working now Smile | :)

MapWindowGIS

hira0831-Oct-09 7:29

hira08

31-Oct-09 7:29

Hello.

I am currently developing an application that uses the component MapWinGIS, I managed to make a zoom on the map, move, etc. ...

My current problem is that I do not know how to handle the event click on the map control: click on an object (eg a town) to display information from the latter.

Thank you in advance for your prompt replies.

Re: MapWindowGIS

DaveAuld31-Oct-09 7:40

DaveAuld

31-Oct-09 7:40

Have a look here http://www.mapwindow.org/tutorials/[^] There is an ActiveX tutorial an also a sample project source code.

Cheers,

Dave
Who am I?:
Web|Facebook|Twitter|LinkedIn|Bebo

Re: MapWindowGIS

hira081-Nov-09 3:03

hira08

1-Nov-09 3:03

I looked but I could not find. Could you elaborate?

Re: MapWindowGIS

DaveAuld1-Nov-09 7:38

DaveAuld

1-Nov-09 7:38

Its under the section; "Getting Started Using MapWinGIS ActiveX Control"

Links

PDF Tutorial[^]

and

Sample Project[^]

Dave
Who am I?:
Web|Facebook|Twitter|LinkedIn|Bebo

neverpleat31-Oct-09 5:52

neverpleat

31-Oct-09 5:52

http://users.telenet.be/voorbeeld/vb.JPG[^]

how can i create somthing like this in visual studio 2008
i don't find nothing for doing this like the exampel and i don't want to use 100's off button's any help or direction

T'hanks

Re: create somthing like this see the example pl multi select

Henry Minute31-Oct-09 6:07

Re: create somthing like this see the example pl multi select

31-Oct-09 6:07

I am not going to follow a link from someone I do not know. This is no reflection on you, just a rule I have.

Therefore can you describe what you are trying to do?

neverpleat31-Oct-09 7:23

neverpleat

31-Oct-09 7:23

i try to explain

you have 14 Squares with 42 numbers in it
you can select 6 numbers at eatch Square
if you do this with buttons you have 588 this is big
is there a other way to do this
t'hanks

Re: create somthing like this see the example pl multi select

Henry Minute31-Oct-09 10:22