|
I'm developing a web application where a client registers himself and after that i want to create a database by using an existing template database from the server on the same server or another but with a differnt database name for example :Template db name - prodb
then new database name will be if the user name is "ng" then the database name will be
"ng_prodb"
i'm using c# as server side script, and SQL server 2000 is the database,please sugges me how can i achieve this..
Thanking you in advance
Regards
Nitin P.
|
|
|
|
|
Gosh... this sounds like an incredibly inefficient way of doing things! Why not simply put all the user data in the one database and add a UserID field to your table(s) as appropriate, along with a separate table of these UserID's and logins etc?
However... if you really want... you can use SQLServer itself to generate a SQL script for creating the template database, and then use that script to build up a new one whenever you want it, amending the db name as needed. Remember to include all your permissions etc in your script. Then execute that script against your db connection. eg:
dbConn.Execute "CREATE DATABASE...etc"
cheers
Phil
|
|
|
|
|
of course, you will need to be logged in with database adminstrator priveleges to do this, and if you are trying to do it on a public webserver you probably won't have this. I would really suggest you find a more efficient solution to your needs.
Phil
|
|
|
|
|
Actualy the template database may be modified in the future so i wanted it to to be dynamically done. Regarding your doubt about creating new database for each user is - its a an ERP solutions so each customer needs to have differnet database according to clien't requirement, its just to setup initialized information.
|
|
|
|
|
Dears All
Thats my first question I am posting, i dont know if this is the right place to post it or not, so sorry if its not
I am actually jst using the web browser control in order to parse the html source code.
so far everything works fine, but there is something very simple irritating me
I have created the IE window and managed to make it display web pages, but my scroll bar does not work !!! although it is shown it does not do anything
m_webBrowser.Navigate(urlAddress, NULL, NULL, NULL, NULL);
m_webBrowser.EnableScrollBarCtrl(1, TRUE);
Please can any one tell me how to make the scrollbar work because its really bothering me 
Thank you
Adam
|
|
|
|
|
Just a question
Does your document have enough text and BR's to cause your scrollbars to enable themselves??
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
|
Yes it does.
Do i have to set the scrollbar to scroll manually or does it set itself automatically !!!
I have tried different websites but i still cant make the scrolbar work although its showing,
Any ideas are very welcome
thanx 4 the help
Adam
|
|
|
|
|
I'm confused and hope someone can enlighten me.
I have successfully programmatically set up a "Shared Folder" on one computer. I want to access that folder and retrieve files from that folder, but do it from another computer. Both computers are connected to the Internet. It was my understanding that I could reference a file on the "other" computer with something like
"\\123.21.105.6\SharedFolder\Test.txt"
and that I could access it (from my C++ program)with something like:
FILE* theFile;
theFile = fopen("\\123.21.105.6\SharedFolder\Test.txt", "r");
But that doesn't work. It never succeeds in openning the file.
I've been looking all over the internet for information on how to do it correctly but I'm only getting more and more confused.
My impression (now) is that the above approach is wrong, and that there needs to be some kind of server running on the target computer and that I have to communicate with that server in order to retrieve the desired file, or that I have to use some kind of file transfer protocol (ftp?) in order to do it.
What I really need is some straightforward explanation or (ideally) actual C++ code that says, "you've got a file on another computer's shared folder, here's how to get it..."
But the best that I've come across are things like, "here's 100,000 lines of code, with 2,586 classes, and somewhere in there is the way to access files on another computer, have fun figuring out how."
Any help/advice on this would be greatly appreciated.
Roger Garrett
|
|
|
|
|
Windows file sharing protocol is normally blocked by routers, so it can be used only between computers on the same LAN. You could setup a VPN between the machines to allow file sharing to work.
|
|
|
|
|
I am trying to figure out how to give the User the opportunity to identify an Excel file on their Client PC so that I can then open it up programatically within my ASP.NET Webforms Application.
So far everything that I have tried always shows me the directory structure on the Server instead of the Client.
Am I missing something really obvious here?
|
|
|
|
|
well... I would use a File Upload routine and simply note the filename w/o actually uplaoding the file, if I wanted to do something else with it. A good and simple implementation of File Upload can be found on the excellent http://www.metabuilders.com[^] resource.
cheers
Phil
|
|
|
|
|
I want to navigate the whole web page with the next and previous buttons. My data is scattered all over the page and so its not fixed at a particular position there by limiting me to use the Datalist, DataGrid or repeater controls. So how can I enable paging in the entire Web Form. I wish I could attach a file to show you what I mean. Please write your e-mail address so that I can attach an image of the web form i am talking about.
|
|
|
|
|
I'm using IIS 5.1 on a windows XP box and I am trying to access files in a folder on another machine in my domain. I am using visual studio 2003 and created a asp.net web aplication using visual basic. I have a simple button that calls a DIR command so see if a file exists. If I do this to a local file it returns the file name and everything is ok. If I try to find a file in \\Fileserver1\Data1\test.txt which I know exists it retuns blank (not found). I tried using anonymous access and putting in a user and password who is a domain admin to try to avoid rights issues. I've also tried basic authentication and put in a user who is a domain admin and I still cann't see the file. Is this just not possible because of the hashing of the password? My ultimate goal is to access FoxPro tables that reside on fileserver1. Any advice would be great even if it is this cann't be done.
|
|
|
|
|
|
you are corret. Asp.net uses the ASPNET user by default no matter what the anonymous user account is. This ASPNET user is autocreated by .net setup and has an autogenerated password. It is a local account. If you wish to change the password or changed the user asp.net uses you need to edit the machine.config file in the C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\CONFIG subfolder. Look for the "
|
|
|
|
|
<script type="text/javascript">
<!--
var now = new Date();
var year = now.getYear();
document.write(year);
//-->
</script>
If I put this code following ©, should it not write '2005'? In IE it does, but it writes '105' in Firefox, NS (except 8beta), and Opera.
Thanks!
|
|
|
|
|
try getFullYear().
p.s FF, NS and Opera seems to do it quite right ("getYear() Returns the year of a Date object (from 0-99). Use getFullYear instead !!" W3 Schools[^] )
David
"Stay Kul And Happy" I.A.
|
|
|
|
|
hi
i want to use java script files to store data in client computer
like google's gmail mechanism for auto complete and speed matter.
but i don't know how i can hide this file(which containes user data) from
hackers just like gmail(i can't find gmail data in my computer and i can't save gmail page correctly to see my data stored in some files!)
how gmail does it? and how i can prevent jscript file saving request from user?
i'm wating
thanks
|
|
|
|
|
Actually, that isn't the way it works. Gmail stores the user data on their end and passes it along with the web page.
Javascript can't store data on the client's computer. It can if you run the script locally, but the activeX component which does it is disabled if you run it off a web server (this is a security measure Microsoft put in place).
What I would do is create a database of user information on your site and pass the necessary information in as metadata with the page. It is much more secure and a whole lot easier to deal with. Besides, the user can get his/her information on your site without having to be on the same computer each time.
|
|
|
|
|
hi JKroschel
thanx to your reply
i have a sample that shows how javascript files can store data on clinet computer(data can be stored in array structure and can be retrived in html pages by refrencing array).this sample works great and excactly like gmail's address book match finder script.if u want i can send this sample to u.but my problem is that i can't find out how gmail hides user data(js files) from unauthorized users in clineet computer.
i become so glad to talk on this subject to u.
bye
|
|
|
|
|
JKroschel wrote:
Actually, that isn't the way it works. Gmail stores the user data on their end and passes it along with the web page.
I agree. It may seem very fast because it uses xmlhttprequest to get the data from the server, without reloading the page, with javascript. Read up on the newly coined phrase "AJAX". or try this one:
http://www.softwareas.com/ajax-patterns
...think concepts, teach to learn...
|
|
|
|
|
I guess I stand corrected. I'd love to see the code that can do that...Could you post it?
In any case, it will still be more efficient if you store the users' data on your server so the user can work with his or her information on multiple computers. This is also more secure because then you don't need to worry about other people getting access to someone else's information, which sounds like the problem you are trying to fix.
|
|
|
|
|
hi
i will post my sample to your mail to see what i mean.
thanks
|
|
|
|
|
hi
i will post my sample to your mail to see what i mean.
my mail is hassan.azizi@gmail.com ,pls send your mail address to me.
thanks
|
|
|
|
|
Sorry in advance if it is the right forum for this quetion or not?.
I want to ask where in registry the values of IE settings are placed.I want to know the path.Do help.
Thanks.
Be FaithFull To Your Work.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
