|
Ya I have tried like this and keeping cchecklist.CheckListInsert=arrDataGriditems; inside 1st for loop also I have tried but same error.
|
|
|
|
|
dont put that inside first loop put that outside the loop and then try.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have tried with both ways but its not working...
|
|
|
|
|
probably i am not exactly understanding but the same is working for me. I have created a arraylist property and assigning the arraylist object to it and its giving me the correct result.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi,
I have created Arraylist of Arraylist and then assign it.Following is the code:
ArrayList checkList = new ArrayList();
ArrayList row = new ArrayList();
for(int cntRow = 0; cntRow < dt.Rows.Count ; cntRow++)
{
for(int cntCol = 0; cntCol < dt.Columns.Count ; cntCol++)
{
row.Add(dt.Rows[cntRow][cntCol]);
}
checkList.Add(row);
}
cchecklist.CheckListInsert = checkList;
result = cchecklist.InsertChecklist();
Line number 12 is call of Insert Function which I have written in class file and the code for insertion is the following:
int checklistno = 0;
for(int cnt = 0; cnt < checklistInsert.Count; cnt++)
{
ArrayList row = (ArrayList) checklistInsert[cnt];
checklistno++;
string sql = "INSERT INTO checklist "
+ " values(" + scheduleno + ", " + checklistno + ",'" + row[1] + "', "
+ " '" + row[2] + "','" + row[3] + "', '" + row[4] + "' , '" + status + "' ,"
+ " '" + histo + "' , '" + CDate + "' , " + CUser + " ,"
+ " '" + MDate + "', " + MUser + " )";
result = con.ExecuteNonQuery(sql);
}
if(result == 1)
{
con.CommitTrans();
}
Still its not working.It inserts the first record two times and second record is not consider.
If any changes in the code then please let me know.
Thanks and Regards.
|
|
|
|
|
Hi,
the code is working fine for me, only thing is i have assigned the datatable with some of my data and the rest of code is working here. I am getting the correct value of row1[1], row1[2], row1[3]...
Best Regards,
Apurva Kaushal
|
|
|
|
|
Can u please Copy paste that code for me???
Thanks and regards
|
|
|
|
|
Hi all,
I am creating query at runtime this query is depend upon dynamic criteria selection.
Now when this query is created I want to send this as stored procedure query part in sql stored procedure
i.e.
select * from records where recno>100 // this is sql query
I want to set this query as stored procedure query
//stored procedure
create procedure recordcount
as
//above generated query shoul be here
return
I hope you understand my problem.
If Know solution share with me......
Let's Teach Life To Laugh........
|
|
|
|
|
CREATE PROCEDURE recordcount<br />
@recno int(4)<br />
AS<br />
SELECT * from records where recno > 100
|
|
|
|
|
Hi,
You don't get me.
Basically I want to send my dynamic query as query to stored procedure.I mean stored procedure is not created i want to create it dynamically with my dynamic query
|
|
|
|
|
Please specify your problem clearly
|
|
|
|
|
hi try it
bteeeeeeeeeeeee
create procedure getrecno
@recno
as
begin
select * from tablename recno>=100
end;P
suresh babu.k
-- modified at 10:33 Tuesday 20th June, 2006
|
|
|
|
|
I want to generate report in asp DOT Net(vb) using CrystalReport. So pls tell me the procedure(steps) to do the reporting.
thanks in advance
|
|
|
|
|
Hi,
Please follow,
1)Drag and drop crystalreportviewer control on form
2)Right click on project in solution window
add new item - select Crystalreport
3) design your report and save it i.e. report1
4)right click on crystalreportviewer and select property
5) In property window ReportSource Select your crystalreport report1
I hope this help you.
Regards,
Nagraj
Let's Teach Life To Laugh........
|
|
|
|
|
|
I am facing a problem in Publishing my Website. I have created a website to experiment with the VS 2005 Login control. My website is working fine in Visual Studio 2005. But when I publish it and run it through IIS, this login control fails to work (not letting any user to log on). I guess there is some problem in Database connection. Website is using MS SQL 2005 for Membership Provider.
Please let me know if you know the solution.
Adarsh
|
|
|
|
|
Do you use the same user credential data for the published web site? Or it just uses another database? If you want it to use the same user data, you need to set the applicationName in the membership configuration.
|
|
|
|
|
Hello, I am designing a webapplication that has plan_courses and courses_followed table. It is required that after the planned date, an alert should be seen that will ask the administrator if the student followed the planned course or not and if yes, the record should automatically be inserted into the courses_followed table and delete from the plan_courses and if no, it should be deleted from the plan_courses table.
Does anyone know how I can even start with this puzzle?
Sample codes will be of great help, I am using SQL Server
Thanks a lot
Commickey
|
|
|
|
|
|
Yes... that can be true but how do I go about it?
I need a starting point... that is where I need the help
|
|
|
|
|
Hi,
I am working on ASP.NET 2.0. I have a dropdownlist & i have bound the data from the database. It works fine..
I gets illogical error..which i cant identify...
I have coded on the selected index change on dropdown list..but when i run the application it doesnt fire the event for select index change.
I have applied a breakpoint also but as it doesnt fire the event its not break at the breakpoint....
Any one can help me what problem is this...& how to solve it...
KHATRI
|
|
|
|
|
Hi,
Have you set Autopostback property of dropdown to true.If yes,check
Protected Sub ddl_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddl.SelectedIndexChanged
End Sub
I mean check procedure handles dropdownlist selectedindexchanged
I hope this will help you.
Let's Teach Life To Laugh.........
|
|
|
|
|
Well it shows the same function declaration but still its not firing the event. to get active on that function...
I have also applied the break point but it do not stop at that breakpoint because its not firing the event to gets active on this function..
Any one can help me
|
|
|
|
|
Hi,
Please double click on dropdownlist and check wheather it goes to same routine if yes and still you facing same problem,then check your page contain single or multiple tag in your code.
Regards,
Nagraj
|
|
|
|
|
Hi.
In the (c#) Web application that i am developing, there is a web form whose target is set as _blank.
now,i'm trying to do validations on the textboxes in the page using the javascript alert window.The alert window is getting displayed .But with the same page reopened.I need the alert window to get opened in the same form without getting reopened.
One another problem is to close the form on a button_click().
There also when i try to close the window using javascript code as
window.close();
its not giving me the result.
I think the problem is caused by the target _blank.
But that is required for my application.
Please provide a solution..
thanks 'n regards,
Me-CrazyCode
Me Crazy Code,
Application Developer
ADCS, U A E
|
|
|
|