i have some websites and one part of all websites is the same and it work with dataset i got an ide to creat a code projrct to handel that part and i use it in all websites the problem is the websites not use the same connectionstring but the connectionstring name can be same. i need to set this code project to read the connectiostring from the website web.config file.
View 6 RepliesWhen I turn on Code Coverage in my test settings, on a project that references the Unity DI container I get the following error:
Cannot initialize the ASP.NET project'{Project Name}'.
The event log specifies the following reason:
Could not load file or assembly 'Microsoft.Practices.Unity, Version=2.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name signature could not be verified.
SqlConnection conn = new SqlConnection("Persist Security Info=True;Data Source="+txtdatasource.Text+";database="+txtDBName.Text+"; User ID="+txtDBUsername.Text+";password="+txtDBPass.Text);
conn.Open();
SqlCommand cmd =new SqlCommand("SELECT [ItemCode],[ClientDescription] FROM ["+txtDBName.Text+"].[dbo].[Bookings]");
cmd.ExecuteNonQuery();
This gets the folowing error ExecuteNonQuery: Connection property has not been initialized. i know it connects to the database
I'm creating a multi-tenant Asp.Net MVC 3 Web app, and using EF4.1 code first for the db model.For development I'm happy to use SqlServerCE in App_Data, and for production this will move to Sql Server 2008.
Say my context is called "MyModels", by default code-first looks for a connection string called "MyModels" in Web.config. This can be told to use a file in App_Data or changed to access a database in SQL2008. All fine so far.
But because of multi-tenancy, I'd like the SqlServerCE filename to match the unique id of the tenant (so App_Data would have "client_x.sdf", "client_y.sdf"; Sql Server 2008 would have separate databases). I can't work out how to direct to these different databases.
I've tried MyModels inheriting from DbContext and supplying a connection string (using a 'placeholder' conn string in Web.config and replacing "{clientId}" with the unique id), and I've also tried setting the connection string in the MyModels constructor:
base.Database.Connection.ConnectionString = xxx;
but this never seems to work. I always get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
( it's not yet 'configured' to use SqlServerCE, and so is trying to connect to Sql Server)
Tracing the code, Database.Connection.ConnectionString hasn't been read from Web.config at this point, so I can't search and replace that, and, possibly, it's getting overwritten by the 'placeholder' conn string later in the pipeline.I reckon this must be quite straightforward and I just can't find the 'hook'.
I have 2 connection strings in my web.config file, and I would like to select which one to use, from code.Currently I have this:
asp:SqlDataSource
ID="SqlDataSourceDelegateServices"
runat="server"
[code]...
why this first connection works but the second doesn't?
[Code]....
I'm trying to use <asp:FileUpload> to upload images and as far as I know you have to use <asp:SqlDataSource> to do it but I need to create the connections string using entries stored in a database.
I know this might be a very basic question, but maybe thats why im having problems finding the answer. Right now I'm creating database connections in my source files by doing something like this:
SqlConnection con = new SqlConnection("Data Source=...Password=...);
SqlCommand cmd = new SqlCommand(String.Format("SELECT * FROM Table;"), con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
But this means that if I choose to change databases it will be a major pain in the ass. Do you guys know how to use the connection string from a web.config file instead?
I'm trying create unit testing for an existing website project (not web application project). I cannot access my under test classes unless I use accessor. However, if I use accessor, I have problem to initiate an object with passing arguments. I only want to create unit tetsing for App_Code. After searching web, and I found that I'd better to create a web application project using my current existing website project. From solution explorer, add new project ->using existing website. My questions is: what impact will have for my current website to create the new project? Should I just convert my current website to web application? If do that, will it cuase problems on my website? I am new on asp.net, still learning..
View 1 Replies1) To create a dll for a web project:
file - new project - windows - class library
Is this correct?
Is is possible to build a form, accept parameters and from THAT construct a new .ascx page AND the code behind for that page? What I'm proposing is having some code snippets that just need parameters added and can then be used to create a web user control that can be added to existing pages. This .ascx file would be a real file after creation, not dynamic every time.
View 1 RepliesI was able to create a dropdownlist for my MVC project, but the value is not selected as selected value on the dropdownlist. It just shows whole county list from the first.The value is from database. I tried find it from previous post, but it was quite confusing.
Controller Code
public ActionResult Edit(int i)
{
var items = new SelectList(db.MST_COUNTRies.ToList(), "COUNTRY_ID", "COUNTRY_NM");
ViewData["MST_COUNTRies"] = items;
}
View Code
<%= Html.DropDownList("COUNTRY_ID", (SelectList)ViewData["MST_COUNTRies"])%>
I need to create the web setup project
1. the hide the code from the user(dll)
2.need to add some launh condition if the user machine doesn't has Crystal Report for 2008 and Chat controls for .Net 3.5 SP1 i make the project to instal the things first then install the project how to do this
How to create menu lists in ASP.NET.
View 2 RepliesI have a bit of code I am reusing on a lot of my pages so decided to put this code into a Class and placed this class inside the App_Code directory. However when ever I try and create an instance of tis class so that I can use it's Methods etc I can't seem to get it to work, but if I create the class in the web root for the project it all wrks as expected.
View 12 RepliesI have created my project template but I want to put my own wizard to ask user about filename with database name that user want to attach in project. and with this name I wanted to start my own windows application to create that cs files / classes of that tables and automatically saved into that project folder..
View 9 RepliesI am using asp.net 3.5 and I am trying to create a project structure (asp.net web solution with UI/Business/Data access) which would be like a base and ready for any new projects in my team and all could use this standard structure only as a base(outer boundary) and they can expand the structure. Also adding on to it I wanted to include certain features like adding libraries of reusable code/functions, so that every team member could use functions from my library within this base structure. To summarize the above, I need to create standard .net project structure/framework/architecture with resusable code library included in it. How can I do this..
View 4 RepliesThere is one oracle 11g server, I want to create connection from my .Net project. tell me the steps which I need to follow for create connection.
View 2 Replieshow i can create new project web control library in visual studio 2010i'm not found this type of project in visual studiio 2o1o
View 2 RepliesI already have role management working for my project1 (i already have aspnetdb setup for project1).but i want completely new database with role management for my project2?
View 5 RepliesI want to create an HTTP handler within my project. To do this, I created a new class, and tried to implement IHttpHandler.
Each time I do this, I get the error 'End of statement expected'.
I know that normally you can create a new class library and create a class to implement a handler. But why is it not possible to do this in an existing web project?
I want to create a set up for a web project in asp.net 3.5. How can i do it? What are the steps involved? How to include database?
View 1 RepliesI deployed (publish) website in visual studio 2012 ..
But now I want to revert back and get code from generated dll..
i.e., deploying created dll, and I want code from dll.. How to do this...
I have to modify a exist web application in Asp .Net, the problem is that I have the application just on the server.
I copy the application on my pc but now I have to create the appropriate solution and project to modify it.
I've all the file .cs and the dll already deployed.
How can I create the web application with .net ?
I followed the instructions from the release notes, except for one thing. I did not include the following in my web.config. Thas the the "bindingRedirect oldversion 1.0.0.0 to newVersion 2.0.0.0". I got an error message to the effect that I could not have 2 configuration sections in the web.config. I was told that as long as I had the system.web.mvc 2.0.0.0 in my BIN and, I was refereincing this same version dll that I should be fine? I am wondering if I should just create a new MVC2 project and copy my MVC1 relevent files into this MVC2 project, not sure.
View 1 RepliesI want to ask about how to create a setup project for asp.net web application
In a way that the .cs files didn't appear when executing the setup
Like when you publish a web site only the aspx files appear and the dlls no cs files