Re: Saving Datagrid(Urgent) - ASP.NET Discussion Boards

varshavmane19-Jun-06 23:36

19-Jun-06 23:36

Hello to all,

I need to save datagrid into database by using Arraylist.

Please tell me how do I start with this.

Thanks and Regards.

Re: Saving Datagrid(Urgent)

Nagraj Naik19-Jun-06 23:51

Nagraj Naik

19-Jun-06 23:51

Hi,
Can you explain your problem in detail.

Re: Saving Datagrid(Urgent)

varshavmane19-Jun-06 23:59

varshavmane

19-Jun-06 23:59

Hi,

Actually I have Viewstate datatable and using this I am displaying Datagrid Contents.
Now I want to save the datagrid into database using Arraylist on Button Click event.

I hope I have made my self clear.

Thanks and Regards.

Re: Saving Datagrid(Urgent)

sathish s20-Jun-06 0:24

sathish s

20-Jun-06 0:24

You can directly save those values using a datatable.
Why do you want a arraylist?

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 0:27

varshavmane

20-Jun-06 0:27

Can I manage the Transaction with this, if yes then can u please give tell me how to go about it.If No then i need to use Arraylist only because I know I can manage the Transaction.

Thanka and Regards.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 0:47

_AK_

20-Jun-06 0:47

You can manage transactions through front end also.
Go through this link this may help you a bit.
http://www.c-sharpcorner.com/asp/Code/TransactionsInASPNETDPL.asp

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 1:03

varshavmane

20-Jun-06 1:03

I can manage Transaction Front end also but I dont want as my code for Transaction is in Class file because of this I will have to change code on every form which i dont want.

Please help me in saving datagrid (whose data is display with the help of Viewstate Datatable)into Arraylist.

Thanks and Regards.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 1:25

_AK_

20-Jun-06 1:25

probably i am not been able to understand your problem. but if what i have understood is correct then you can maintain the complete transaction in class file itself and just pass the datatable or any parameter you want from your pages.

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 1:30

varshavmane

20-Jun-06 1:30

Cant we use Arraylist for this????

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 1:49

_AK_

20-Jun-06 1:49

how are storing the data in arraylist?

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 1:52

varshavmane

20-Jun-06 1:52

Following is the code what I am using:::

private void ibtnSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Classes.CChecklist cchecklist = new Classes.CChecklist();
int result = -1;
DataTable dt = new DataTable("ChecklistMod");
dt = (DataTable)ViewState["dtCheckList"];

ArrayList arrDataGriditems = new ArrayList();
for(int cntRow = 0; cntRow < dt.Rows.Count ; cntRow++)
{
for(int cntCol = 0; cntCol < dt.Columns.Count ; cntCol++)
{
string str = dt.Rows[cntRow][cntCol].ToString();
arrDataGriditems.Add(dt.Rows[cntRow][cntCol]);
cchecklist.CheckListInsert.Add(dt.Rows[cntRow][cntCol]);
}
}
result = cchecklist.InsertChecklist();
if(result == 1)
{
lblError.ForeColor = System.Drawing.Color.Green;
lblError.Visible = true;
lblError.Text = "Record Inserted";
}
else
{
lblError.ForeColor = System.Drawing.Color.Red;
lblError.Visible = true;
lblError.Text = "Record Not Inserted" + ":" + cchecklist.LastError;
}
}

Bue I not able to get elements in
cchecklist.CheckListInsert.Add(dt.Rows[cntRow][cntCol]);
but I am getting elements in
arrDataGriditems.Add(dt.Rows[cntRow][cntCol]);
Please let me know where I am going wrong.

Thanks and regards.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 2:00

_AK_

20-Jun-06 2:00

What is the purpose of this method cchecklist.CheckListInsert.Add()

varshavmane wrote:
Bue I not able to get elements in
cchecklist.CheckListInsert.Add(dt.Rows[cntRow][cntCol]);
but I am getting elements in
arrDataGriditems.Add(dt.Rows[cntRow][cntCol]);

Both the places you are using same thing("dt.Rows[cntRow][cntCol]" and dt.Rows[cntRow][cntCol]) so how could it be different.

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 2:06

varshavmane

20-Jun-06 2:06

cchecklist.CheckListInsert.Add() is nothing but Arraylist Property of Checklist class.
It is assigning the dt.Rows[cntRow][cntCol] value to arrDataGriditem.Add() but not to cchecklist.CheckListInsert.Add()
This is where I am facing problem.

Thanks and Regards.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 2:40

_AK_

20-Jun-06 2:40

If both accepts same type of parameters and if you are providing same parameter values then obviously they should behave same manner if they are intended for the same purpose.

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 2:43

varshavmane

20-Jun-06 2:43

But they are not initialize to the values of datatable as it is initialize to Local arraylist variable.
Can u please tell me what is the problem???
Thanks.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 2:54

_AK_

20-Jun-06 2:54

that depends upon what you are doing in cchecklist.CheckListInsert.Add().

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 2:57

varshavmane

20-Jun-06 2:57

It is just a property code as follows:

public ArrayList CheckListInsert
{
get
{
return checklistInsert;
}
set
{
checklistInsert = value;
}
}

This code is in class file.
Thanks and Regards.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 3:08

_AK_

20-Jun-06 3:08

you cant add the value like that for the property of type arraylist.

for(int cntRow = 0; cntRow < dt.Rows.Count ; cntRow++)<br />
			{<br />
				for(int cntCol = 0; cntCol < dt.Columns.Count ; cntCol++)<br />
				{<br />
					string str = dt.Rows[cntRow][cntCol].ToString();<br />
					arrDataGriditems.Add(dt.Rows[cntRow][cntCol]);<br />
					<br />
					<br />
					<br />
				}<br />
			}<br />
cchecklist.CheckListInsert.Add(arrDataGriditems);<br />

I think this will solve the problem.

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 3:08

_AK_

20-Jun-06 3:08

I have just given the code for the looping and after that. You just replace them only.

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 3:15

varshavmane

20-Jun-06 3:15

No its not working.....

Thanks and Regards.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 3:16

_AK_

20-Jun-06 3:16

are you getting any compile time error?

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

varshavmane20-Jun-06 3:20

varshavmane

20-Jun-06 3:20

No I am getting runtime error saying :

"The name 'ArrayList' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted."

I dont know what is the problem????
Thanks and regards.

Re: Saving Datagrid(Urgent)

_AK_20-Jun-06 3:28

_AK_

20-Jun-06 3:28

you try like this:

for(int cntRow = 0; cntRow < dt.Rows.Count ; cntRow++)<br />
{<br />
for(int cntCol = 0; cntCol < dt.Columns.Count ; cntCol++)<br />
{<br />
string str = dt.Rows[cntRow][cntCol].ToString();<br />
arrDataGriditems.Add(dt.Rows[cntRow][cntCol]);<br />
<br />
<br />
<br />
}<br />
}<br />
cchecklist.CheckListInsert=arrDataGriditems;

Best Regards,
Apurva Kaushal

Re: Saving Datagrid(Urgent)

Nagraj Naik20-Jun-06 0:26

Nagraj Naik

20-Jun-06 0:26

Hi,

////fill arraylist

sub fill_Array()

Dim gridItem As DataGridItem
Dim idArray As New ArrayList()

For Each gridItem In DataGrid1.Items
Dim lbl As Label = DirectCast(gridItem.FindControl("ID"), Label)
idArray.Add(lbl.Text)
next
end sub

///saving to database

Sub Save()
for i=0 to DataGrid1.Items.Count-1
sql="insert into tablename name="+idarray(i)
//Execute this query
next
end sub

If it's not of you mean......have some more discussion

Regards,
Nagraj

Re: Saving Datagrid(Urgent) [modified]

varshavmane20-Jun-06 0:29

varshavmane

20-Jun-06 0:29

Tell me why are we using Label here???I understood the code but not the Label one.
I am not getting datagriditem().It contains some arguments.I am using C#.Net

-- modified at 6:33 Tuesday 20th June, 2006

Last Visit: 31-Dec-99 18:00 Last Update: 10-Jun-24 13:51

Refresh

ᐊ Prev 1...6158 6159 6160 616161626163 6164 6165 6166 6167 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.