i'm using visual studio 2005. now i've to create a insert form which shud be connected to database(mssql). can any one tell me how to do dat. as i'm new to visual studio i dnt knw it.
View 8 Replies
I had another thread on this problem but I wanted to start this one so no one had to look at the code I posted in the other thread. I have a successful connection but want to display data from the SQL database on my website in my Windows form application. Here's the code I have so far. Used some of the ADONET Tutorial1 here. The table Ray Rover Activation has a number of different columns but to start out I just wanted to see if I could display data for the EmailAddress column.
Code:
[code]....
If I comment out the Sub DoStuff I don't get any errors but neither is anything displayed other than the messagebox message. If I don't comment out DoStuff then I get an error, "Incorrect syntax near the keyword 'FROM'". Maybe someone could enlighten me some on what I need to do get the data in the column EmailAddress to display.
I have no trouble connecting to a SQL server with code in my web config file for user registeration. But I am having trouble telling it to go to a particular table.
Here is what is in my web config file:
<connectionStrings>
<add name="homeowners" connectionString="Data Source=countrypark3.db.5503108.hostedresource.com;Initial Catalog=countrypark3;User ID=xxxxx;Password=xxxx; Trusted_Connection=False" providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString=" Server=whsql-v04.prod.mesa1.secureserver.net; Database=DB_675; User ID=user_id; Password=password; Trusted_Connection=False" providerName="System.Data.SqlClient" />
</connectionStrings>
I'm trying to get it to point to the homeowners table.
I have entries for an enumeration stored inside a database table with only the following fields: ID and Name. I want to show the values stored inside this table inside a DropDownList on a form. The user then chooses a value and submits the form.
I found a way to easily create a DropDownList from an enumeration (although it would probably be best to just populate the DropDownList with the Name fields of all the records in the table). However, I haven't found a way to later bind the DropDownList in the form submission to an integer value to put into the database (FK - PK) with the other form values.
is it possible to fetch DropDownList content via AJAX and have it be put into the DropDownList and into the SelectList in the ViewModel (with both the ID and Name parameters)? I want to selectively fetch content based on an input the user makes and I want the ViewModel to then be filled with that fetched data.
I have a form and stored procedure that inserts the data from the form. It works fine except that if a field isn't filled in it doesn't insert a NULL into sql it inserts "".
I've tried a few different ways but none seem to insert NULL, the one below still inserts "", can anyone point me in the right direction.
Here is the required part of the code, if you require more just let me know.
[code]....
So if I enter nothing into address1 field it should write NULL to screen but it always writes NOT NULL.
am having to difficult inserting into a data base using a form, still having some errors.
View 1 RepliesI need to create a Master Detail detail form to insert data into Access. The form i have to create is very similar to the typical Order/Detail form.
View 3 RepliesDoes anyone know of a tutorial on this? I know i would need a wcf service but how can i get it to connect asp website to windows form?
View 1 Replies[Code]....
I'm getting the following error when attaching to my database on line. I'm not sure what the issue is as I've been able to connect in the past without any issues and there haven't been any changes to my connection string. Here is the error and my webconfig.
[Code]....
My requirement is need to develope a web page in asp.net using c#, which contain 4 textboxes 4 labels and 1 button and finally gridview.
Lables are:
1.StudentId (it shld be identity key and primary in db(automatic id updation))-textbox
2.StudentName-textbox
3.Course-dropdownlist box
4.Address-textbox
Note: studentId and name shld have validation.
Button:
1.Insert
REQUIREMENTS:
Gridview should hve edit and delete link button atlast. In c# pgm thr should be a sql connection when values are entered in textboxes after clicking Insert button it should insert value in gridview and also in database. If the edit button is clicked the values should display in textbox and their only we should update the values and main thing we click on edit link button the INSERT button should change to UPDATE button after updating the updated values it should save in gridview and also in database and after updating it should chance again to insert button.
The delete button shld delete the selected row in gridview.
I come from a coldfusion background, where setting up a connection to a database (Oracle, MYSQL SQL Server etc) was was easy as filling in a few fields in the datasource screen in the Coldfusion Administrator web app.
Then in the web application to connect to the database I would use <CFQUERY datasource="oracledb" name="test"> and in the body of the application I would write my SQL query and display the results of this query in a <CFOUTPUT>#variablename#</cfoutput> block of code, or to insert data into a db table I would use the
<CFQUERY datasource="oracledb" name="insertdata">
INSERT INTO table (columnname, columnname2, columnname3)
VALUES (
<cfqueryparam cfsqltype="cf_sql_number" value="#columnname#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#columnname2#">,
<cfif isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>,
</cfquery>
How does this process work in .NET? as I have to create a simple web application/form where on submission of the form the data would be stored in a MYSQL database.
what I have seen so far it seems a far more long winded and complicated process with .NET over Coldfusion with ultimately the same result, and I am desperately trying to understand how it works in .NET as surely it must be a similar process to that of Coldfusion?
I'm trying to learn how to do both of them at the same time on my own, while working on a project. All the examples in the MSDN are using databases that are a local SQL Server (Express) file. I am not going to be able to just upload the project (including the file) and have it work, am I? The thing is - I want to be able to write code vs. a database that is actually going to work online so I can start putting a project together and know that it is going to work online.
I don't want to get everything done, and then discover it breaks as soon as I upload everything. Assuming I can't just upload the database file and have it work - I have a hosting account that I am using for something else and I would like to set up a database to use (preferably MySQL because my SQL Server database quota is used up and I'd have to pay extra for another, but I will if I have to because it's not that much). I can do that, correct?
I have never used reporting services before. My boss just started teaching me how to use them. I was told something by my boss that I find hard to believe. In our environment we have 3 databases: Development Beta Production According to my boss, the connection string has to be hard coded in the reports. Therefore every time you move a report from one environment to another you have to manually change the connection string so that it points to the correct database.
View 9 RepliesI've installed the Components from the links below. But I still can't find any SQL references when I try to add them? I'm wondering if anyone would know the reason for this? I just started with asp.net. I've found several other questions regarding code for connecting but I can't find anyone who've had trouble with the Connector/components before?
MYSQL connector
[URL]
Microsoft Data Access Components (MDAC) 2.8
[URL]
how do i connect visual web developer to sql server express 2008? in the Database Explorer, i right click on Data Connections, click Add Connection..., and in the Data source box i choose Microsoft SQL Server (sqlClient), which i'm guessing doesn't connect me to a database file, but to sql server express itself(?). in the server name box when i click the drop down box, there's nothing there and that's where i get stuck.
View 3 RepliesI'm trying to write a method in VB.net so that when I click a button it queries the database and returns all the values which match a textbox which is located next to the button. I have no idea how to do this, I assume in the onclick method for the button I will need to pull in the value from the textbox, connect to the database and display the results to a gridview?
View 2 RepliesI m facing an error in connecting my Access Database using ASP.NET. I have placed the below code in Web.Config
Code:
<connectionStrings>
<add name="ConnString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|PerformanceDb.MDB"/>
</connectionStrings>
And used below code for connection
Code:
OleDbConnection myConn = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("ConnString"))
but it gives error
Non-invocable member 'System.Configuration.ConfigurationManager.ConnectionStrings' cannot be used like a method
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
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 have set up a db locally which mimics the production DB, THe production db and website has no has no issues.
THis used to work till i had hard disk failure and had to reinstall all software and do the db from scratch. Used the table scripts and ran the aspnet_regsql. I am using sql server express 2008 asp.net 3.5 I am using custom provider for Roles and custom membership provider for Memberships. Pretty sure the problem is in the db permissions, though I have set up Users in the Security of the DB.
[Code]....
I have all my tables and queries in online DB ie., i have created all my tables and queries in online using third party site [URL] Now i want to make connect my application (which is in my system) with that database
View 5 RepliesI upgraded a Website to use ASP.NET 4.0, from 3.5. This involved setting it up on a different server, with the same hosting company. I'm using a shared hosting plan on Windows Server 2008.
Since migrating, it gives an error message when I try to login to the site:
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)
I'm using the same connection string as I did in the old version, which always worked. I also changed the permissions for the database to allow connections from the redeployed Website, via the host's control panel.
I have searched the web.config, and the source for the site, and I haven't been able to find a connection string that looks incorrect.
I've contacted the host about it, in case it is a configuration issue on their side.
Is there a way to connect the database PROGRAMMATICALLY without using SYSTEM.DATA.SQLCLIENT?
View 9 RepliesMy website is [URL] (access there to see error, please) When I was testing in VS2010, it was connecting to the DB because I set permissions READ/WRITE on my computer to ALL. If I put restrictions, VS2010 couldn't just connect to them. Well, I deployed my DB on the server of my website, and I'm not able to access it.
My connection string:
connection = New SqlConnection("Data Source=.SQLEXPRESS; Integrated Security=True;AttachDbFilename=|DataDirectory|Visitas.mdf")
I think I'm getting these errors because my server hasn't permission to access the database.
I have a custom SQL membership provider (NOT using aspdb files but our own 'People' table) that was working fine under development but doesn't even connect when it is deployed on web server. DB connection string has been changed to point to db server (checked against another web site & is fine there). The membership code (in VB) is in App_code directory so am I correct in thinking I don't need a separate DLL ? No error messages nothing just reports failed to login when I type some user credentials.
Web config file as follows
[Code]....
connecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
View 1 Replies
