Is it possible to make a sql connection in the master-file for my asp.net website, that all included sites have the connection too? Like when I include a header-file in asp classig.
View 1 RepliesI have an ms access db file and now i want to use it in my app. i have given like
Provider=MSDASQL.1;Password=pwd123;Persist Security Info=True;User ID=swgp;Data Source=SWGP;Initial Catalog=C:swgp BJswgp
but it is giving error to me.If anybody know how to give this connection string for password enabled ms access database,
I am using this connection string to query some .DBF .
[Code]....
How can i make it work?
I have this in the web config file <connectionstrings> section. Why is there an add and then remove and then again an add...what is it trying to accomplish here? and in the second code section, I use that string in a sqldatasource control. Second question: Can I just use the name attribute value "localsqlserver" form web config file, in place of the connection string in the data source? is it why that attribute is for?
[Code]....
My requirement is to save the connection string of database that will be provided to be me by user on form, which can be modified lator.
i need to know how and where i should store the connection string permanently which will be used lator to connect to database.
I have written the web.config for same server without username and server and its working.
but not been able to provide the username and password in web.config file.
Following is my web.config for Server:
[Code]....
I have to write another web.config for client application with username and passoword. how could i use it.
server name is "BM", User is "Sa" and Password is "abc"
I would like to use both of the connection strings in the same web.config file how can I do this I tried this yesterday it worked I called it a night, then this morning I got this. The error being on line: 10 Parser Error Message: The entry 'ApplicationServices' has already been added.
Line 8: <add name="ApplicationServices"
Line 9: connectionString="Data Source=Mysource;Initial Catalog=travelatlantic;User ID=MyID; Password=MyPassword;" />
Line 10: <add name="ApplicationServices"
Line 11: connectionString="Data Source=MySource;Initial Catalog=travelatlantic2;User ID=Myid; Password=MyPassword;" />
Line 12: </connectionStrings>
just for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
[Code]...
i tired this but its giving error
[Code]....
Iam trying to make a socket connection and am facing with the following error.
Socket tempSocket =new
Socket(ipe.AddressFamily,
SocketType.Stream,
ProtocolType.Tcp);
The tempSocket is connected to the particular IP and tempSocket.Connected is giving me value as True. But the property MultiCastLoopBack property is giving me the following error with error code 10042.
"An unknown, invalid, or unsupported option or level was specified in a getsockopt or setsockopt call."
So is there any problem with the IP or Tcp is not supported with Stream as SocketType?
When I open an ASP.NET 3.5 project using VWD2010, I get a prompt error message,"The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place."however, my project works successfully.
View 1 Replieshow make the class for database activities and it can be used in code behind
coz i want avoid the connection opening, closing activities, insert,update etc methods in code behind frequently.
the class should include connection open and closing method, passing values to stored procedures etc.
How should we construct it?
When I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[code]...
I am working on masterPage/sub masterpages, all worked fine until this morning.When I open a .aspx which uses masterpages, in the design view it shows the error message..
I've checked both master pages several times, all tags are matched and visual stuido itself doesn't indicate any errors. Also in debug mode the html page is generated without any problems..
My computer system froze on me, the mouse froze, cntrl-alt-del, did nothing, so I reset it. Did a disk check, and now everything seems fine except for my master Page html code which I was in the middle of editing when it happened. The VB code-behind file is still ok, the designer file still shows ok with all of the controls in it, but I can't get into desgn or source view. It just opens and gives a whole page of hesixecimal code such as as:
00000030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00000040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
It just gives me a whole page full of numbers like this. I haven't backed up for a few weeks and so I hope I can get this back.
I receive the following error, when trying to consume Wcf service:
"An existing connection was forcibly closed by the remote host". Consuming the service works fine when the host and the client are on the same machine. When I move the client to Hyper-V virtual machine (I didn't try it on a real computer) - it throws the error. Both firewalls are turned off Do you know what can cause such behaviour? Here are the details:
Both the client (hyper-v) and the service are on Windows server 2008 R2
Service url - http://wcftest/CalculatorService.svc (wcftest is the website and is mapped in the hosts file to localhost)
Service config:
[Code]....
Client config:
[Code]....
Are there any configuration settings which I'm missing?
If I m using Windows Auth in my connectionstring i.e Integrated Security = SSPI / Trusted_Connection = Yes,
Is there any way to retrieve the USERID that is being used to make connection?
I want to setup a DB connection from aspx page and not from aspx.vb.
View 1 Replies I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.
I have database called PhoneDirectory.
It have only one table named Residents.
I have button wiht ID="Button1".
I want when i click this button to see all of my residents.
I want to see the result in DetailsView and to be able to edin, delete and add new resident.
First try with SqlDataSource so i wrote this:
<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"
have developed a Asp.net application which uploads data from Excell Sheet and then Inserts those data after doing several Checks to the Mysql data base.The Issue which Iam facing is that when Iam uplading lage amount of data at a time say around that 10000, the application crashes and gives the Unable to Open connection to server Error.The same app works well 1000-2000 data.
View 1 RepliesHow to make a connection between a word in the cell (href)?and a rule of the same or another table with sql. Is there also finished editors?
View 3 RepliesHow to make a configuration page using c# asp? Want to read from the webconfig file and edit.
View 5 RepliesHow can i get ConnectionString In web.Config when you are in DAL(data access layer)Some said it should me in <appSetting> but i think this is not appropriate to do because web.config have dedicate tag for connection strings.i am creating a 3 tier each layers is a project in 1 solution
Project ://solution
|_View :WebApp // Dependence (BLL,ENTITY )
|_BLL : ClassLib // Dependence (DAL,ENTITY )
|_DAL : ClassLib // Dependence (ENTITY )
|_ENTITY : ClassLib //note this is not a layes just a central data object reference
I have created a website (VB) on my local host. A couple of pages on this website use gridviews or detailsviews with an AccessDataSource connection to a MS Access database. This works perfectly. But now I want to move this website to a hosting provider. And on this hosting provider my website works well but not the pages with a connection to the Access database. I searched the whole internet for a solution but I didn't found it.
Folder structure on the host:
- db > Access databases (name: testdemo.mdb)
- logs
-wwwroot > website (for example, the gridview is placed on index.aspx).
I think AccessDataSource didn't work, but what kind of code may I use in the index.aspx and web.config? My hosting provider said only, use a direct link to the database and not a relative, for example: E:xxx.comdb estdemo.mdb
I have created a ASP.NET 4 application in VS 2010 using Silverlight and RIA Services.
After finishing the first release on my development pc, I'm starting some deployment testing in a server in my local network.
After sucessfully published the web application using the Visual Studio FTP publishing option, I notice two strange things:
1 - On the IIS properties of the website I have uploaded my files to, you can see now a connection string, named as LocalSqlServer that points to the aspnetdb.mdf database file. I had a look in the web.config file and I could not find this connection strind defined there. So, where is it located? Where did IIs got it from?
2 - As the aspnetdb.mdf file is not deployed withtin the web application and I a musing SQL express in my testing server, where can I drop the mdf and ldf files so they can be attached when the applicaiton runs? I know I can perform an attach operation using management studio,but I'm wandering where is the DataDirectory folder ASP.NET looks for to attach it at runtime?
i have done a project using ASP.NET and SQL database...and it's working good.but everytime i run the project in other computers i need to set connection path to database.without set connection how to run the project.using "App Path"? please let me how to set App Path in ASP.NET PROJECT.
View 2 Replies