DataNavigator problem

Dealy

Hello, I have a function that retrieves a dataset from a stored procedure to a form. My problem is that the dataset has more than one records and i only get the first one at the form. I tried adding a dataNavigator but it doesn't seems to work. Any suggestions? Thank you.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Accepted answer
Hi ,

Here i have Corrected your code .

dont Add BindingNavigator Programatically Just Drag Drop One From ToolBox to your Form .

and Follow the Corrected Code :)

if still having Problem After using these code Send me your (All Project Folder+Database) in Zip to

[email protected] :)

private void select_items(string ID)
{

string connectionString = GetConnection();
using (SqlConnection conn = new SqlConnection(connectionString))
{

SqlCommand cmd = new SqlCommand("SELECT_ITEMS",conn)
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID",ID));
conn.Open();

//Fill The DataTable From Command
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

//Set It To Binding Navigator
BindingSource itmBindSource = new BindingSource();
itmBindSource.DataSource = dt;
BindingNavigator1.BindingSource = itmBindSource;

area_code_combo.DataBindings.Add(new Binding("SelectedValue", itmBindSource, "AREA_CODE", true));
item_id_txt.DataBindings.Add(new Binding("Text", itmBindSource, "ITEM_ID", true));
product_descr.DataBindings.Add(new Binding("Text", itmBindSource, "ITEM_DESCR", true));
memo_txt.DataBindings.Add(new Binding("Text", itmtBindSource, "COMMENTS", true));

}
}
Dealy17y ago
Thanks! This works perfectly! Can i ask you one more question? How do i enable insert,save and delete buttons?
Kirtan Patel17y ago

Rectified your Problem in Code dear I just Removed 2 Lines From the Code you Sent me and problem Solved :)

Here is Your Corrected Northwind Sample Take a Look At it and Enjoy :)

I commented The Code Take a look at it .

also take Care that you search only those IDs that are Available in Database :)

Download your corrected Northwind Sample Code
Dealy17y ago
I changed my code as you suggested but i'm still getting only one row os the dataset, and there no enable buttons on dataNavigator. I will send you the code files by email to see if you can help me. Thank you again for everything. PS: Something irrelative, why there no break lines in my posts even though i put some?:S
Dealy17y ago
Thank you for the quick answer :) Here's the code of Stored Procedure: CREATE PROCEDURE SELECT_ITEMS(@ID DECIMAL(10)) AS SELECT tblItems.* FROM tblItems WHERE tblItems.ID=@ID GO Code in C#: private void select_items(string ID) { string connectionString = GetConnection(); using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("SELECT_ITEMS")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ID",ID)); conn.Open(); cmd.Connection = conn; using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { BindingNavigator itmBindNavigator = new BindingNavigator(); BindingSource itmBindSource = new BindingSource(); itmBindNavigator.BindingSource = itmBindSource; Controls.Add(itmBindNavigator); DataTable dt10 = new DataTable(); dt10.Columns.Add("AREA_CODE", typeof(decimal)); dt10.Columns.Add("ITEM_ID", typeof(decimal)); dt10.Columns.Add("ITEM_DESCR", typeof(string)); dt10.Columns.Add("COMMENTS", typeof(string)); while (rdr.Read()) { DataRow dr10 = dt10.NewRow(); dr10[0] = rdr.GetDecimal(rdr.GetOrdinal("AREA_CODE")); dr10[1] = rdr.GetString(rdr.GetOrdinal("ITEM_ID")); dr10[2] = rdr.GetString(rdr.GetOrdinal("ITEM_DESCR")); dr10[3] = rdr.GetDecimal(rdr.GetOrdinal("COMMENTS")); dt10.Rows.Add(dr10); rdr.Close(); itmBindSource.DataSource = dt10; area_code_combo.DataBindings.Add(new Binding("SelectedValue", itmBindSource, "AREA_CODE", true)); item_id_txt.DataBindings.Add(new Binding("Text", itmBindSource, "ITEM_ID", true)); product_descr.DataBindings.Add(new Binding("Text", itmBindSource, "ITEM_DESCR", true)); memo_txt.DataBindings.Add(new Binding("Text", itmtBindSource, "COMMENTS", true)); } } } }
Kirtan Patel17y ago
Hi,

1. Post The code you are using to Get The Data From the database

2. Where you retrieving the data in DataGridView Or What ?

3.What Store Procedure Code You are using to Retrieve the Data ?

tell Me all Above information i Will Resolve your Problem :)

Happy Coding :)