Tutorial: Creating A Data Access Layer...ceases To Be A Tutorial On Page 12
Apr 8, 2007
Before page 12, step by step instructions work!
Then there is code for AllProducts.aspx that doesn't work if one inserts the code
into the DataTutorial project started on page 1. Yes I changed the name of the CodeFile!
The code given for AllProducts.aspx.cs doesn't compile.
I was doing better without the tutorial!
I can gleen out some concepts but that is all.
If that is all, why have a tutorial?
View 3 Replies
ADVERTISEMENT
Nov 1, 2006
HiI'm having problems following the tutorial on creating a data access layer - http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63 - when I try to compile in Visual Studio 2005 I get namespace could not be found. I followed exactly the tutorial - I created a dataset and added this code in my aspx page. <asp:GridView ID="GridView1" runat="server" CssClass="DataWebControlStyle"> <HeaderStyle CssClass="HeaderStyle" /> <AlternatingRowStyle CssClass="AlternatingRowStyle" />In my C# file I added these lines... using NorthwindTableAdapters; <<<<<this is the problem - where does this come from? protected void Page_Load(object sender, EventArgs e) { ProductsTableAdapter productsAdapter = new ProductsTableAdapter(); GridView1.DataSource = productsAdapter.GetProducts(); GridView1.DataBind(); }Thanks in advance
View 6 Replies
View Related
Jun 13, 2006
In the tutorial Creating a Basic Package Using a Wizard > Lesson 1: Creating the Basic Package >
says to use the following sql statement on the query page:
SELECT * FROM [Customers$] WHERE NumberCarsOwned > 0
When I paste the query in I get the message :
This SQL statement is not a query.
Does anyone have any suggestions? The input and output are set up correctly and I have the sample excel file Customers.xls.
I am new to all this, is there some setting I need to change for the tutorial to work or..?
FYI I have installed Sql 2005, Sp1.
View 4 Replies
View Related
Mar 10, 2008
Hello, everybody.
In my web application, i'm using 2 tabels; Users(Username(PK), Pwd, Name, Deptid(FK)) n Dept(Deptid(PK), Deptname)).
For creating a Data Access Layer 4 my project, I added dataset as new item n followed the wizard 2 create the required functions.
I have a function GetUser(@uname, @pwd), which takes username n password as input. M using this for authentication purpose.
While executing it poping an ConstrainException.
Plz help me out.
I've tried 2 as clear as possible here. OR u may ask me any other questions for clear picture of the scenario.
Thanks and Regards,
Sankar.
View 1 Replies
View Related
Jun 11, 2008
I request you plz tell how to create Data Access Layer. I mean DataAccess.dll. So that I can call stored procedure from dataaccess.dll as below.
DataAccess.SqlHelper.ExecuteDataset(DataAccess.DSN.Connection("DBConnectionString"), CommandType.StoredProcedure, "SP_GetEmpIds");
I request you how can I add this stored procedures to DataAccess.dll and function. I am not having any idea in this area. I request you plz give me some suggestions to work with task.
View 3 Replies
View Related
Aug 19, 2004
Hello all,
I have been trying to set up roles and security for my database using SQL Web Data Administrator(from Microsoft). Unfortunately, i am facing some difficulties to do it. Is there any link that explain how to manage these roles and security issues in the program.
Thanks
View 1 Replies
View Related
Nov 25, 2007
Hi All
Microsoft released an introductory tutorial for data mining in September 2007, and I was attempting to match the results on:
http://msdn2.microsoft.com/en-us/library/ms169911.aspx
I was not able to match the results, so then I went "under the hood" for the tables, and discovered that my copy of AdventureWorksDW has truncated values in the Education field of the ProspectiveBuyer table. I had wanted to connect "EnglishEducation" from the Mining Model to "Education" in the "Input Table" to see if the additional linkage would affect the prediction results (the wizard does not automatically link these fields because they technically do not have the same name).
1) Is everybody's "Education" field in the "Prospective Buyers" table populated with truncated values? (which may be intentional since it is a sample dataset) -- compare to "EnglishEducation" field in the vTargetMail table
2) Am I the only one getting 0.50580 for all rows when I use "Decision Tree" (per the tutorial instructions)? By contrast, I was able to see a variance in expression values for clustering and naive Bayes.
My guess: everybody has a truncated "Education" field, and there is something different in how the data mining model was run under the Decision Tree option to yield the tutorial's numerical results for "expression".
View 8 Replies
View Related
Feb 12, 2008
Hi everyone, I'm trying to get the data mining tutorial building but I'm getting tons of ATL errors.
When using the wizard to add "Simple ATL Objects" I get messages telling me that the IDMAlgorithm object already exists. It's really driving me insane, because it's stopping me from moving on completely. I've tried deleting the project and recreating it several times with no avail.
Hopefully someone will know what's causing the troubles. Thanks in advance,
-David
View 3 Replies
View Related
Nov 4, 2006
Hi,
I am new to SSIS. I followed the direction of the tutorial Creating Simple ETL Tutorial package in BooksOnline. I have tried more than five times and have done exactly as suggested in the tutorial but it does not work.
The URL is:
http://msdn2.microsoft.com/en-us/library/ms169917.aspx
I get these warnings and finally fails:
1)[Lookup [30]] Error: Row yielded no match during lookup.
2) [Lookup [30]] Error: The "component "Lookup" (30)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Output" (32)" specifies failure on error. An error occurred on the specified object of the specified component.
3) [DTS.Pipeline] Error: The ProcessInput method on component "Lookup" (30) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
4) [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0209029.
Can someone help me with this tutorial error? or Am I doing something wrong.
Thank you,
View 6 Replies
View Related
May 11, 2007
Hi, all experts here,
Thank you for your kind attention.
Could please any of you give me some advices for if there are tutorials and demos avaiable which cover all the SQL Server 2005 data mining built-in algorithms?
That will be great to hear from any of you shortly. Thanks a lot in advance.
With best regards,
Yours sincerely,
View 8 Replies
View Related
Dec 4, 2004
HI there... i'm really new to this, and i want to know if there is a tutorial of how to connect to sql database, display the data online, and run some queries....
thanks in advance
please e-mail me to hachemr@hotmail.com
View 1 Replies
View Related
Nov 2, 2005
Where can I find a good MDX tutorial ..
I am a beginner with analysis services
but got a job in which i have to create a cube and some mdx querires
View 4 Replies
View Related
Jan 8, 2008
Try this outRegards,Josephhttp://db2examples.googlepages.com
View 1 Replies
View Related
Aug 18, 2006
Do you know a good link (i.e. on msdn) that has a good tutorial for SSIS?
Thanks
View 1 Replies
View Related
Jun 9, 2008
Hey guys, while going thru the sql tutorial #5 on this website, I have run into an error. Am using, sql server management studio where it is required I attach a database, on adding the selected db, here is the error that I get, and i have no clue whatsoever on how I must proceed:
TITLE: Microsoft SQL Server Management Studio------------------------------
Attach database failed for Server 'parijat'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.Could not open new database 'MyCompany'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------BUTTONS:
OK------------------------------
View 1 Replies
View Related
Mar 7, 2006
hi there! im new to MSSQL and i want to know if anyone of you knows a reliable website which teaches a detailed and in depth info on how to use mssql...
thanks!
View 1 Replies
View Related
Mar 9, 2004
I'm using VB to access MDBs, and now I want to expand my work to a SQL server. Does anyone know where someone of my needs can find a suitable tutorial?
Thanks in advence,
Chen
View 9 Replies
View Related
Feb 3, 2006
There's a tutorial (http://msdn2.microsoft.com/ms345296.aspx) on how you create a login in SQL Server. But when I type a new user name I get the error message that the name allready exists. But if I type a existing user name I get the error message that the user name or group couldn't be found.
View 3 Replies
View Related
Oct 10, 2007
Hi all,
i'm looking for an article on how to use DataTypes of SQLServer in T-Sql script writing !!!?
As you know the Books-Online has limited example and i have trouble undertanding for example how to use Binary,varbinary Decimal,Float,real...in T-sql script
Could anyone showm me an instructive article on the net?
Thanks in advance.
View 3 Replies
View Related
Mar 1, 2008
I'm a coldfusion programmer that works with SQL Server databases. We have the opportunity to move our database from a shared sql server to a semi-private virtual machine with our own copy of sql server 2005. We'll all of a sudden be able to use more features of sql server including replication. We want to be able to keep several databases on the same server in sync so that we can have a production database and a development database that are identical.
I'm not a professional dba but I am willing to learn. Is there a good, straightforward tutorial about setting up and using replication out there that someone can recommend?
Many thanks!
View 3 Replies
View Related
Jul 23, 2005
Are there any good free online tutorials for T-SQL?
View 2 Replies
View Related
Jan 9, 2006
Hi Forum-Members,
I was doing the Step by step tutorial "Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005". Link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp
Doing it on Windows XP (as required by the tutorial) worked fine for me, doing it on a Windows Server 2003 installation failed, as the client could not connect to the SQL Server database.
Does anyone have experience stepping through the tutorial on a Windows Server 2003 machine?
Best Regards,
Tobias
View 3 Replies
View Related
Apr 23, 2007
Hello!Im trying to write SQL but I dont think that SQL is enough for me right now.I wants to write Stored Procedures, but I dont know how to... Is there any good tutorials you can recomend?
View 3 Replies
View Related
Jul 1, 2007
Do someone know good tutorial on web with examples for search data from SQL database?
View 2 Replies
View Related
Apr 30, 2004
hi all,
could anybody send me the tutorial site for learning sql server...
especially in stored procedure,functions,triggers.
thanx in advance
View 2 Replies
View Related
Jul 20, 2005
hey!Im looking for a db tutoral which covers accessing a Microsoft SQL databaseon windows. I will be using VC++ if it matters. NO details just a basicintroduction!Oracle DB access using C++ is also of interest!Thanks!-- Majk
View 1 Replies
View Related
Jul 10, 2006
Does anyone know of a good matrix tutorial which shows a finished report and how the choices for Page, Columns, Rows, and Details map to a finished report? Having a tough time wrapping my head around the direct impact, and for whatever reason, my sample data keeps triggering an "Out of memory" during preview mode.
View 2 Replies
View Related
May 21, 2006
After I complete the SSIS Tutorial Lesson 5 and try to run the package, I found there's no any rows inserted into the error output file. I'm sure that I'd followed all the procedures. Anybody help?
View 1 Replies
View Related
Jan 15, 2008
One of the wonderful tutorials Microsoft done for SQL DBA/ Developers
If you are having hard time to understand SSIS Package. Please finish the entire tutorial to become Master on SSIS.In order to finish the entire tutorial you need to start from fresh installation of sample Database by Microsoft. Once finish all Tutorial you will be master on SSIS.Good luck.
Thanks
Faiz Farazi
MCDBA, MCSA
View 5 Replies
View Related
Apr 17, 2007
I'm new to SQL Server 2005 Express. I'm sure it's great but after successfully installing it on Vista, I don't know how to "connect" to the default "instance".
Can someone please point me to a online tutorial on connecting once installed... or please help me out with understanding this.
After that I think I can go forward with the msdn video tutorials.
Thanks in advance
View 1 Replies
View Related
May 18, 2006
In Lesson1 of SSIS Tutorial, section "Running the Wizard to Create the Basic Package", is stated
"Specify the data source. You will use the Excel workbook, Customers.xls, as the data source..."
I have both AdventureWorks databases installed on my box as well as a host of samples but I can't find that file. Any pointers much appreciated.
TIA,
barker
View 12 Replies
View Related
Oct 30, 2007
Hi guys,
I've been developing desktop client-server and web apps and have used Access and SQL Server Standard most of the time.
I'm looking into using SQL CE, and had a few questions that I can't seem to get a clear picture on:
- The documentation for CE says that it supports 256 simultaneous connections and offers the Isolation levels, Transactions, Locking, etc with a 4GB DB. But most people say that CE is strictly a single-user DB and should not be used as a DB Server.
Could CE be extended for use as a multi-user DB Server by creating a custom server such as a .NET Remoting Server hosted through a Windows Service (or any other custom host) on a machine whereby the CE DB would run in-process with this server on the machine which would then be accessed by multiple users from multiple machines??
Clients PCs -> Server PC hosting Remoting Service -> ADO.NET -> SQL CE
- and further more can we use Enterprise Services (Serviced Components) to connect to SQL CE and further extend this model to offer a pure high-quality DB Server?
Clients PCs -> Server PC hosting Remoting Service -> Enterprise Services -> ADO.NET -> SQL CE
Seems quite doable to me, but I may be wrong..please let me know either ways
Thanks,
CP
View 3 Replies
View Related
Jun 2, 2008
Hello everyone, I've been using the tutorial located here.I am using Microsoft Visual Studio 8.0.50727.42, Microsoft SQL Server 2005, and Microsoft .NET Framework 2.0.50727 SP1.The tutorial uses the SQL Express version and I cannot get it to connect to the standard SQL Server 2005 version. I have used the website ConnectionStrings.com and the whitepaper located here and I wasn't able to get my web app talking to the database through many attempts.I am using a database in Microsoft SQL Server 2005 named SecurityTutorials. This is located on my local machine. There is a login named SecurityTutorials and a user in the SecurityTutorials database named SecurityTutorials who has default schema dbo, who owns the db_owner schema, and has role membership to db_datareader, db_datawriter, and db_ddladmin. The password of this user does match the password in the connection string in web.config, I have verified this multiple times.The problem comes when I open up the CreatingUserAccounts page of this tutorial. When I hit the button 'Create the User Account,' nothing happens. And no record is inserted into the database.Here is my web.config file (if you need any other files then please let me know and I can post them but it is my understanding that this is the only file responsible for the database connection):<?xml version="1.0"?><!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration> <appSettings/> <connectionStrings> <add name="SecurityTutorialsConnectionString" connectionString="Server=localhost;Database=SecurityTutorials;User Id=SecurityTutorials;Password=**********;" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web> <membership defaultProvider="SecurityTutorialsSqlMembershipProvider"> <providers> <!--Add a customized SqlMembershipProvider --> <add name="SecurityTutorialsSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="SecurityTutorialsConnectionString" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="SecurityTutorials" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/> </providers> </membership> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <compilation debug="false" /> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authentication mode="Forms"> <forms slidingExpiration="true" timeout="60" /> </authentication> <machineKey decryption="AES" validation="SHA1" decryptionKey="1513F567EE75F7FB5AC0AC4D79E1D9F25430E3E2F1BCDD3370BCFC4EFC97A541" validationKey="32CBA563F26041EE5B5FE9581076C40618DCC1218F5F447634EDE8624508A129" /> <!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors> --> </system.web></configuration>Note: The password is an actually password. Not sure if it'd be a good idea to post that here, even though it is a test database.Thank you all in advance for your advice!
View 1 Replies
View Related
