How can I call this code on button click?

C# Corner

Shovan Saha

9y772Learn iOS Programming

int SlNo = 0;

var groupedData = from b in datatable.AsEnumerable()

group b by b.Field("Item") into g

select new

{

SlNo = ++SlNo,

Item = g.Key,

TotalPrice = g.Sum(x => x.Field("Price"))

};

3 Replies

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

Ankit Sharma9y ago
Accepted answer
Hi Shovan,

Use this code for your button tag in .aspx page
"Button" runat="server" CausesValidation="False" OnClick="Button_Click" Text="Button" />
use this code in .aspx.cs page to handle button click event
protected void Button_Click(object sender, EventArgs e)
{
iont SlNo = 0;
var groupedData = from b in datatable.AsEnumerable()
group b by b.Field<string>("Item") into g
select new
{
SlNo = ++SlNo,
Item = g.Key,
TotalPrice = g.Sum(x => x.Field<int>("Price"))
};
}
Hope this helps
+1
Ankit Sharma9y ago
Hi Shovan,

The issue that you have mentioned below is related to logic of your code.
I am unable to help until you share the logic/code with me.
0

Shovan Saha9y ago

Dear Ankit Sir, Please help me. I get an error message. For your kind information, C#, visual studio 2015, MS Access database, desktop application - these I have used. I have an existing datagrid view like this:

Type	Item	Price	Quantity
L	A	3	2
M	B	4	3
L	A	5	7
M	B	6	8
L	A	3	5
S	C	2	9
S	C	1	12

I need a new datagridview like this:

Sl. No.	Type	Item	TotalPrice	TotalQuantity
1	L	A	11	14
2	M	B	10	11
3	S	C	3	21