Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
T

TomyWhite

@TomyWhite
About
Posts
3
Topics
1
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Returning selected row index after filtering
    T TomyWhite

    Well, I've browsed around a bit and this is what I've found: private void button1_Click(object sender, EventArgs e) { int ID; testDS.tblTestRow selectedRow; selectedRow = (testDS.tblTestRow)((DataRowView)bsTest.Current).Row; ID = selectedRow.ID; MessageBox.Show(ID.ToString()); } And other thing that filters these rows: private void txtName_textchange(object sender, EventArgs e) { string filter = "NAME like '" + txtName.Text + "%'"; bsTest.Filter = filter; bsTest is BindingSource, and testDS is DataSet (could be single table - DataTable, doesen't matter) - but I don't know how to do it without BindingSource.

    Visual Studio csharp database help question

  • Returning selected row index after filtering
    T TomyWhite

    I like the idea, and I'll try it, but I still don't know how to get current row from DataTable, and value for specific column .... I think that DataSet.tblTable.DefaultView can do the same as DataTable.DefaultView ... And there is RowFilter, but I still don't know how to retrieve exact column value from selected row.

    Visual Studio csharp database help question

  • Returning selected row index after filtering
    T TomyWhite

    I'm a total begginer. I work as a aplication tester with C# developers. They use DevExpress controls, but I don't have a licence for it, so I've tried to create UserControl that will work simmilar as one of the UserControls in that application that was made in Developer Express. this is the problem: I have 2 textboxes and one DataGridView. These 2 tb-s are used for filtering DGV (one of 2 columns). I've bound it to the DataSet with 3 colums, but I don't want to show them all, just these 2. What I want is to return third, hidden column. Problem is, I used BindingSource to filter DataGridRows, so it will show me only those rows that contain written data in those textboxes (eg. let's say column1 is FIRST NAME, Column2 is SECOND NAME, textbox1 filters names, and textbox2 filters SECOND NAMES). So It's like: private void tbFirstName_TextChange(object sender, EventArgs e) { string filter = "FirstName like '" + tbFirstName.Text + "%'"; bsUsers.Filter = filter; bsUsers is BindingSource, binded to DataSet, and it's DataSoruce for DataGridView .... When I select filtered DataGridRow, it's index in BindingSource is not equal to that in DataSet, becouse every time i filter, it generates new indexes starting from 0. How do I know on what row I am in DataSet. I want to know what ID is for what user, but I don't want ID column to be visible in DataGridView. I hope you've understand. Thanx in advance...

    Visual Studio csharp database help question
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups