ASP.NET

Nagraj Naik19-Jun-06 23:51

Nagraj Naik

19-Jun-06 23:51

Hi,
Can you explain your problem in detail.

varshavmane19-Jun-06 23:59

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.

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?

varshavmane20-Jun-06 0:27

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.

_AK_20-Jun-06 0:47

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

varshavmane20-Jun-06 1:03

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.

_AK_20-Jun-06 1:25

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

varshavmane20-Jun-06 1:30

20-Jun-06 1:30

Cant we use Arraylist for this????

_AK_20-Jun-06 1:49

20-Jun-06 1:49

how are storing the data in arraylist?

Best Regards,
Apurva Kaushal

varshavmane20-Jun-06 1:52

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.

_AK_20-Jun-06 2:00

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

varshavmane20-Jun-06 2:06

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.

_AK_20-Jun-06 2:40

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

varshavmane20-Jun-06 2:43

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.

_AK_20-Jun-06 2:54

20-Jun-06 2:54

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

Best Regards,
Apurva Kaushal

varshavmane20-Jun-06 2:57

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.

_AK_20-Jun-06 3:08

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

_AK_20-Jun-06 3:08

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

varshavmane20-Jun-06 3:15

20-Jun-06 3:15

No its not working.....

Thanks and Regards.

_AK_20-Jun-06 3:16

20-Jun-06 3:16

are you getting any compile time error?

Best Regards,
Apurva Kaushal

varshavmane20-Jun-06 3:20

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.

_AK_20-Jun-06 3:28

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) [modified]

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

varshavmane20-Jun-06 0:29

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