you learned EF from Pro Entity Framework 4.0?In the book they use Adventureworks2008 sample database.Downloaded the database installation which include several databases (listed below) but NOT AdventureWorks2008!
AdventureWorks
AdventureWorksDW
AdventureWorksDW2008
AdventureWorksLT
AdventureWorksLT2008
(No, AdventureWorks does not contain the tables AdventureWorks2008 apparently have according to the book)
I have a development box running Win7 and VS2010. A User Acceptance Testing server running Windows Server 2008 / Sql Server 2008 and a Live server running Windows Server 2008 / Sql 2008.
When doing development I connect to a development database on the UAT server.
I have a problem that only occurs when I change the connection string to point to the database on the Live Server.
So, before I start describing the problem - the app works fine in development and when published to the UAT server - but there is a problem when I either publish it to the live server or, whilst on my dev box, point the connection string to the live database.
Here's an example.
I have a page with a gridview on it. In each row of the gridview there is a drop down list. All calls to the database are done through a Data Access class.
Say I have a function on an .aspx.cs page called GetDetails().
In this - to populate the Gridview I'll have something like ...
Code:
[code]....
This might be a silly question as I'm new to VWD.
I have a website I''m developing and want to add an SQL databse to do some testing on my local pc. When I go through the process of adding an SQL Server DB it says
'Failed to generate an instance of SQL Server due to a failure in starting the process for the user instance. The connection willl be closed.'
I have created a basic website using ASP.net VB in order to display a diary of various user inputs to a website, I have created a register page, home page and once the user logs in it will direct them to a user logged in page where the diary entries that they have been created or been added to are displayed from the built in SQL database. I am trying to work with roles to ensure that when a certain login user is logged it will link them to a certain page (sort of like a basic admin page, but really its just to link to a page that only they can see).
I have used a session variable to take the username input and to display the diary entries they are linked to. How can I use another session variable to compare the role of the user that is logged in to allow me to direct them to the webpage that should link to their role. I have written code on the .aspx.vb that I thought would have worked, but it complies fine but doesn't work correctly. How can I write the code so that when the person inputs their details in, it would compare the username/password then to the role that they have been associated with in the database (these areas are all in the same table) that will then link to the webpage.
This is the error message I get on running the login page.Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a correct format.
Source Error:
Line 46:
Line 47:
Line 48: ElseIf Session("LoginRole") = ("Diary Owner") Then
Line 49:
Line 50: Response.Redirect("DiaryPage.aspx")
Code:
Sub LogBut(sender As Object, e As System.EventArgs) Handles LogButton.Click
Dim connection As New SqlClient.SqlConnection
Dim command As New SqlClient.SqlCommand
Dim adaptor As New SqlClient.SqlDataAdapter
Dim dataset As New DataSet
[code]...
Here's something I've been stuck on for some time. I used code from the ADO.NET Tutorial and tried to translate it so it applies to SQL and the database on my website. I set the Configuration Manager for Debug and so I can see a detailed error message.
Here's my code:
Option Strict On
Imports System.Web.AspNetHostingPermission
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports System.Data.SqlDbType
Imports System.Data.Sql
[Code] .....
I have most of the lines in the DoStuff Sub commented out right now but I get the same error message either way so it's responding to the first line below Try.
Here's the error message I see. Line 52 is :
da.Fill(ds)
The table in Database1 that I'm trying to access is called Ray Rover Activation.
I have created a basic website using ASP.net VB in order to display a diary of various user inputs to a website, I have created a register page, home page and once the use logs in it will direct them to a user logged in page where the entire contents of the diary database table are displayed, however I want the option when the user logs in the user will be able to see the entries that they have been created or been added to
I have created the following code used to return the entries from the database, basically I am selecting (displaying) for project diary name, start date, the creator of the diary, the diary user from the diary table in the database that the username entry field in the home page is equal to the diary creator or diary user (from the database). I am not too sure how I can relate the usernText.Text in the home page to connect to this page user_logged_in_page.
Code:Code:
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [DiaryName], [StartDate], [DiaryCreator], [DiaryUser] FROM [Diary] WHERE '" & ~Home_Login/usernText.Text & = DiaryCreator or DiaryUser'">
PropertyName="usernText.Text" Type="String" />
Iīm learning how to use a web service with flash.
Now I need to connect the web service to my db.
This is what I tried:
Code:
Public Function HelloWorld() As String
Dim orgcon As New OLEDBConnection("Provider=Microsoft.jet.oledb.4.0;data source=c:dataDB.MDB")
Dim OrgDA As New OleDbDataAdapter("select * from organization order by orgname", orgcon)
Dim Orgds As New System.Data.DataSet
OrgDA.Fill(Orgds, "Organization")
Dim hwstring As String
hwstring = orgds.tables(0).rows(0).item(3).tostring
Return hwstring
End Function
The flash just gives me an error that there was an error opening the web service. For some reason I canīt debug it in vwd.
I am having an issue with my Windows forms application. I am trying to insert a record into a table. It says the rows affected is 1 however the row is not in the database. Here is my code:
<code>
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("AddSong",new System.Data.SqlClient.SqlConnection(Properties.Settings.Default.Database1ConnectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@length", dict["Total Time"]);
cmd.Parameters.AddWithValue("@genre", dict["Genre"]);
cmd.Parameters.AddWithValue("@name", dict["Name"]);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
</code>
I got 2 checkboxlists , each checkbox has 6 checkboxes inside it (below is my database)
checkboxlist1 : id , rowa
checkboxlist2:id , rowb
id : int
rowa : bit
rowb : bit
When I click one checkbox, the value is saved to my database as TRUE ,But somehow, when I load the page, it does not show the checked state (checked/unchecked). Here is my code . i think my problem is , how to load checked value (bit) of checkboxlist ?
Here is my code:
<asp:Panel ID="Panel1" runat="server">
<asp:CheckBoxList ID="CheckBoxList1" runat="server" style="margin-left: 258px">
<asp:ListItem Text="1"></asp:ListItem>
<asp:ListItem Text="2"></asp:ListItem>
<asp:ListItem Text="3"></asp:ListItem>
[Code] .....
I am trying to insert a record into a MySQL Table. I thought that the Insert methods returned the number of records that were successfully inserted. But that is not what I found. My code:
Code:
dim n as integer
n = taProject.InsertProject(pname, descr, idManager, startdate, tenddate, client, disable)
I get n = 0 even though the record is installed. How can I determine if the insert was successful or not?
I have a dropdown list which provided input to a SQLDataSource query which is bound to a listbox. When the user changes the index of the dropdown box, I want to trigger the SQQLDataSource to requery the database, and repopulate the listbox.
I have set the autopostback = true for the dropdown box. I have also added a Response.Redirect back to the same page in the SelectedIndexChanged method, but the DataSource does not Repopulate. How to trigger the requery?
i have textbox whose value converted to Int32. while passing value to database when textbox is blank it gives error as Input string was not in a correct format.
my code is
cmb.Parameters.Add("@rate", SqlDbType.Int).Value = Convert.ToInt32(txtGenRate.Text)
what should i do?
I'm in the process of re-writing an existing survey application that is currently using nested repeater controls to display questions and answers. The application was not designed with future enhancements in mind and its a pain any time a new question has to be added to the application. The repeaters currently contain questions, answers, and controls(texbox, radiobuttonlist,etc.)
Is the repeater the correct control to use for this type of application? What is the best way to design this type of application and table structure? Are there any new controls or features in VS2010? How to design this application the correct way and make it more flexible?
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.
My 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 an ASP.net security database which is normally ASPNetDB.MDF however I have created the same database structure in MS Access. All works great. However, I need to add a couple of other tables but I can't find how to do that in VWD. I'm pretty sure I was able to when the first database I created was an MDF file but not in MS Access.
View 5 RepliesI am trying to create Web Application using ASP.Net via Visual Studio 2010. The Database that I use is Access, with connection Method OleDb
When using the query "Update" or "Delete", the programs shows no errors, but the data in Access does not change.
While for query "Select" and "Insert", the data is displayed and inserted successfully.
The Following code is the sample query "Delete" that I used..
Code:
Imports System.Data.OleDb
Partial Class frmTEst
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code] ....
Previously I tried a direct query using AccessDataSource, but the result just the same, Update and Delete can't be done. But the Select and Insert can be executed successfully.
Is there any problem with my Access configuration or whether the problem is in the coding itself..?
I'm New In Asp.net , And I Wanna to know how can i display an alert to the user that inform the saving operation was done successfully and refresh the page to clear all the textboxs in the form to insert a new record in database ??
View 3 RepliesHas anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.
View 6 RepliesOpening an existing asp.net 3.5 project using VWD Express 2010, the database diagram file under Database Diagrams folder went missing in Database Explorer tab. Everything is in there when I first created the diagram using VWD Express 2008. However, when I look at the .dbml file, the associated relationship between dozens of tables exist and my project runs successfully. I'm planning to create another table with relationships from existing tables but seems like I have to painfully recreate them back from scratch. How can I recover those diagrams?
View 1 RepliesI am trying to integrate an existing asp.net application with sharepoint 2010. I would like to be able to have a logged in user on the application access a document library via an Iframe on the sharepoint 2010 site. I want to use FBA on sharepoint. Is it possible to share the membership database from the asp.net application with sharepoint? If not, what would be the best way to accomplish this?
View 1 RepliesI'm using Visual Studio 2010 RTM and MS Sql Server 2008 R2 EXPRESS with Advanced Services.I create a new simple asp.net web site. When I click on asp.net configuration, it opens as expected.When I click on the Security Tab, I get the message, Unable to connect to SQL Server database.It will not create the default aspnetdb.mdf file.I can create a connection to the sql server in VS from the database explorer.I can connect to the sql server with sqlcmd as a trusted connection.I have even managed to verify the default instance of .SQLEXPRESS with named pipesusing the sc command and the MSSQL$instance name.I have verified that my machine dot config file for the 2.0 .net contains the proper info (without altering it).I've spent many nights trying to figure this one out.VS2008 and MS SQL Server EXPRESS 2008 worked.I noticed that the default asp.net web site uses a connection other than the default localsqlserverand the template automatically adds a login in the ui with role, membership & profile in the web config.
View 3 RepliesI have referred below mentioned links and successfully implemented Gzip, by compressing aspx pages. URL....My website is ajax enabled. One of page is having gridview. While debugging gridview rowCommand fires and records are displaying in debugging mode, but same records are not displaying on web page controls.
View 1 RepliesI want to save multiple seats to status(booked) inside my database. In the table there are t1,t2,t3,etc... But i can only update one of the column. I am using label to store into string of array.
Code:
Dim forBook() As String = lblSelected.Text.Split(",")
Dim i As Integer
For i = 0 To forBook.Length - 1
cmd2.Connection = mycn
mycn.Open()
cmd2.CommandText = _
[Code] ....
Im having an issue when I create a new ASP.NET Web Application within Visual Studio 2010, this creates a web.config configured to use SQLEXPRESS. The default web.config that VisualStudio generates for New Web Application Projects still points to the SQLServerExpress Database which I had previously removed! The only instance that I have now is SQL Server 2008 R2 Developer. The web.config that is created along with other files for the for New Web Application Projects template:
[Code]....
The question is how can I change this web.config thats created with the ASP.NET Web Project template automatically from Visual Studio 2010? I can go in and modify the web.config by hand obviously. It doesnt make sense to have the web.config automatically created this way whereby the connectionstrings point to SQLServer Express that does not exist. I did in stall Visual Studio 2010 which included SQLServerExpress, but that I later removed. Now is VisualStudio always going to create web.config's pointing to SQLServer Express?
