|
SqlCommand cmd;
SqlDataReader rdr1;
int i;
cmd = new SqlCommand("Select * from tblTest where [Check]='False'",con1);
rdr1 = cmd.ExecuteReader();
if (rdr1.HasRows)
{
while (rdr1.Read())
{
cmd = new SqlCommand("Insert into tblTest values('" + rdr1[0].ToString() + "','" + rdr1[1].ToString() +"','" + rdr1[2].ToString()+ "')", con2);
i = cmd1.ExecuteNonQuery();
cmd = new SqlCommand("update tbltest set [check]='True' where ID='" + rdr1[0].ToString() + "'", con1);
i = cmd2.ExecuteNonQuery();
}
}
cmd.Dispose();
rdr1.Close();
Here one datareader is already open with tblTest and inside of while loop I am trying to update records for table tblTest,Please let me know how to fix datareader problem. We can do with dataadapters but here how we can solve it?
|
|
|
|
|
What are you trying to do??
Selecting values from tblTest and inserting again into same table??
|
|
|
|
|
selecting values from one table like [tblOne] then matching records with other table like [tblTwo] then updating first table [tblOne].
|
|
|
|
|
To be honest, it is not easy to read your code. Could you clean that up a little?
While cmd is the created command, cmd1 and cmd2 are executed. It's weird and does
not invite someone to look into it in detail. Also, could you describe the problem and
maybe some details of the goal you're trying to archive?
|
|
|
|
|
It is not the problem of DataReader. When the DataReader is opened, it will hold the connection exclusively. So you can't execute any sql commands when it opened.
The solution is to use a separate connection or use a DataSet.
P.S : You need to improve your coding standards.
|
|
|
|
|
hi,i am doing one page i.e;sending messages to mobile.so i want how to send message at particular time means user type some message and select some particular time now we(programmers) have to send that massege at that time (automatically)programatically.send code(code behind) soon.......... plz
|
|
|
|
|
|
How do you think Windows Service would help her? She needs user interaction. In her requirement user should be able to schedule sending of a message? How would you do that using Windows Service??
..Go Green..
|
|
|
|
|
Yes, She needs the user interaction for schedule. But already she has a page for UI(For Creating Message, Setting Time Schedule). But the sending Message process we need windows service(Get data from database & check the time then send message to mobile). You suggested her the Timer control for her issue, but the problem is you can't send message always by using a web page(what will happen if she close the page?) so you need the windows service for the message sending process.
|
|
|
|
|
Okay, I got it. So everything needs to be saved into the database and the service on the server will check the database at a regular time interval and will match the current time and scheduled time. If a message send job is found, get the details and send the message.
So the important thing here is triggering the job which will be done by our service.
I knew I am on ASP.NET page, but Windows application thing was going in my mind.
I have removed my answer.
..Go Green..
modified on Tuesday, July 6, 2010 6:44 AM
|
|
|
|
|
Absolutely right, Most of us using windows service for these type of mass jobs(like Email/Fax/SMS).
cheers
|
|
|
|
|
hello all, I have a object list(Customers) which I am binding to a gridview. Problem is that the Customers object has 30 fields/attributes & I am binding only 6 in the gridview columns, the rest are wasted.
Should I make another class to deal with gridview only,but that would mean a lot of classes for gridviews alone ? Is there a way I can do this with inheritance making a child class or something ? Please help me.
Thanks, Mike.
|
|
|
|
|
U can make another class for having required columns only, coz it may create performance overhead
when u have huge no. of records tht r fetched n displayed.
http://www.opexsolution.com/forum/[^]
|
|
|
|
|
Yes I know but what is recommended,
using inheritance with the superclass or a new class overall ?
Thanks, Mike.
|
|
|
|
|
|
how about using a data transfer object ? Do you have any example ?
|
|
|
|
|
Creating a class and accessing the base class to get the data out is anyway going to waste your memory. Actually you will be wasting double the memory by doing it this [Memory for your original class and memory for the new class with the filtered data].
Its is better to either put a different class that pulls out only the data required for the grid or to leave your system as-is.
Just my 2 cents. HTH!
|
|
|
|
|
The academic way would certainly be to bind a collection of objects which
only contain the absolute necessary properties. (Keep the view as stupid as possible)
This way, the view cannot mess with data he is not ment to have..
But to be honest, if i dont have huge business entities - maybe even with some crucial
methods inside (uh uh), i use them directly within the view. It always depends
on the situation i guess.
But thats just my opinion.
|
|
|
|
|
Hi,
Anyone please share sample codes for MVC architecture using ASP.NET.
Guhananth.S
|
|
|
|
|
Everything you need is here: read everything.
ASP.NET MVC[^]
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Hello ,
I work on an intranet site management school, I used the roles for each service (inscription, statistics ,.....) but I blocked on teachers :the responsable for each module has a password and login and I have an aspx file for each module (20 modules). what I want to do and I can not do it: If a teacher connects with his login and password it will be redirected to this module page ? I can not code this code.
Thank you for helping me.
|
|
|
|
|
|
|
dittu7 wrote: If CheckBox1.Checked = True Then
Session("value") = "chkT"
Where in the page is this code written? On which event. Is this code running eveytime you click on checkbox? used Debugger?
Further, what do you mean by 'without closing application when i check..."? You are on two different pages, right? Can you clear your work flow stepwise maybe.
|
|
|
|
|
R u writing this code on Page_Load() event.
if yes, do the code under (! IsPostBack()) function.
regards
Rating always..... WELCOME
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|