|
Using ASP.Net, C# and mssql, I have created a dataset which is displayed to the user in textboxes. How can I update the dataset and upload the dataset back into the database after the user has modified the textboxes and clicks a button to update the information?
|
|
|
|
|
Update the post back changes for each rows from the textboxes to your dataset
and then use the following code to update the changes to database
OleDbDataAdapter dataAdapter=New OleDbDataAdapter();
OleDbCommandBuilder builder;
dataAdapter = new OleDbDataAdapter("SELECT * FROM" + tableName;, conn);
builder = new OleDbCommandBuilder(dataAdapter);
dataAdapter.UpdateCommand = builder.GetUpdateCommand();
dataadapter.Update(updatedDataSet);
dataAdapter.Dispose();
|
|
|
|
|
hi all,
i need help about how to make my web site reads a different language like (arabic) cuz all it gives me just give me question marks instead of the proper characters
|
|
|
|
|
|
I have a base page class (BasePage) that all pages on my site inherit.
I also have a database abstraction class (DBClass) that I use to handle all interaction with my database. I have it set up so that when you create an instance of DBClass, it creates a connection to the database, and then all methods on that instance of DBClass use that connection to interact with the database.
So, my idea was to create a public property DB of BasePage that is an instance of DBClass. That way, the database connection will be open and available when the page is loaded and I should be able to make use of it for any calls to the database I might want when loading page content.
So far so good (although if you see any problems with the logic so far, please let me know).
However, now I have the following issue: I have a User Control defined on the page that has to make use of the database. I don't want to create a *new* instance of DBClass inside that user control; it seems like it would be better to just use the public property DB of the main page, that was already created.
But I can't figure out how to reference the page property DB from inside the user control.
Any help or insight would be greatly appreciated.
------G
|
|
|
|
|
Cast the Page property to BasePage.
---
b { font-weight: normal; }
|
|
|
|
|
I'm sorry if I'm being stupid, but could you walk me through that?
For example, I have tried this:
Public Class TitleControl : Inherits UserControl
Public Page as BasePage
Public Sub Page_Load(Source as Object, E as EventArgs)
Initialize(Page.DB)
End Sub
Public Sub Initialize(SourceDB as DBClass)
...
End Sub
End Class
And the compiler stops at "Initialize(Page.DB)" and says:
System.NullReferenceException: Object reference not set to an instance of an object.
However, the DB property of the page SHOULD be set to an instance of DBClass, since I do that in the Load() event handler of the BasePage class. And if I understand correctly, the Load() of a page happens before the Load() of the controls inside the page.
I'm probably doing the re-casting wrong, since Im' just guessing at the syntax for that.
Thanks for your help!
-----G
|
|
|
|
|
After Public Page as BasePage declaration Page is Nothing or null
You can't access Page.DB if Page is Nothing or null and System.NullReferenceException is thrown
|
|
|
|
|
The control has a property named Page. If you declare a variable with the same name, that will override the property. As you never assign any value to your variable, it will always be null.
Just use the property, and cast it to the class BasePage:
((BasePage)Page).DB
---
b { font-weight: normal; }
|
|
|
|
|
I have a class that uses string builder which produces a email body that is sent out by the system. My problem is that when i receive the email, random "! " characters are inserted into the text. If anyone out there has seen this problem before, let me know.
IM NEED A SOLUTION FAST
|
|
|
|
|
For additional information, i place a bunch of vbCRLF after every line and still end up with these random "!" and spaces.
Im also aware of projects migrating from IIS 5 to IIS 6 creates this problem. How can i fix it now
|
|
|
|
|
HI guys I have a bit of a challenging question for you one that has had me stumped for the last couple of days.
I'll give you concept behind this.
I am working on a system that is used within a hospital, and the situation I am currently working on kind of goes like this.
A patient may be able to visit a variety of doctors during the course of a treatment, Diagnosis etc .i.e Cancer patient.
Now lets say that all these doctors give a patient a document to read regarding the diagnosis results etc. Now if each doctor gave the patient the patient a piece of paper this is bound to get lost. So a posible solution to this dilema is that each department already has a "Standard" document that try give to patients with Dietary advice and some Tailored advice that give to the patient etc.
These documents are now currently kept as Word Documents on the Hospital network, but as you would expect with large systems these are scattered on various locations on the network. Before you suggest saving the Docs to the database, we can't do this as they still want the ability to update the documents without having to save them to a DB. I can get round this by storing virtual paths in a DB. Not desirable but works.
The proposed solution is to try and Merge all these documents into one Document on the server and print it out for the patient at the end of his examination.
The issue that I have is that as per MS you cant install and automate word on the server
http://support.microsoft.com/kb/257757
So I can't have word on the server. Secondly we have a myriad of different versions of word on the network, and not one of them is Word 2003, hence no XML.
Thirdly the client cannot afford to pay for the purchase of third party software i.e Soft artisans office writer.
How am I going to solve this problem? So far all possible solutions I have tried are failing and I am looking for any other possible solutions.
A bit of an Code Project Brain storming!!
"a fool will not learn from a wise man, but a wise man will learn from a fool"
"It is hard to fail, but it is worse never to have tried to succeed." - Theodore Roosevelt
"Success is going from failure to failure without losing your enthusiasm." - Winston Churchill
My Website || My Blog
|
|
|
|
|
Microsoft does not recommend, however it is possible to word automation.
Option 1) Server side Office Automation. If you do not want the server to be impacted by server side office automation memory leaks, bugs, reset & restart issues then you can always designate a separate computer that provides document merging service as a COM+ service.
Option 2) Use Windows Sharepoint
|
|
|
|
|
Thanks for the replies, But Installing word on the server is not an option, I know it's possible to use word automation, but MS will not support the server once they have find out Word is installed on the server, Installing word on another server and using remotingg, would require word to be installed on a server, so in effect still having word on a server, Question is would a Admin want Office installed on any of his servers, knowing thier could be a potential security threat on that server?
Using Sharepoint is not an option either as this would be telling the clinet they would need to install/Licence Sharepoint on thier server.
"a fool will not learn from a wise man, but a wise man will learn from a fool"
"It is hard to fail, but it is worse never to have tried to succeed." - Theodore Roosevelt
"Success is going from failure to failure without losing your enthusiasm." - Winston Churchill
My Website || My Blog
|
|
|
|
|
How can I dynamically determine which environment my code is running in? For instance I would like for my apps to dynamically determine if they need to use the DEV connection strings or Production connection strings (within my DAL).
By doing so I would avoid having to manually edit connection strings every time I make changes to my app. Appreciate your help.
|
|
|
|
|
Why don't you have a web.config for dev, and another one for production?
|
|
|
|
|
I am not sure if that would work because when we will publish the website the development copy of web.config will be promoted to production
Or am I missing something?
Thanks for your help.
|
|
|
|
|
Don't publish the web.config. That's how we all do it.
|
|
|
|
|
hi
i have a strange problem with OutPut cache working fine on development box and not working on production server
background : @outputCahce directive is fine, but wanted to make centralized output cache , so i have some setting section in web config defining what page and how to cache
and in my Base Page i having following :
<br />
Response.Cache.VaryByParams["*"] = true;
DateTime expires = DateTime.Now.AddSeconds(duration ); <br />
Response.Cache.SetExpires(expires );
Response.Cache.SetValidUntilExpires(true);
Response.Cache.SetCacheability(HttpCacheability.ServerAndPrivate );
The problem is that on local machine it works fine: you load page, hit f5 or Ctrl+F5, and you see the server-cached version
on server it other : you see that browser do caching , but F5 will bring you fresh, not-cached by server page
used time-span printed with response.write on test pages
and i sure that caching block is working, i write to log to ensure that some page added to cache
done with ASP.Net 1.1 running IIS5 on dev and IIS6 on production
Web has many resources on output caching but i not found any solution for this
Any ideas guys ?
Thanks Much
EV
###
|
|
|
|
|
Hi,
I want to include a .js file only for one particular page which is using master page. Since the .js file is very large and only for this particular page, I don't want to include it in Master page. Because it will add into every page that is using the master page.
Also, I dont' want to convert all the functions in .js file into string to register through RegisterClientScriptEvent, again, because the functions are too long to convert.
Is there a way to do it by NOT using the ways mentioned above?
Any help would be appreciated!
Thanks!
|
|
|
|
|
Add the tag to the Page.Header.Controls collections. I don't think that there is a class for the script tag, so you have to use HtmlGenericControl to make one.
---
b { font-weight: normal; }
|
|
|
|
|
try ClientScriptManager.RegisterClientScriptInclude.
|
|
|
|
|
I did use RegisterClientScriptInclude to make it work.
But I try to pass Form1 into Javascript function , it won't let me do it. Note, Form1 is form from master page.
Any idea?
Thanks!
|
|
|
|
|
vicky457 wrote: But I try to pass Form1 into Javascript function , it won't let me do it.
What code do you use to try that?
What do you mean by "won't let me"? What error message do you get?
---
b { font-weight: normal; }
|
|
|
|
|
Guys, I have this javascript function
function validate()
{
form_intranet.login_username.value = form_intranet.txt_user.value;
form_intranet.secretkey.value = form_intranet.txt_password.value;
form_intranet.action = "http://aaa.bbb.ccc.ddd/webmail/src/redirect.php";
form_intranet.submit();
}
i want a server side process who have the same behavior... 
Thanks
<div class="ForumSig">keep Learning and you never will be out of date...</div>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
