c# listview

Question

how d'u write the code to send the values from a listview control to a datatable

rmtielman · Answer

yep that's wat am trying to do =(

oblivion_lurks · Answer

Oh ok sorry i misunderstood you. Yeah i don't think the ComboBox class offers autocomplete. You might have to just implement the code yourself. Are you wanting to basically do the same thing that Intellisense does for you in visual studio?

rmtielman · Answer

Thks 4 the quick rep =) I tried this it compiles ok but the combobox does not provide autocomplete when i start typing.(the combobox items get loaded from my db) Pls help. private void cboClient_KeyUp(object sender System.Windows.Forms.KeyEventArgs e) { int index; string actual; string found; // Do nothing for certain keys such as navigation keys. if ((e.KeyCode == Keys.Back) || (e.KeyCode == Keys.Left) || (e.KeyCode == Keys.Right) || (e.KeyCode == Keys.Up) || (e.KeyCode == Keys.Down) || (e.KeyCode == Keys.Delete) || (e.KeyCode == Keys.PageUp) || (e.KeyCode == Keys.PageDown) || (e.KeyCode == Keys.Home) || (e.KeyCode == Keys.End)) { return; } // Store the actual text that has been typed. actual = this.cboClient.Text; // Find the first match for the typed value. index = this.cboClient.FindString(actual); // Get the text of the first match. if (index > -1) { found = this.cboClient.Items[index].ToString(); // Select this item from the list. this.cboClient.SelectedIndex = index; // Select the portion of the text that was automatically // added so that additional typing replaces it. this.cboClient.SelectionStart = actual.Length; this.cboClient.SelectionLength = found.Length; } }

oblivion_lurks · Answer

Oh ok i see what you mean. All you would need to to is implement the KeyPress event of the ComboBox!! With-in this method provide a switch case for the letter pressed (make sure its a letter ex: char.IsLetter()) in order to jump to the first string starting with that letter. Hope this helps!!

rmtielman · Answer

Say when u type a character the rest is suggested by comparing with those already in the combo :-S

oblivion_lurks · Answer

Whats up? Hey what do you mean by making the combobox autocomplete?

rmtielman · Answer

Hello how is it possible to autocomplete a combobox in a c# win app.

rmtielman · Answer

Thks for th reply I managed to work it out I was adding my data table column inside the loop =)

oblivion_lurks · Answer

Sorry it took me soo long to respond Rt!! Ok well i looked over your above code a couple of times. I just tried a short practice program with my code implemented similiar to yours. You said that the SubItem isn't returning just the one subitem? Everything just worked fine for me. Heres my code: this.listView.Items[0].SubItems.Add(strSubItem); string str = this.listView.Items[0].SubItems[1].ToString(); MessageBox.Show(str); Output: strSubItem Is this similiar to what your wanting?

rmtielman · Answer

hello x-box gamer. I tried the following: The part which has to make the stat column load in the datatable is not working. Actually Status is a subitem in my listview control(lv1). for(int j=0; j<Info.lv1.Items.Count;j++) { string PartN = lv1.Items[j].Text.ToString(); string stat = lv1.Items[j].SubItems[1].Text.ToString(); //I think maybe this line does not get the subitem but the whole line the the listview. But 'lv1.stbitems' is not valid in this case. SqlDataAdapter sqlAdp = new SqlDataAdapter(SELECT Part_ID FROM PARTS WHERE Part_Name = ' + PartN + ' sqlConn); sqlAdp.Fill(dtParts); DataRow row = dtStat.NewRow(); row[Status] = stat; //Get the err:'Column 'Status' does not belong to table' here. dtStat.Rows.Add(row); string VINval = txtVIN.Text.ToString(); SqlDataAdapter sqlAdp2 = new SqlDataAdapter(SELECT Survey_ID FROM SURVEY WHERE VIN = ' + VINval + ' sqlConn); sqlAdp2.Fill(dtSurvid); }

oblivion_lurks · Answer

rt how is your datatable layed out? i need to know what data your table is expecting from your app. let me know and then ill get back to you on that!!