Reply to thread

Message

<blockquote data-quote="Ranhiru" data-source="post: 4585115" data-attributes="member: 17748">I have a form with data bindings.&nbsp;&nbsp; and i use a BindingManagerBase to travel through the records&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;[code]SqlConnection con = Global.Con;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; da = new SqlDataAdapter(&quot;SELECT * FROM Customer&quot;, con);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mcb = new SqlCommandBuilder(da);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; da.Fill(ds, &quot;Customer&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtCustomerFName.DataBindings.Add(new Binding(&quot;Text&quot;, ds.Tables[&quot;Customer&quot;], &quot;Cus_FName&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtCustomerLName.DataBindings.Add(new Binding(&quot;Text&quot;, ds.Tables[&quot;Customer&quot;], &quot;Cus_LName&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtCustomerAddress.DataBindings.Add(new Binding(&quot;Text&quot;, ds.Tables[&quot;Customer&quot;], &quot;Cus_Address&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtCustomerEmail.DataBindings.Add(new Binding(&quot;Text&quot;, ds.Tables[&quot;Customer&quot;], &quot;Cus_Email&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtCustomerRegDate.DataBindings.Add(new Binding(&quot;Value&quot;, ds.Tables[&quot;Customer&quot;], &quot;Reg_Date&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; txtCustomerLoyalty.DataBindings.Add(new Binding(&quot;Text&quot;, ds.Tables[&quot;Customer&quot;], &quot;Loyalty&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; bm = this.BindingContext[ds.Tables[&quot;Customer&quot;]];[/code]&nbsp;And then i use bm.Position +=1 and bm.Position -=1 to travel through it.[code]private void cmdBack_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (bm.Position == 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;Reached beginning of list!&quot;, &quot;Cannot go further!&quot;, MessageBoxButtons.OK, MessageBoxIcon.Information);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; bm.Position -= 1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private void cmdNext_Click(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (bm.Position == (bm.Count - 1))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;Reached end of list!&quot;, &quot;Cannot go further!&quot;, MessageBoxButtons.OK, MessageBoxIcon.Information);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; bm.Position += 1;&nbsp; &nbsp; &nbsp; &nbsp; }[/code] &nbsp;Anyway&nbsp; i use a DataView and DataView.RowFilter to search and display the results in the DataGridView which is in a seperate form. And once the search results are returned i want to set the current position in the before form to whatever row is selected in the Data Grid View. [code]private void CustomerSearch_Load(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection con = Global.Con;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataAdapter da = new SqlDataAdapter(&quot;SELECT * FROM Customer&quot;, con);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; da.Fill(ds, &quot;Customer&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dv.Table = ds.Tables[0];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DGV1.DataSource = dv;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private void txtSearchString_TextChanged(object sender, EventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dv.RowFilter = &quot;Cus_FName LIKE '*&quot; + txtSearchString.Text + &quot;*' OR Cus_LName LIKE '*&quot; + txtSearchString.Text+ &quot;*' OR Cus_Address LIKE '*&quot; + txtSearchString.Text + &quot;*' OR Cus_Email LIKE '*&quot; + txtSearchString.Text + &quot;*'&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }[/code]&nbsp;Now if the user selects a row returned from the searching, i want set the bm.Position (which is in another form but i can take the searching the same form as well) to whatever the row selected on the DataGridView.I hope you get the problem. Please ask me if this is not clear.&nbsp; How can i do that?</blockquote>

[QUOTE="Ranhiru, post: 4585115, member: 17748"] I have a form with data bindings. and i use a BindingManagerBase to travel through the records [code]SqlConnection con = Global.Con; con.Open(); da = new SqlDataAdapter("SELECT * FROM Customer", con); mcb = new SqlCommandBuilder(da); da.Fill(ds, "Customer"); txtCustomerFName.DataBindings.Add(new Binding("Text", ds.Tables["Customer"], "Cus_FName")); txtCustomerLName.DataBindings.Add(new Binding("Text", ds.Tables["Customer"], "Cus_LName")); txtCustomerAddress.DataBindings.Add(new Binding("Text", ds.Tables["Customer"], "Cus_Address")); txtCustomerEmail.DataBindings.Add(new Binding("Text", ds.Tables["Customer"], "Cus_Email")); txtCustomerRegDate.DataBindings.Add(new Binding("Value", ds.Tables["Customer"], "Reg_Date")); txtCustomerLoyalty.DataBindings.Add(new Binding("Text", ds.Tables["Customer"], "Loyalty")); bm = this.BindingContext[ds.Tables["Customer"]];[/code][COLOR=Black] [/COLOR] And then i use bm.Position +=1 and bm.Position -=1 to travel through it. [code]private void cmdBack_Click(object sender, EventArgs e) { if (bm.Position == 0) MessageBox.Show("Reached beginning of list!", "Cannot go further!", MessageBoxButtons.OK, MessageBoxIcon.Information); else bm.Position -= 1; } private void cmdNext_Click(object sender, EventArgs e) { if (bm.Position == (bm.Count - 1)) MessageBox.Show("Reached end of list!", "Cannot go further!", MessageBoxButtons.OK, MessageBoxIcon.Information); else bm.Position += 1; }[/code] Anyway i use a DataView and DataView.RowFilter to search and display the results in the DataGridView which is in a seperate form. And once the search results are returned i want to set the current position in the before form to whatever row is selected in the Data Grid View. [code]private void CustomerSearch_Load(object sender, EventArgs e) { SqlConnection con = Global.Con; SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Customer", con); da.Fill(ds, "Customer"); dv.Table = ds.Tables[0]; DGV1.DataSource = dv; } private void txtSearchString_TextChanged(object sender, EventArgs e) { dv.RowFilter = "Cus_FName LIKE '*" + txtSearchString.Text + "*' OR Cus_LName LIKE '*" + txtSearchString.Text+ "*' OR Cus_Address LIKE '*" + txtSearchString.Text + "*' OR Cus_Email LIKE '*" + txtSearchString.Text + "*'"; }[/code][COLOR=Black] [/COLOR] Now if the user selects a row returned from the searching, i want set the bm.Position (which is in another form but i can take the searching the same form as well) to whatever the row selected on the DataGridView. I hope you get the problem. Please ask me if this is not clear. How can i do that? [/QUOTE]

Verification

Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)

Latest ads

Reply to thread