|
|
I was looking for how to use the dataadapter to make updatings on multiple tables with a single transaction.
I´ve found a couple examples, but they just add, more questions. As I understood in order to dataadapter could trace the table´s changes we have to fill the dataset with each table data store in the database by doing select * from table and then using dataadapter.fill method. But in the most of cases the tables are so big enought and because of web environment many user can using the application at same time, the server could easily crash.
When I use classical asp 3.0, I created *.cls classes and compile them to get an .dll file.
One of the more important class was one it wrapps the database operations. basically its structure was: two properties,bSuccessful,sSql. Its methods ExecQuery
wich basically was
bSuccessful = 1
sSql = "update,insert,delete ...."
oConn.execute
on error:
bSuccessful = 0
exit sub
For example, clsEvaluation has a RegisterEvaluation method,
it uses the clsDBoperation in order to control the operations.
RegisterEvaluation
set oConn = new clsEvaluation
oConn.Connect
oConn.startTransaction
oConn.setsSql = " insert, edit , delete .... "
If oConn.getbSuccessful = 1 then
.....
else
oConn.stopTransaction
endif
I did did the same, building a class with .NET 3.5, but now i´m wondering can it be achive using a dataadapter?
P.D: I´m sorry if the question is long but I considered to be as clearer as possible
|
|
|
|
|
Is there any Need to Install Crystal Reports on Web server if we Use them in our Web Application 
|
|
|
|
|
You have already asked this in QA.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
|
ashjassi wrote: Shut up u r idiot
Thank you. Coming from someone that cannot spell or write a complete sentence, you certainly proved your superiority.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
modified 6-Oct-12 9:56am.
|
|
|
|
|
Avoid cross-posts from next time. Pick a forum that looks most suitable for your question and stick to it.
I replied you in Q&A: Crystal Report Runtime support[^]
|
|
|
|
|
I'm working on a web application that allows you to import an excel spreadsheet with a list of users. When importing this spreadsheet what it does is creates users in active directory and then enables the user mailbox in Exchange.
I'm more a Windows developer but what I'm wanting is to display a progress percentage and text on what user it is on and a list of ones that may have failed.
I've done some googling and found a lot of information on this topic (http://msdn.microsoft.com/en-us/magazine/cc163553.aspx[^] and even Use the Asynchronous Power of ASP.NET to Create a Simple, Reusable Page for Displaying a Processing Message[^]).
What I am wanting to know is which of these would be a better option for what I'm trying to do? Would creating a web service that reports the progress be best?
If I do a web service would it work like this:
1) User submits list of users to Web Service
2) Web service gets list and returns a Guid to page
3) Page redirects to another webpage with the guid session variable or query string
4) Web service starts the task and logs its progress to a SQL database
5) Page constantly refreshes (every 1 or 2 seconds), pulling the latest information regarding that GUID from the database and displaying it.
6) Web service logs the "COMPLETED" task in the database
7) Web page receives the "COMPLETED" information from the database and stops refreshing..
Sorry for the novice questions on this topic.. just wanting to make sure I have the workflow correct
|
|
|
|
|
If your good with javascript and char arrays, then maybe you can parse the excel file using client script, and then the list to a web service 1 user at a time, in a loop, so you can update the progress and results.
|
|
|
|
|
I'm not really that great with javascript but wouldn't that be opening my web service for anyone to use?
If I was callign the web service from code behind I can limit it to that specific IP. If I am callign it with javascript then that is client side code which would mean I would have to open the web service to the world.
Not sure if that would be best for my situation 
|
|
|
|
|
Well of course, but I think there is a rule in javascript, which only the originating website can consume a web service, you can't go cross domain using $ajax, you have to use something else to go cross domain.
I don't what to tell you.
You want to do something really really complex, and your not sure how to plan or engineer the task, plus your not familiar with some of the rules regarding how to secure the application.
Then you need to start simple and upload the excel file first. Then read the file and parse the data you need. Then create your accounts, update your database, and return a result first.
Then take the pieces, optimize them, and you can rearrange the parts, to be more fluid.
In theory, with really well written code, shouldn't take more than a few seconds to complete the task.
|
|
|
|
|
I'll see what I can find out.
I have already wrote all the code that uploads the excel spreadsheet, creates the active directory users, then enables the user's mailbox in Exchange. This is all working just fine.
In theory this type of import will not take a few seconds. You are talking about upload excel spreadsheets that contain numerous amounts of users (One client is 700 users for example).
So that is 700 calls to Active Directory that creates the user object, another 700 calls to add that new users to the correct security groups, then another 700 calls to Exchange using remote powershell to enable the user object for mail. Remote powershell is not that fast anyways.
I was really just looking for a type of tutorial or a working example of what I am looking for, which is just being able to relay information back to the client about which task the server is currently performing.
|
|
|
|
|
I forgot, that’s going to take awhile, maybe an hour or two. Maybe 4 or 5 hours. Writing to active directory isn’t that fast.
Just tell them it will be ready in the morning
Well, if you look at windows update, or Microsoft virtual server, the web interface, that’s the most advance stuff that I have seen. I’m trying to think of more examples.
You can try the google forums, and I think Gmb something.
I don’t know of any turtorial, that’s probably going to be home brewed.
I tried some stuff in the past that worked, but then an update to asp.net came out and it killed my work.
Today I just avoid that stuff.
I would use uploadify to upload the excel file, attach uploadigy to a generic handler, process the excel file, return a json array to javascript with the names via generic handler, then create dynamic javascript and populate a div container using append, with progress updates, feed each user in 1 at a time through a web service to create each user, return json with the status when complete, loop again till done. When done, create a complete button via dynamic javascript.
Since the whole thing is ssl, and session protected, security should be covered. Generic handlers are session capable.
if you call a web service ssl, it will be ssl. You can tweak a web service to be session capable. Add some tokens to the javascript ajax for authentication, tweak the names to make it real confusing to the average joe.
|
|
|
|
|
Hi
I have a web page .On clicking of a button I get a modal popup(Ajax) which shows the the text box which is dynamically filled by the contents and it is inside a panel. This modal popup contains a print button. Once I do print then I take the innerhtml from the panel and open it in a separate window and this goes for printing. But as the text value is dynamic so the height of the text box is not fixed and hence when i do print so the part remaining in the scroll bar doenot print. Could you please let me know how exactly i can remove the scrool bar means I can adjust the height of the text area so that all the contents present in the text area can be printed.
the code is like this as shown below.
var printContent = document.getElementById('<%= pnlProrateSlip.ClientID %>');
var windowUrl = 'about:blank';
var uniqueName = new Date();
uniqueName.getTime();
var printWindow = window.open(windowUrl, windowName, 'left=50000,top=50000,width=0,height=0');
var printWindow = window.open(windowUrl, windowName);
printWindow.document.write(printContent.innerHTML);
printWindow.document.close();
printWindow.focus();
printWindow.print();
printWindow.close();
So what I am doing is , geting the innerhtml value from the panel and putting in a new page and printing it.This panel contains a textbox, whose height and widt I have to manipulate through script, so that I will not get the scroll bar. So from the innerhtml of the panel can I get the textbox by the ID?
Thanks
Prashant
|
|
|
|
|
Well, you need to calculate the height then, and use the result in your JavaScript to re-size the text area. But then you have to pass it to the next page somehow.
The textarea scrollbar is the default for overflow, so you use CSS to either hide or show the overflow.
Maybe you should experiment with CSS first. CSS is pretty good for solving stuff like that. height: auto;
Oh, and that's a JavaScript question, and your post belongs in the java script discussion area. Your post has nothing to do with asp.net.
|
|
|
|
|
Hi,
i have a website and I showing external news on my website (links to news from other websites).
I want to ask... ranking wise, is it better to display the link as its original url on my news page or show as goto.aspx?URL then the goto.aspx will redirect to that page?
what's your advise?
|
|
|
|
|
Original URL.
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
why not use
<a href="http://www.target/com/" target="_blank">link</a> ?
|
|
|
|
|
I am using the Asp.net system.diagnostics.process to command line execution of executable file
To execute the for(eg:eRegistortool.exe ) with arguments for reading the media file information
1. Argument eg(C:\document and settings\0100808\ desktop\sample.jpg)
Problem:
The file cannot open return the error 000005 access denied error
Note:
when the executing the file via visual studio the problem not produce,
Please give me resolution for solve this problem
|
|
|
|
|
RajavelK wrote: Problem:
The file cannot open return the error 000005 access denied error
Using IIS? In that case, your app will not be running under a standard-user account; the ASP.NET account is limited in it's rights.
RajavelK wrote: when the executing the file via visual studio the problem not produce
In which case "you" are the logged in user, and the app will be running with your permissions.
RajavelK wrote: Please give me resolution for solve this problem
Change the permission.
Why are you trying to launch a picture on the server?
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
value was either too large or too small for an int32. how can i solve this ,when i converting to int?
|
|
|
|
|
Make sure the value is not too large or too small. Maybe you should think about what you are trying to do here and explain the problem in better detail.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
You cannot convert it into int. The maximum value of an int is 2,147,483,647.
Alternatively, if needed, try using UInt (4,294,967,295) or long (9,223,372,036,854,775,807).
|
|
|
|
|
Hi,
i'm using a AJAX SlideShowExtender. i'm having a multiline textbox for commenting images by clicking stop button(so that it will save for that image). Now i want to get the details of comments to be displayed(if comments already saved) during the slideshow automatically. Anyone have idea plz let me Know.
thanks in advance.....
|
|
|
|
|
hi to all,
any one give the solution to me,normally grid view contents displays and expand in row-wise.i need how to display the grid content and expand in column-wise.
M.Saravanakumar
SunArk-GmbH.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
