Re: Drop down control. - C# Discussion Boards

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 ?

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