|
<add name="ConnectionString" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|database.mdf;User Instance=true"/>
That's it. I don't know how else to go about doing this. I have MS SQL database support on my hosting, I just don't know how to get it all working. Right now the database is just in the app_data folder.
|
|
|
|
|
Is your SQL Server database in the App_Data folder of the web application.
You are using Windows Authentication to connect with SQL Server dataqbase.
The ASP.NET application will run under Network Service account in the server. Therefore you need to provide access to the Network Service account to your database.
|
|
|
|
|
I'm completely confused. I'm new at this whole thing, what do I need to do, in detail, to get it to work?
Basically I am running on a server that I do not own, I just host there. It has Plesk control panel on it, and it allows me to create MS SQL databases and such. No idea.
|
|
|
|
|
If the server allows you to create SQL Server database,
Which connection details are you using?
The same connection details should be put your web.config file.
|
|
|
|
|
I don't have any connection details, I have a Plesk control panel, that allows me to create either an MS SQL database, or a MySQL database, all I know is that you create a database, in my case it would be erik_database, and a username, in my case I created it to be simply aspadmin, and that's it.
|
|
|
|
|
I assume that you have used SQL Server database in your application.
How do you create SQL server database in the server. Using SQL Management Studio?. if so, then you can see the server name, database name and also you need to enter password.
Assume that erik_database is name of the SQL database and aspadmin is the user name, 'YourServerName' is the server name, 'YourPassword' is the password to be used connect with database, then connection string in your web.config should be as below
<add name="connectionString" connectionString="Database=erik_database;server=YourServerName;Uid=aspadmin;pwd=YourPassowrd" providerName="System.Data.SqlClient"/>
modified on Sunday, May 31, 2009 11:04 AM
|
|
|
|
|
What is the common port for a MS SQL server?
|
|
|
|
|
|
I got my apps to connect, but now it's strange because every time I go to my site a username and password dialog shows up, and I can't even login. Odd.
|
|
|
|
|
Hello,
I'm working on a simple ASP .NET health checker and I've run into a few obstacles.
1) I need to be able to get the full non-paged memory usage from a remote machine (on same network). I've tried using System.Diganostics.Process.NonpagedSystemMemorySize64 however I've come to realize that the kernel's nonpaged usage is going to be missing from that total. Here is a quick sample of what I was doing:
Process[] myprocess = Process.GetProcesses("computername");
foreach (Process p in myprocess)
{
nonpaged += p.NonpagedSystemMemorySize64
}
2) I can overcome that locally by using System.Diagnostics.PerformanceCounter however you can only access the API for that class locally. Is there another class that would suit my needs?
Any help would be appreciated.
|
|
|
|
|
can anyone tell me when to use state server outprocess session and sql server out process session? and also give me some real time scenarios for both of them?
rajesh sunakri
|
|
|
|
|
State server session and SQL Serevr session are useful when you deploy your application in web Garden or Web Farm environment.
Web garden is a scenario in which a single server machine has multiple aspnet worker processes running simultaneously. The server should have multiple processor.
Web Farm is a method of hosting a web site in a cluster of servers. The web request to the web application will be handled by multiple servers.
StateServer is faster than SqlServer session. But SQL Server is more reliable and used for mission critical applications.
Check this link[^]
|
|
|
|
|
Hi Guys,
I have a web page with many controls in ASP.NET and I am showing records to these controls from database.
Now what I am trying to do is I want to create same page with same controls but this new page should be open as a tab page.
Could you please provide me any link or source code which can help me out?
(I am trying to create a TAB page with same controls)
Thanks,
|
|
|
|
|
u can use ajax or some javascript framework like jquery.
if u need more info tell me!
|
|
|
|
|
Use Ajax Tab control.
Look into this[^]
|
|
|
|
|
In my web application I have a webservice. I'm using this webservice inside this web application. The mode of customError (in web.config) is set to "On". This prevent from me to get detailed exception in client (javascript). My webmethod defined as scriptmethod too. If I turn customError off I start getting the detailed exception. I need to keep stay with customError set to "On", but get detailed exception from webservice instead of general exception with this message: "There was an error processing the request".
Thanks.
|
|
|
|
|
Anyone have an answer for this, I have the same issue.
With customError set to On or RemoteOnly:
When the webservice method throws an error with a detailed error message, then on the error return to javascript, results.get_message() shows the generic message "There was an error processing the request", not the detailed error message.
With customError set to Off:
When the webservice method throws an error with a detailed error message, then on the error return to javascript, results.get_message()shows the detailed error message.
I want the customError to be set to RemoteOnly, but I also want get_message() to have the detailed error message, not the generic one.
Any thoughts, fixes, workarounds would be greatly appreciated.
|
|
|
|
|
Create a new folder and move there your asmx file (the asmx.cs/asmx.vb will stay in app_code folder). Add a new web.config to your new folder by "Add new item... -> Web Configuration file". Your new web.config will be almost empty. Add a "customError" element as you did it in your main web.config and set it to Off.
That's all.
|
|
|
|
|
perfect. thanks for replying!
|
|
|
|
|
hi:
how can i change the default path (aspnet_client/system_web/2_0_50727....)
for the images and css in the toolbar inside the CrystalReportViewr.
what i want, is to put all those files inside my application.
thank you
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
|
thank you
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Hi, I am trying to make a spreadsheet in asp.net wherein, the user can enter some data and I display results for one of my methods( say Average, Standard deviation etc,). Can anybody please guide me how I read data from spreadsheet at runtime & then pass these data as parameter to my methods.
e.g
public static double Sum( double [] data)
{
double sum =0.0;
for(int i=0;i
|
|
|
|
|
you can edit like this,
double d = 0;
GridView1.Rows[0].Cells[1].Text = "22.7";
d = Convert.ToDouble( GridView1.Rows[0].Cells[1].Text);
Now call sum function.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
