Read Data From Grid View

Question

can Any one help me in .net code

i have grideview have an data

i need to read the data in first column for all rows and make an select statement to retrieve data from another table and put the result in same of grideview

i want to read the item number from here and do this statement

SELECT Item_Ledger_Entry.[Item No_]
,Sum(Cast(Item_Ledger_Entry.[

Quantity]as decimal(6,3))) As 'Inventory'
FROM [HO].[dbo].[American Department Stores$Item Ledger Entry] Item_Ledger_Entry
Where Item_Ledger_Entry.[Item No_]='T474151'
And Item_Ledger_Entry.[Location Code]='S0002'
Group By Item_Ledger_Entry.[Item No_]

Replace 'T474151' from Item Number and S0002 From Text Box

AbedElHamid AlWahidy · Answer

this is the solution for this issue when we need to read from same gride view and retrive the result into same gride view : string _ConnectionString = Data Source=.;Initial Catalog=Local;Persist Security Info=True;User ID=sa;Password=123 ; DataTable _DTable = new DataTable(); SqlConnection _Conn = new SqlConnection(_ConnectionString); _Conn.Open(); int _RowCount = GrdSearch.Rows.Count; GrdSearch.Columns.Add( Sales (Qty)  Sales (Qty) ); for ( int _Row = 0; _Row { var _Data = GrdSearch.Rows[_Row].Cells[0].Value; string _Inventory_Value = SELECT Item_No Sum(Cast(Invoiced_Quantity as decimal(156))) As 'Sales (Qty)' FROM Value_Entry Where Item_No=@InvValue ; SqlCommand _InventoryValue = new SqlCommand(_Inventory_Value _Conn); _InventoryValue.Parameters.AddWithValue( @InvValue  _Data); SqlDataReader _Objreader_Inf = _InventoryValue.ExecuteReader(); _Objreader_Inf.Read(); GrdSearch.Rows[_Row].Cells[9].Value = Convert.ToString(_Objreader_Inf[ Sales (Qty) ].ToString()); _Objreader_Inf.Close(); }

Mangesh Gaherwar · Answer

Try this Once var dataTable = new DataTable(); int _RowCount = GrdSearch.Rows.Count; //GrdSearch.Columns.Add(Inventory Inventory); for (int _Row = 0; _Row { var _Data = GrdSearch.Rows[_Row].Cells[0].Value; string _Inventory_Value = SELECT Item_Ledger_Entry.[Item No_] Sum(Cast(Item_Ledger_Entry.[Quantity]as decimal(206))) As 'Inventory' FROM[HO].[dbo].[American Department Stores$Item Ledger Entry] Item_Ledger_Entry Where Item_Ledger_Entry.[Item No_]=@InvValue And Item_Ledger_Entry.[Location Code]like '% + ComStore.SelectedItem.ToString() + %' Group By Item_Ledger_Entry.[Item No_] ; SqlCommand _InventoryValue = new SqlCommand(_Inventory_Value _Conn); _InventoryValue.Parameters.AddWithValue(@InvValue _Data); SqlDataReader _Objreader_Inf = _InventoryValue.ExecuteReader(); _Objreader_Inf.Read(); dataTable.Load(_Objreader_Inf); _Objreader_Inf.Close(); } GrdSearch.DataSource=dataTable

AbedElHamid AlWahidy · Answer

int _RowCount = GrdSearch.Rows.Count; //GrdSearch.Columns.Add(Inventory Inventory); for ( int _Row = 0; _Row { var _Data = GrdSearch.Rows[_Row].Cells[0].Value; string _Inventory_Value = SELECT Item_Ledger_Entry.[Item No_] Sum(Cast(Item_Ledger_Entry.[Quantity]as decimal(206))) As 'Inventory' FROM[HO].[dbo].[American Department Stores$Item Ledger Entry] Item_Ledger_Entry Where Item_Ledger_Entry.[Item No_]=@InvValue And Item_Ledger_Entry.[Location Code]like '% + ComStore.SelectedItem.ToString() + %' Group By Item_Ledger_Entry.[Item No_]  ; SqlCommand _InventoryValue = new SqlCommand(_Inventory_Value _Conn); _InventoryValue.Parameters.AddWithValue( @InvValue  _Data); SqlDataReader _Objreader_Inf = _InventoryValue.ExecuteReader(); _Objreader_Inf.Read(); GrdSearch.Rows[_Row].Cells[10].Value= Convert.ToString(_Objreader_Inf[ Inventory ].ToString()); _Objreader_Inf.Close(); } i use this code to bind data

Mangesh Gaherwar · Answer

Post your binding code Abe what code you are using for binding things to gridview

AbedElHamid AlWahidy · Answer

i use this code GrdSearch.Rows[_Row].Cells[10].Value= Convert.ToString(_Objreader_Inf[ Inventory ].ToString()); did it right or not

Mangesh Gaherwar · Answer

GrdSearch.DataSource = _DTable ; Hope this Help U :) Happy Coding !!!!

AbedElHamid AlWahidy · Answer

now i just need to set the data in gride view again how can i do it My Gride View name is GrdSearch please help me

AbedElHamid AlWahidy · Answer

this is my code to select the data from DB : DataTable _DTable = new DataTable(); SqlConnection _Conn = new SqlConnection(_ConnectionString); string _Search_Query = Select Items.[No_] As 'Item Number'Barcode.[Barcode No_] As 'Barcode No Unit' Items.[Description] As 'Item Description'Cast(Items.[Unit Price] as decimal(63)) As 'Unit Price' Cast(Items.[Unit Cost] as decimal(63)) As 'Unit Cost'Items.[Division Code]Divisions.[Description] As 'Divisions Description'Items.[Vendor No_] As 'Vendor Number'Vendors.[Name] As 'Vendor Name'Value_Entry.[Location Code] FROM [HO].[dbo].[American Department Stores$Item] As Items [HO].[dbo].[American Department Stores$Vendor] As Vendors [HO].[dbo].[American Department Stores$Barcodes] As Barcode [HO].[dbo].[American Department Stores$Division] As Divisions [HO].[dbo].[American Department Stores$Value Entry] As Value_Entry Where Items.[No_]= Barcode.[Item No_] And Items.[Vendor No_]=Vendors.[No_] And Items.[Division Code]=Divisions.[Code] And Items.[Blocked]=0 And Value_Entry.[Item No_]=Items.[No_] And Value_Entry.[Location Code]like '% + ComStore.SelectedItem.ToString() + %' Group By Items.[No_]Barcode.[Barcode No_] Items.[Description]Items.[Vendor No_]Vendors.[Name]Divisions.[Description]Items.[Unit Price]Items.[Division Code]Items.[Unit Cost]Items.[Blocked]Value_Entry.[Location Code] Order By Items.[No_] ; SqlCommand _CmdSearch = new SqlCommand(_Search_Query _Conn); SqlDataAdapter _DAdapter = new SqlDataAdapter(_CmdSearch); _DAdapter.Fill(_DTable); GrdSearch.DataSource = _DTable; and this the code i try with it to select the item number and make the select statement on it : DataTable _DTable = new DataTable(); SqlConnection _Conn = new SqlConnection(_ConnectionString); string _Data =  ; int indexOfYourColumn = 0; foreach (DataGridViewRow _Row in GrdSearch.Rows) _Data = _Row.Cells[0].Value.ToString(); string _Inventory_Value = SELECT Item_Ledger_Entry.[Item No_] Sum(Cast(Item_Ledger_Entry.[Quantity]as decimal(63))) As 'Inventory' FROM[HO].[dbo].[American Department Stores$Item Ledger Entry] Item_Ledger_Entry Where Item_Ledger_Entry.[Item No_]=@InvValue And Item_Ledger_Entry.[Location Code] '% + ComStore.SelectedItem.ToString() + %' Group By Item_Ledger_Entry.[Item No_]  ; SqlCommand _InventoryValue = new SqlCommand(_Inventory_Value _Conn); _InventoryValue.Parameters.AddWithValue( @InvValue _Data); SqlDataReader _Objreader_Inf = _InventoryValue.ExecuteReader(); _Objreader_Inf.Read();

Mangesh Gaherwar · Answer

HI ABE Can u just set the datasource again Yourgrid.datasource=yourdatatable Make sure u have autogeneratecoulumns property to true

AbedElHamid AlWahidy · Answer

ok now when i read the data and have the value how can i put it in same gride view

Midhun T P · Answer

Hi If you need to loop through all rows and read value of single column use below code - string data = string.Empty; int indexOfYourColumn = 0; foreach (DataGridViewRow row in dataGridView1.Rows) data = row.Cells[indexOfYourColumn].Value;