Re: how to avoid a leave event after it is called - C# Discussion Boards

Shameel18-Nov-09 21:27

Shameel

18-Nov-09 21:27

It seems you are hitting the database everytime a country or city is changed, that's why it is so slow. Load your lists in a JavaScript array and rewrite your logic using JavaScript.

dan!sh 18-Nov-09 23:09

dan!sh

18-Nov-09 23:09

You seem to hitting database all the time. Get the list in one go and cache it. Then, all you need is to filter the datasource for second and third dropdowns.

BTW give your controls a descriptive name.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Nguyen Thanh Quyen18-Nov-09 22:39

Nguyen Thanh Quyen

18-Nov-09 22:39

Check valid field when pass to Controls

Công ty Đất Quảng - Cong ty Dat Quang - http://datquangda.com.vn
Bất động sản, mua bán nhà đất khu đô thị mới Nam An Khánh Hà Nội.
Trụ sở: Phòng 303 nhà N6E – Trung Hoà Nhân Chính – Thanh Xuân – Hà Nội - Vietnam
Văn phòng giao dịch: Số nhà 10, ngách 23, ngõ 61, Trần Duy Hưng, Trung Hòa, Cầu Giấy, Hà Nội, Vietnam
Điện thoai: 04.3556 2516 - 3556 2552 - 2247 5733
Fax: 04.3556 2566 - 3556 2140
Email:datquangda@gmail.com
Website: http://www.datquangda.com.vn

dan!sh 18-Nov-09 22:45

dan!sh

18-Nov-09 22:45

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

0x3c018-Nov-09 20:21

0x3c0

18-Nov-09 20:21

Which code is populating the dropdown boxes? What part of the code is slow? If you're searching through a database, have you used the WHERE clause, or are you just iterating over the results when the list is populated?

OSDev

how to avoid a leave event after it is called

Sasmi_Office18-Nov-09 20:37

Sasmi_Office

18-Nov-09 20:37

thanks for your quick response

me using following query to fill dropdown
"select CountryName, CountryID from CountryTable"
"select CityName, CityID from CityDetails where CountryID = 1"
"select LocationName, LocationID from LocationDetails wherer CityID = 1"

this way the data has been retrive from database
but before that
i want to clearify
at page Load it initialize each control

DropDown1.Items.Clear()
ListItem _Item = new ListItem("-Select Country-",0)
DropDown1.Items.Insert(_Item, 0)

DropDown2.Items.Clear()
ListItem _Item = new ListItem("-Select City-",0)
DropDown2.Items.Insert(_Item, 0)

DropDown3.Items.Clear()
ListItem _Item = new ListItem("-Select Location-",0)
DropDown3.Items.Insert(_Item, 0)

when i change selection of Country drop down
again

DropDown2.Items.Clear()
ListItem _Item = new ListItem("-Select City-",0)
DropDown2.Items.Insert(_Item, 0)

DropDown3.Items.Clear()
ListItem _Item = new ListItem("-Select Location-",0)
DropDown3.Items.Insert(_Item, 0)

this way its coded..

hope you get what i coded on my form

sasmi

eyalle18-Nov-09 19:30

eyalle

18-Nov-09 19:30

hello,
im looking for a solution with a slight problem that im sure it is possible, but i cant find anything about it on the web.
In my code, im calling a leave event out of a control that check's if the control has made any changes (txtBox, combo Box...) raising a question telling the user that changes weren't saved.
if the user click's on Cancel button, i want him to stay in the control and not actually leave like he initially did.
How can i do it ?
Thanks

private void TabControlChars_Leave(object sender, EventArgs e)
        {
            DataTable charChanges = null;

            if (charsTypeDT != null)
            {
                charChanges = charsTypeDT.GetChanges();
            }
            else if (charsDT != null)
            {
                charChanges = charsDT.GetChanges();
            }

            if (charChanges != null)
            {
                DialogResult result;
                result = MessageBox.Show("Changes were made without saving !!\n"
                               + "All Changes will be lost ...", "Warning", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
                if (result == DialogResult.Cancel)
                {
                    ???
                }
            }
        }

dan!sh 18-Nov-09 19:48

dan!sh

18-Nov-09 19:48

Try setting focus back to the textbox.

You can also place the code in the Validating event and then use Cancel property of the CancelEventArgs there to remain in the textbox.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Shameel18-Nov-09 21:29

Shameel

18-Nov-09 21:29

Your logic should ideally be placed in Cancel button's Click event.

eyalle18-Nov-09 21:32

eyalle

18-Nov-09 21:32

Sorry, but i didnt get you..
the message Box is created inside the Leave event so how can i put the event in the cancel button click event ?

Shameel18-Nov-09 22:51

Shameel

18-Nov-09 22:51

I'm sorry, I got your question wrong.

In your case, instead of using the Leave event, use the Validating event and if the user chooses cancel, set e.Cancel = true (e is the ValidatingEventArgs passed to the method).

grid to database

Member 59031018-Nov-09 19:20

Member 590310

18-Nov-09 19:20

i have some data in grid which i want to write to database table on clicking a comand button...tell me esay way to do that?

Abhijit Jana18-Nov-09 19:27

Abhijit Jana

18-Nov-09 19:27

Member 590310 wrote:
i have some data in grid which i want to write to database table on clicking a comand button...tell me esay way to do that

What is the source of data that you are showing in gridview ? Read those data and put into the database. Or your problem is something else ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Member 59031018-Nov-09 19:33

Member 590310

18-Nov-09 19:33

reading data from table and showing it in grid...nw after making some changes in data i want to put that data back to table...

Amit Patel198518-Nov-09 20:08

Amit Patel1985

18-Nov-09 20:08

read the data from the grid

by using this code

gridname.row[index].cell[i].text

and make a query and insert into the table.

Thanks and regads,

Amit Patel