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?
Since I'm using Postgresql and can't use LINQ to SQL, I wrote my own wrapper classes.
This is a part of the Student class:
[code]....
It works now! I replaces all Run methods in the Student class with DB.Run
But I want to know if it will work fine with a lot of people online, not me only. I'm not sure how static things work with ASP.NET, maybe it'll eat a lot of memory?..
I am new to Visual Studio 2010 and ASP.Net, and when I first connected my SQL Server to Visual Studio it created huge files full of my SQL classes (maybe this was LINQ classes), and I accidently deleted/corrupted those files, and now I want it to create those classes again. Can someone tell me how I can do that?
View 5 Repliesi have the following code:
[Code]....
I was trying to implement as above. How can i call this class from the code behind of my page, and call the methods Open and Close connection ?
How do i instantiate the object ?
it's possible to put the database connection settings into a base page class so that I can auto-init them on a page. like this document: [URL] but with instructions in VB.net
View 1 RepliesI have my own custom class which inherits from DropDownList. Is there a way to override Items.Add procedure? How?
View 2 RepliesI am preparing for an Access2007 db conversion at the beginning of the year and would like to know what the best process would be for connecting to the sqlserver2005 database. I have read about adding the connection string to the web.config file. I have also read about using ADO.NET and put the connection information into a class and not the web.config file.
I would like to hear from others as to what you have used, are using, or plan on using for a webapp (vs2010), and why so I can get an understanding.
I 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)
Below is my class file.
[Code]....
I'm using the template posted in this thread to generate C# enums from a couple of lookup tables in SQL Server within a class library that contains my DAL.
At the moment, I have the connection string used by the templates embedded an a template include file in the class library. Is there a convenient way to have the template grab the connection string from the main project (WAP)'s web.config without having to include a physical path? Or is there a better way to approach this?
I've also considered creating a SQL CLR assembly which returns a table-valued function containing the enum contents (which would then be defined in C#, not in the database), but I'm not sure what the performance hit would be. Whether or not it's significant will obviously be application-dependent but I'd hate to charge down a crappy path if it's a know best-avoid-this approach.
I'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'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]...
I am keep having the "No overload for method 'GenerateSignature' takes 9 arguments" problem. what is wrong with this class.This code is the sample from the Oauth.net . I think it too old for my asp.net 3.5 or 4.0.
default.aspx
<%@ Page Language="C#" AutoEventWireup="true"%>
<%@ Import Namespace="OAuth" %>
<%@ Import Namespace="System" %>[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 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>
