DataNavigator problem

Question

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.

Kirtan Patel · 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 kirtan007@gmail.com :) 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 )); } }

Dealy · Answer

Thanks! This works perfectly! Can i ask you one more question? How do i enable insertsave and delete buttons?

Kirtan Patel · Answer

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

Dealy · Answer

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

Dealy · Answer

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(@IDID)); 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 Patel · Answer

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 :)