Re: Drop down control. - C# Discussion Boards

musefan18-Nov-09 22:59

musefan

18-Nov-09 22:59

How are you going to identify if an entry already exists? i.e. what is unique about the rows?

Life goes very fast. Tomorrow, today is already yesterday.

Priya Prk18-Nov-09 23:01

Priya Prk

18-Nov-09 23:01

my db table has the same columns as in the excel sheet

dan!sh 18-Nov-09 23:10

18-Nov-09 23:10

Is there any primary key in your table?

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...!!

Priya Prk18-Nov-09 23:14

Priya Prk

18-Nov-09 23:14

yes i have two columns:
id and name.
id is the pk

dan!sh 18-Nov-09 23:26

Re: Updating databse table on basis of Excel sheet [modified]

18-Nov-09 23:26

Use that key to check if record exists in database and update if they do. If not, insert them. You can send the entire datatable to the stored procedure by converting that into an XML.

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...!!

musefan18-Nov-09 23:24

musefan

18-Nov-09 23:24

If you have an ID value in the excel spreadsheet this will be useful to check for existing entries. I assume this field will be empty for new entries? (I say that as you may have trouble adding, if its an auto incremet column)

I would...

1. Search all rows in existing database, pulling only the ID field data.
2. Create a list of ID values
3. Loop all rows in datatable (from excel)
4. Check if datatable row ID is in list of ID values, if so then do an UPDATE query, if not do an INSERT query

...that's it

Life goes very fast. Tomorrow, today is already yesterday.

modified on Thursday, November 19, 2009 6:07 AM

Drop down control.

Sasmi_Office18-Nov-09 20:18

Sasmi_Office

18-Nov-09 20:18

Hi Friend,

This is normal but want to know how it's done.

I have multiple drop down on one form which are related to each other.
Country Drop down
City Drop down
Location Drop down

If user select Country it will fill drop down and so on, but when user again select new country system should clear the related drop down it's working fine but because of that its taking time which is issue need to know how to speed this.

thanks in advance.

Sasmi

dan!sh 18-Nov-09 20:21

18-Nov-09 20:21

Are you hitting database everytime country selection is changed? That will slow things down. Unless you show some code about how you are doing this, it would be tough to help.

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:22

0x3c0

18-Nov-09 20:22

Just beat me to it Big Grin | :-D

OSDev

dan!sh 18-Nov-09 20:28

18-Nov-09 20:28

This has happenned with me a few times earlier as well. Fortunately, I was lucky enough to come out as a winner every single time. Smile | :)

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...!!

Sasmi_Office18-Nov-09 20:38

Sasmi_Office

18-Nov-09 20:38

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..

sasmi

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

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

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

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

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 ?