In this tutorial in listning 2 we have:
[Code]....
What if I need also CustomerRepository and EmployeeRepository ? Should I write:
[Code]....
?? But if I have in ProductRepository, CustomerRepository and EmployeeRepository:
[Code]....
Is it mean 3 connections to database or only 1 connection to database when I open some website controller ProductController ?
quick question: I have a view on my HomeController which is used to create a new 'model'. This view posts to a different controller to keep things tidy. The problem I am having is when I enter invalid details into the form, the rules I specified never seem to make it back to the original view and thus my validation messages or summary never get populated. Is there a way around this because I am using a view model with two IEnumerable lists in it.
View 5 RepliesI have use the mvc 2 web site template and I would like to attach
A user db that I have already created
In my web config file I have change the connection string to this"
[Code]....
When I'm tring to register I'm getting this error :
Login failed for user ''. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''.Source Error:
[Code]....
I have set a break point in line 127 and I can clearly see that is getting the data (username ,password ,email) What is wrong( with the contion string)?
I have been searching for this answer and can't seem to find anything, but with EF4 I want to create a base model and put in our 'foundation' and any new project we create if we need to add custom tables to that sites db is it possible to add a model with just those specific tables and link it to the model in our 'foundation' I can't seem to find a good resource on something like this and this seems to be like it would be a normal thing to have a reusable base model and a separate one for any one off's
View 1 Repliesi have a base controller that looks like this:
[Code]....
and a contact model that inherits from the base model.
the master page inherits form the base model,
nad the contact page inherits from the contact nodel,
but then i get an error while loading the contact page that it expects the contact model but gets the base model?
Is it possible to upload .obj files ( 3D models ) to an sql server database?
View 1 RepliesI am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
i have a repository class inside my model folder; this repositiry contains many methods , which are called from Action methods in the controllers; so my question is :- if i have a method insidle my model.reporsitory which calls a stored procedure, then can i call it an "action method"? or "action method" expression only apply to controller methods?
View 4 RepliesUML and Patterns: An Introduction to Object-Oriented Analysis and Design and Iterative Development, that follows the UP(Unified Process). It uses a Grasp Controller pattern to interact with domain classes by some methods like NewSale(), AddNewItemToSale() and CloseSale. In windows form, I can instantiate a object of this class in the UI and then use its methods to perform the actions. This works well in Client apps, but when I use asp.net mvc, I cannot find a way to instantiate an object (one for each user) that was always visible for a Controller (MVC). I cannot insert as an attribute inside Controller because it always create a new one.
View 1 RepliesI'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
First off, I am just getting started with ASP.NET so I expect this is something that I am doing.
i am trying to make a connection to a MS SQL database on my local machine.
I have the following in web.config
[code]....
I'm having trouble connecting to my model to my existing database using Entity Framework . Here is the code I'm working with:
[Code]....
I've started with Flex recently, I've noticed that some plugin for Visual Studio exist, instead of buying a licence for another program (Flex Builder). I was wondering how I could manage to remotely connect to my database with a Flash/Flex application with the help of C#/Asp.Net. If I've correctly understood what I've read in the last few days, there is basically no way to 'query' to a database with Flex 3. So I suppose there is another way by using a webservice in C# on the database server that would respond to the Http query from Flex. Am I right or totally of the track?
View 3 Repliesweb.config file. when i go to test connection, i get this errorCould not establish a connection to the database.f you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the providerCan someone help me pls i am trying to deploy it to the remote server. Here is the codes:
<configuration>
<connectionStrings>
<add
name="ApplicationServices"
[code]...
need a simple video that can expalin me the simple connection between a web form and sql db i am a begineer, i am learning all the things from these website, i need a video tutoorial that will explain me that how to create a simple form and simple database and conect them and manage those datas, can you people understand what i am expecting, for example, just a user login page with user name and password , and we have to store that details with a data base, and how to see the details what we stored, thats it and how to edit those details, atleast i need the first set of connection and manupulating video.
View 4 RepliesI know that most people store the Database connection string inside the web.config file.
But my question is if we move the web.config file from dev to prod then we have to change the connection everytime.
how can we have a connection string that we do not have to change when we move our code from dev to prod.
i have create users and rolls and all thing work very good on my computer but after upload view exception
Code:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) how can i change connection string for mdf database
I did all the instructions which are in the following link: [URL] in order to do a connection between MySQL database and ASP.NET but I did not successed. Sometimes, it told me that I have a mistake in the <asp: button> and sometimes it told me that I did a mistake in calling (addImage) method. And this is my whole code:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="HW5._Default" %>
<script>
public class DataAccess
{
private string _strConn =
@"Driver= {MySQLODBC 3.51 Driver};SERVER=localhost;DATABASE=test1;";
private OdbcConnection _objConn;
public DataAccess()
{
this._objConn = new OdbcConnection(this._strConn);
}
// This function adds the Images to database
public string addImage(timestamp id, byte [] data,string extension)
{
string strSql = "SELECT * FROM File";
DataSet ds = new DataSet("Image");
OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql,this._objConn);
OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP);
tempAP.Fill(ds,"Table");
try
{
this._objConn.Open();
DataRow objNewRow = ds.Tables["Table"].NewRow();
objNewRow["Extension"] = extension;
objNewRow["Data"] = buffer;
objNewRow["ID"] = id;
ds.Tables["Table"].Rows.Add(objNewRow);
// trying to update the table to add the image
tempAP.Update(ds,"Table");
}.....................................
I have run aspnet_regsql.exe beaucoup times and it creates the database aspnetdb.db. I have created it in my primary database connection and in the SQLExpress connection.
Then I open Visual Studio 2008 and run the ASP.net Web Site Configuration Tool. I click on Provider tab and select Select a single provider for all site management data. The provider shown is AspNetSqlProvider. A book that I'm reading says it should be aspnetdb.
When I click on the test link, I get the following message
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
In my book, it looks like the aspnetdb database should appear in the app_Data folder of my web site. What is supposed to put it there? Does it get moved from the SQL Server Data folder?
I use the class below in my code-behind to connect to my database. How would I (overload?) this class to choose between multiple connection strings (databases)?
Or should I have a separate class for each connection?
[code]....
how 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?
i am adding a connection in asp.net using visual web developer to sql server database file, it's an MDF file.
when i click test connection i get this:
I have a small website that I am building using ASP.NET web pages Razor Syntax. It has an SQL CE 4 database in the App_Data folder. The connection and getting records from the database works fine in pages that are in the root directory and the /Account subdirectory. However when trying to get data from the database in pages that are in other subdirectories, connection to the database does not work. I get an error: Connection string "Database.sdf" was not found.It is using the connection string from the Web.config file in the root directory:
When I tried copying the root Web.config to the subdirectory I get the following error:The entry 'Database' has already been added. (C:UsersNameDocumentsVisual Studio 2010WebSitesSmallWebsitesubdirweb.config line 11).At the moment I'm stumped and can't seem to find an answer either in msdn or google.
Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
I don't know where to go next as this error message does't give many leads. I have already configured that database with the aspnet_regsql tool. In SQL Mngt. Studio I can see that the database aspnetdb has been created. I'm not sure where to go from here. The only connection string in my web.config file is the one for connecting to my content database.
Currently I'm learning on one of Joe Stagner video "SEC-009-CreateMembershipSchema" I followed exactly as told except for that Joe's is building the database in his JoeStagner server and not JoeStagnerSQLEXPRESS. But in my case I built my database in my MACHINENAMESQLEXPRESS. Another different thing is Joe's using SQL Management 2005 and I'm using the free version of SQL management 2008.
So I followed every step, inch by inch but when I tried to run a test on the AspNetSqlProvider, I'm getting this error Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
here's the connection string I added in just like in Joe's video
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="data source=.SQLEXPRESS;DataBase=AspNetServicesDB;Uid=AspNetServicesUser;Pwd=password"/>
</connectionStrings>
