|
|
Hello,
The application was developed in .NET and SQL 2005. Originally, we'd thought that it'd be a web-based application (i.e. the SQL database will be hosted by us and users can connect to it).
But some clients want the database to be hosted on their computer itself. Of course the application needs the database to run, however, by putting the database on the client's machine we will lose control of our data.
I cannot find an easy way that SQL provides to allow only the application to access the data, but not humans.
Nothing is altered in the database--we are simply reading data from the SQL table, so should we explore other things (indexed flat files?) to make this into a software product without losing control over the data?
G. Satish
|
|
|
|
|
|
How complex are your queries? If you don't need stored procedures or sub-queries then you could use SQL Compact Edition and encrypt the database. You would need to encrypt the connection string in your app config during the install.
|
|
|
|
|
Hi all,
After sending an email from asp.net i got the following error message
"the remote name could not be resolved"
If anyone knows about this error ,pls help me
Thanks
Denny
|
|
|
|
|
The Domain name in the Sending mail is wrong or the credentials for the domain are not correct..!
You have enter the correct smtp domain..!
<br />
SmtpClient ssd=new SmtpClient(DomainName,port);
Permission Problem..!
May be thts the problem
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Hi
Is there any ways to set the .Net version in IIS through some scripts like Batch file etc?
Thanks
|
|
|
|
|
You can use the aspnet_regiis batch file from the version of .NET that you wish to set in IIS. It would register ASP.NET from that version of .NET as the default version for your IIS.
|
|
|
|
|
Yeah i did try this out before i post it but it throws an error
Coommand:-
C:\WINDOWS\Microsoft.NET\Framework\v4.0.20506>aspnet_regiis.exe -s "E:\App path\Apps\Azure\SQL_Azure\SQLServerApp"
Error Message:-
Installation stopped because the specified path (E:\App path\Apps\Azure\SQL_Azure\SQLServerApp) is invalid.
The path is exactly what i see in IIS local path.
Thanks
|
|
|
|
|
I made it
C:\WINDOWS\Microsoft.NET\Framework\v4.0.20506>aspnet_regiis.exe -sn "W3SVC/1/ROOT/SQLAzureApp"
SQLAzureApp - the virtual path
Thanks
|
|
|
|
|
Refer the aspnet_regiis documentation here[^]
At the fag end you will notice this NOTE
From MSDN: Note
The path parameter refers to the root path of the application, not the physical path. For example, W3SVC/1/ROOT/SampleApp1.
The Examples section just below will help you accomplish the task!
HTH!
|
|
|
|
|
I am trying to implement multiple dropdown lists with Access Database.
It is like this- I have a dropdown list which takes data of all users from one column in the database and shows them in the dropdown list. Then based on which user is selected, the dropdown list needs to dynamically change its contents to show the tasks related to that user and from this selection of tasks, another dropdown list needs to dynamically change itself to show the actions for that user, and that particular task.
I have not done much coding here since I have added an access datasource and generated the contents from the database into the 1st list but i am not able to take the output from that list and give it as an input to the second list and so on. I have to do it in C# and this is a web application and I am not able to figure it out.
Any help is appreciated.
SJ.
|
|
|
|
|
Use AJAX drop downlists like Cascading Drop Down Lists it will solve your problem. You dont have to do
much coding also. Google for the samples with Cascading Drop Down Lists.
Let me know you got it or not.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
hey abdul, thanks for your reply. I did try googling that all day to find something that i can do on my own and not ask anything for help, i never ask for help unless there is no other way but this time i had to ask for help. i am not supposed to be using AJAX and moreover i have no clue abt AJAX.i thought the solution to my problem looks pretty simple but i dont seem to be able to figure it out.
|
|
|
|
|
If there is no restriction to use AJAX then use it. Because these CDDLists are very usefull.Because the next Dropdown will be loaded withoug postback. So it looks like smart navigation. I suggest you to use it. The name AJAX looks very complicated but is very simple.
I could have provided you code sample, but if I give some part of it, u feel difficulty in understanding it. So google for CDDLists samples and understad. It will solve all your problems of postback everytime.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
|
This is not an ASP.NET related question. Please read the forum guidelines and choose the appropriate forum, like Silverlight
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
|
Hi All,
I am new for .Net 3.x versions and silverlight. When I have silverlight installed on my machine.
I am getting Silverlight templates in (File->new project) and (File->new web) site also.
What is the difference between these two in .net 3.5.
In earlier versions of .Net, Project was considered as Windows App and Web site was considered as ASP.Net application. But in 3.5 when I open the new project also. It is asking me two options related to ASP.Net only. Why is this so. Whats is the use of it.
Please help me any link is also very much helpfull for me as I have to learn please.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
|
|
There sure is a lot of info on how to move information from a table column to a listbox. But nothing, so far, on how to go from a listbox to a table.
I have a master record where I record the primary key of various secondary tables. This is a data base of zoning requirements for various building types. the various tables list legal setbacks, minimum building size, maximum building height, etc. It is a relational database where I can name a building type- store, church, etc.- and get out its requirements.
But I have to get the primary keys of the various tablesinto this master table first before I can get the requirements for a building type out of the data base.
It seems to me the easy way is to have a listbox, or some such thing, display the various choices of heights, acceptable building areas, maximum building heights and then let the data collector make a selection and see the index number written in the proper field on the master record. The listbox or whatever has to show the complete record so the data collector knows what the index number represents.
But I can't find anything that describes how to do this.
Maybe somebody knows where this process is written up already.
|
|
|
|
|
mhh112 wrote: Maybe somebody knows where this process is written up already.
What more do you need? You query the database given certain criteria and get a resultset back. That has been very well documented.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi,
I 'm populating the images in the listview control from the database.... but now i want to get only broken images from the server(eg images which are not showing, cross box) so my user can fix those images in the server. I want to put a checkbox in the search criteria so either they can see all the images from the table or only broken images.
Is there any way of doing that from asp.net or with javascript.
Any help will be appreciated.
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
