|
|
Post by Admin on Feb 9, 2014 21:36:32 GMT
Part 2 of 'Create a website with ASP.Net' www.codingcubes.com/Pages/Video.aspx?id=3Video tutorial about how to create a SQL Server database, connect it to an Asp.Net website and diplay its content in a dynamic webpage |
|
|
|
Post by Enamul on Mar 10, 2014 9:12:10 GMT
Hi Admin, I am trying learn c# by studying your tutorial .Now I have faced a problem to connect with database .Now i am writing the error , please reply my asking.
"A network related or instance-specific error occurred while establishing a connecting to sql server.
Error-40(could not open a connection to SQL Server)"
|
|
|
|
Post by mdenamul on Mar 10, 2014 9:33:44 GMT
Part 2 of 'Create a website with ASP.Net' www.codingcubes.com/Pages/Video.aspx?id=3Video tutorial about how to create a SQL Server database, connect it to an Asp.Net website and diplay its content in a dynamic webpage Hi Admin, I am trying learn c# by studying your tutorial .Now I have faced a problem to connect with database .Now i am writing the error , please reply my asking. "A network related or instance-specific error occurred while establishing a connecting to sql server. Error-40(could not open a connection to SQL Server)" |
|
|
|
Post by Admin on Mar 10, 2014 9:51:43 GMT
|
|
|
|
Post by mdenamul on Apr 5, 2014 6:55:49 GMT
Admin ,Thanks you very much for your reply .I have setup OS and install sql server and now I am out of problem.
|
|
|
|
Post by mdenamul on Apr 5, 2014 7:05:41 GMT
Hi, I am using .netframwork 4.0 version .Can I run the projecet with the framwork ?Beside i want to know the pre-required soft info for the connecting database .It needs the connecting with the team server.
please reply soon.
|
|
|
|
Post by mdenamul on Apr 5, 2014 7:16:46 GMT
Besides , I have done something of this part but i can not get the dropdownlist1's + lblouput1's library in the coffee.aspx.cs .Now how can I get solved.
|
|
|
|
Post by AnaMariaB on May 16, 2014 14:55:55 GMT
Hello.Please help me!I have followed all your tutorials by i'm geting the error:'Coffee' does not contain a constructor that takes 4 arguments, and the warning :
Warning 2 The type 'Coffee' in 'c:\Users\AnaMariaB\AppData\Local\Temp\Temporary ASP.NET Files\root\3b284d7e\91b021cf\App_Web_czv44unk.3.cs' conflicts with the imported type 'Coffee' in 'c:\Users\AnaMariaB\AppData\Local\Temp\Temporary ASP.NET Files\root\3b284d7e\91b021cf\App_Code.gwcgj4s0.dll'. Using the type defined in 'c:\Users\AnaMariaB\AppData\Local\Temp\Temporary ASP.NET Files\root\3b284d7e\91b021cf\App_Web_czv44unk.3.cs'. c:\Users\AnaMariaB\AppData\Local\Temp\Temporary ASP.NET Files\root\3b284d7e\91b021cf\App_Web_czv44unk.2.cs 185
|
|
|
|
Post by Kabelo on Aug 5, 2014 14:28:47 GMT
Hi I'm using Visual Studio 2013 I can't believe that I've learned so much in just part 1 of your Tutorial #GodBless so far the part 1 of your tutorial was ok but now the part I'm getting an error for in the ConnectionClass.cs "SqlDataReader reader = command.ExecuteReader(); it says the type of name space could not be found.
Also I'm getting an error in the Coffee.aspx page for coffeeList = ConnectionClass.GetCoffeeByType("%"); in the "if else statement"
|
|
|
|
Post by Damien on Oct 2, 2014 14:36:50 GMT
hi, I'm am following your tutorials and they are brilliant. In part two however when I open up sql server management system it wanted me to connect to a server? how do I do this?
|
|
|
|
Post by Admin on Oct 7, 2014 11:52:02 GMT
hi, I'm am following your tutorials and they are brilliant. In part two however when I open up sql server management system it wanted me to connect to a server? how do I do this? Hi Damien, To connect to a local database instance using Sql Server Management Studio, use the following login credentials Server Type: Database Engine Server Name: LOCALHOST\SQLEXPRESS (Or .\SQLEXPRESS) Authentication: Windows Authentication  |
|
|
|
Post by usman on Nov 10, 2014 20:19:40 GMT
I want to Code of Database which u copy in ur part2 tutorials please
|
|
|
|
Post by Admin on Nov 13, 2014 9:52:38 GMT
I want to Code of Database which u copy in ur part2 tutorials please CREATE TABLE [dbo].[coffee]
(
[id] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[name] [varchar](50) NOT NULL,
[type] [varchar](50) NOT NULL,
[price] [float] NOT NULL,
[roast] [varchar](50) NOT NULL,
[country] [varchar](50) NOT NULL,
[image] [varchar](255) NULL,
[review] [text] NOT NULL
)
INSERT [coffee] VALUES (
N'Café au Lait', N'Classic', 2.25, N'Medium', N'France',
N'../Images/Coffee/Cafe-Au-Lait.jpg',
N'A coffee beverage consisting strong or bold coffee (sometimes espresso)
mixed with scalded milk in approximately a 1:1 ratio.')
INSERT [coffee] VALUES (
N'Caffè Americano', N'Espresso', 2.25, N'Medium', N'Italy',
N'../Images/coffee/caffe_americano.jpg',
N'Similar in strength and taste to American-style brewed coffee,
there are subtle differences achieved by pulling a fresh shot of espresso for the beverage base.')
INSERT [coffee] VALUES (
N'Peppermint White Chocolate Mocha', N'Espresso', 3.25, N'Medium',
N'Italy', N'../Images/coffee/white-chocolate-peppermint-mocha.jpg',
N'Espresso with white chocolate and peppermint flavored syrups and steamed milk.
Topped with sweetened whipped cream and dark chocolate curls.')
INSERT [coffee] VALUES (
N'Irish Coffee', N'Alcoholic', 2.25, N'Dark', N'Ireland',
N'../Images/coffee/irish coffee.jpg',
N'A cocktail consisting of hot coffee, Irish whiskey, and sugar, stirred, and topped with thick cream.
The coffee is drunk through the cream.')There you go  |
|
|
|
Post by Lelas on Dec 25, 2014 21:01:31 GMT
Hi I'm using Visual Studio 2013 I can't believe that I've learned so much in just part 1 of your Tutorial #GodBless so far the part 1 of your tutorial was ok but now the part I'm getting an error for in the ConnectionClass.cs "SqlDataReader reader = command.ExecuteReader(); it says the type of name space could not be found. Also I'm getting an error in the Coffee.aspx page for coffeeList = ConnectionClass.GetCoffeeByType("%"); in the "if else statement" I have the same problem  |
|
|
|
Post by rockzen on Apr 29, 2015 9:04:05 GMT
Hi, Thanks a lot for the nice tutorial.
I have created Home.aspx (based on MasterPage) inside Pages folder. When I run Home.aspx, I get an error "$ is undefined" and when I say "Yes" to debug, the cursor stops at :
$(document).ready(function () {
mainmenu();
});
If I continue, I won't get the dropdown under Reviews in the NavBar.
However, when I create a Homepage based on Masterpage directly (not inside a sub-folder, like, Pages), then the page runs without any issues, and I get the dropdown under Reviews.
Can you please tell me where am I going wrong?
|
|
