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 < _RowCount; _Row++)
{
var _Data = GrdSearch.Rows[_Row].Cells[0].Value;
string _Inventory_Value = "SELECT Item_No ,Sum(Cast(Invoiced_Quantity as decimal(15,6))) 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 G · Answer

Try this Once     var dataTable = new DataTable();
int _RowCount = GrdSearch.Rows.Count;
//GrdSearch.Columns.Add("Inventory", "Inventory");
for (int _Row = 0; _Row

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(20,6))) 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 G · 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 G · 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(6,3)) As 'Unit Price' ,Cast(Items.[Unit Cost] as decimal(6,3)) 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(6,3))) 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 G · 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