DotNetShoutout - Stories tagged with SqlServer 2008

SqlServer 2008

atom rss
3
Shouts
spam Shout it Mute it

what is cloud computing for beginners | DevelopersCode
posted by taanu51taanu51 651 days, 16 hours, 3 minutes ago
Tuesday, August 09, 2011 2:49:08 AM GMT
In simple terms "cloud computing" means accessing the database resources via internet.the best examples are google applications,facebook,etc..,let me explain in clearly if your'e searching an article in google search it will retrieve the necessary information from their databases via internet this is called cloud computing.At the same time if you post an article in facebook it will be store the data in their databases via internet this is also called "cloud computing". The major advantages of using Cl... (more)
category: Web Dev | clicked: 20 | comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, ASP .NET, SQLServer, C# .NET
3
Shouts
spam Shout it Mute it

How to develop User Defined Events | DevelopersCode
posted by taanu51taanu51 651 days, 16 hours, 3 minutes ago
Tuesday, August 09, 2011 2:48:45 AM GMT
when part of user controls logic and part of form's logic need to be executed at one shot then user defined events are requiredUser Defined events are also called as "Call Back procedure"User Defined events works with the help of "Delegates" Steps to develop user Defined EventsStep1:Create a Delegatesyntax : public delegate void Delegatename(); step2)create an event with the help of Delegatesyntax:public event delegatename Eventname; step3)paise the event syntax : eventname(); step4)define the even... (more)
category: Web Dev | clicked: 30 | comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, ASP .NET, SQLServer, C# .NET
4
Shouts
spam Shout it Mute it

Apply sound Effects for validations in aspnet application | DevelopersCode
posted by taanu51taanu51 651 days, 16 hours, 4 minutes ago
Tuesday, August 09, 2011 2:48:21 AM GMT
Hi friends ,we already know how to set the server side validations for our controls in aspnet applications but this time we will try differently that means In this tutorial i would like to explain how to set sound validations for our Asnet controls when an error occurs. so lets start... First Open the visual studio 2008 Next,select one web application Next,Drag and drop two textboxes and one button from ToolBox Next,change the properties for textboxes Now apply the validations for that... (more)
category: Web Dev | clicked: 62 | comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, ASP .NET, SQLServer, C# .NET
4
Shouts
spam Shout it Mute it

what is Abstract classes and abstract methods with example | DevelopersCode
published 650 days, 4 hours, 35 minutes ago posted by taanu51taanu51 651 days, 16 hours, 4 minutes ago
Wednesday, August 10, 2011 2:17:19 PM GMT Tuesday, August 09, 2011 2:47:56 AM GMT
Hi friends,i would like to share some important points about abstract classes and abstract methods with example1)Abstract is a keyword which can be used with methods and classes2)whenever a class is not providing full functionality then recommended to declare that class as "Abstract Class" 3)we cannot create a object of abstract class name n=new name();//object is not possiblename n;//reference is possible 4)Refernce works with the help of chile class name n=new gender(); 5)abstract classes are sim... (more)
category: Web Dev | clicked: 59 | 1 comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, ASP .NET, SQLServer, C# .NET
4
Shouts
spam Shout it Mute it

Display login form with jquery light box effect in Aspnet | DevelopersCode
posted by taanu51taanu51 651 days, 16 hours, 5 minutes ago
Tuesday, August 09, 2011 2:47:31 AM GMT
Hi friends ,In this tutorial i would like to explain "How to apply jquery lightbox effect in Aspnet" clearly in step by step.just follow the stepsFirst,open the visula studio 2008Next,Select the aspnet web applicationNext,open the Design view of Default.aspx page Next,Drag and drop the Two labels,Two TextBoxes and Two Buttons Next,change the properties for Button 1 Like this, Id ="showedit" Text="Login" Next open the Source page of Default.aspx page and add this code In the Head section add thi... (more)
category: Web Dev | clicked: 191 | 1 comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, ASP .NET, SQLServer, C# .NET
4
Shouts
spam Shout it Mute it

What is ADO.NET | DevelopersCode
posted by taanu51taanu51 651 days, 16 hours, 5 minutes ago
Tuesday, August 09, 2011 2:47:07 AM GMT
Hi friends,i would like to explain some basic concepts about ADO.NET for beginners what is a Database A Database of interrelated data is called as Database Database are divided into 3 types What is ADO..? ADO means ActiveX Data Objects ADO.NET is an oject  library (collection of classes ) which is used to commincate with databases ADO.NET helps to develop client server architecture ADO.NET supports two types of connections a)managed connection b)Unmanaged connection ... (more)
category: Web Dev | clicked: 32 | 1 comment | | source: www.developerscode.com
| flag as spam
tags: C#, c sharp, ASPNET, SqlServer 2008, ASP .NET, SQLServer, C# .NET
3
Shouts
spam Shout it Mute it

Display Hourly(12Hours or 24 hours) sales information in graph using Aspnet | DevelopersCode
posted by taanu51taanu51 651 days, 16 hours, 6 minutes ago
Tuesday, August 09, 2011 2:45:50 AM GMT
Hi friends In this article i would like to explain "How to bind daily working hours data in graph with the help of ms chart control in Aspnet" First,open the sql server 2008 Next select the NewQuery and check the following query SELECT CONVERT(VARCHAR(2),Datetime,108) as Date,COUNT(sales) AS count FROM PRODUCTS WITH (NOLOCK) WHERE (Datetime BETWEEN DATEDIFF([day], -0, GETDATE()) AND GETDATE()) GROUP BY CONVERT(VARCHAR(2),Datetime,108) ORDER BY Date ASC Next,click on the execute button then it... (more)
category: Web Dev | clicked: 30 | comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, chart, ASP .NET, SQLServer, Chart Control, C# .NET
3
Shouts
spam Shout it Mute it

Display daily sales information in graph using Aspnet | DevelopersCode
posted by taanu51taanu51 651 days, 16 hours, 7 minutes ago
Tuesday, August 09, 2011 2:45:04 AM GMT
Hi friends In this article i would like to explain "How to display daya by day information in graph with the help of ms chart control in Aspnet"First,open the sql server 2008Next select the NewQuery and check the following query SELECT CONVERT(VARCHAR(5),DateTime,101) as Date, COUNT(sales) AS count FROM Products WITH (NOLOCK) WHERE DateTime BETWEEN @fromDate AND @todate GROUP BY CONVERT(VARCHAR(5),DateTime,101) ORDER BY Date ASC Next,click on the execute button then it will display the data in hourly wi... (more)
category: Web Dev | clicked: 27 | comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, chart, ASP .NET, SQLServer, Chart Control, C# .NET
3
Shouts
spam Shout it Mute it

Display Monthly sales information in graph using Aspnet | DevelopersCode
published 651 days, 22 hours, 52 minutes ago posted by taanu51taanu51 652 days, 9 hours, 49 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 9:02:57 AM GMT
Hi friends In this article i would like to explain "How to display monthly information in graph with the help of ms chart control in Aspnet" First,open the sql server 2008 Next select the NewQuery and check the following query SELECT month(DateTime) AS [Month] as Date, COUNT(sales) AS count FROM Products WITH (NOLOCK) WHERE DateTime BETWEEN @fromDate AND @todate GROUP BY month(DateTime) ORDER BY month(DateTime) Next,click on the execute button then it will display the data in hourly wise of the... (more)
category: Web Dev | clicked: 27 | 1 comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, XML, SqlServer 2008, ASP .NET, SQLServer, C# .NET, datasource
3
Shouts
spam Shout it Mute it

How to add a MS Chart Control to Toolbox in dotnet | DevelopersCode
published 651 days, 22 hours, 52 minutes ago posted by taanu51taanu51 652 days, 9 hours, 50 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 9:02:25 AM GMT
Hi Friends so many friends and my readers asked me to explain the procedure of adding the MS chart control to toolbox.Here i am going to explain the procedure of adding the MS chart control First,We have to download the MS Chart exe file  For Download click here After the downloading the file,install the file into your system Next,open the program files folder which is located in C drive Next ,open the MS chart control folder,in that we have assemblies folder Next,open the fold... (more)
category: Web Dev | clicked: 9 | 1 comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, XML, SqlServer 2008, ASP .NET, SQLServer, C# .NET, datasource
3
Shouts
spam Shout it Mute it

Add Xml Datasource to gridview DropDown list | DevelopersCode
published 651 days, 22 hours, 52 minutes ago posted by taanu51taanu51 652 days, 9 hours, 51 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 9:00:46 AM GMT
HI friends ,In this article i would like to explain "how to bind XML Datasource to Dropdown list" just follow the steps clearly First we need to create a XML file to store the data.suppose you would like to store contries data in xml file and bind that data to Dropdown list Step 1:Add new Xml file to your existing Aspnet project Step 2:copy the following code in to XML file   Step 3:save the file with countries.xml Step 4:now open the page which contains Gridview Step 5: Now add the following... (more)
category: Web Dev | clicked: 10 | 1 comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, XML, SqlServer 2008, ASP .NET, SQLServer, C# .NET, datasource
3
Shouts
spam Shout it Mute it

How to Send a Mail Using Aspnet with C# | DevelopersCode
published 651 days, 22 hours, 52 minutes ago posted by taanu51taanu51 652 days, 9 hours, 52 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 8:59:35 AM GMT
Hi Friends, In this article i would like to explain the procedure of Sending a mail in Aspnet with c#.I am already explained the procedure of sending a mail with multiple attchaments.Now ,In this article i am going to exaplin only sending a mail in a particular format using Aspnet and C# Just Follow the steps First,open the Default.aspx page Next,ADD some controls from Your Toolbox.that is,Add three Textboxes(one for From Address,another for TO Address and Third one for Bodyof the message) Next,Add... (more)
category: Web Dev | clicked: 19 | 1 comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, SqlServer 2008, Email, ASP .NET, SQLServer, C# .NET, SMTP
3
Shouts
spam Shout it Mute it

Step by step procedure to create dynamic pie Chart using Dynamic Controls | DevelopersCode
published 651 days, 22 hours, 52 minutes ago posted by taanu51taanu51 652 days, 14 hours, 19 minutes ago
Monday, August 08, 2011 7:59:35 PM GMT Monday, August 08, 2011 4:33:21 AM GMT
Hi friends ,In my previous tutorial i am already explained about the creation of dynamic controls ,now i am going to explain the creation of dynamic charts with dynamic controls.just follow the stepsstep 1: First download the MS Chart control from this below linkAfter downloading the file, Unzip the file and save the file in your local system step 2: open the visual studio 2008 and select one new aspnet website and change the name as Dynamicpiechart and press ok step 3: Next,Right click o... (more)
category: Web Dev | clicked: 8 | 1 comment | | source: www.developerscode.com
tags: C#, c sharp, SqlServer 2008, chart, ASP .NET, Chart Control, C# .NET
5
Shouts
spam Shout it Mute it

Display Events in Calendars from database in Aspnet | DevelopersCode|A Technology Blog For .Net and Android Developers
posted by taanu51taanu51 656 days, 9 hours, 58 minutes ago
Thursday, August 04, 2011 8:53:35 AM GMT
Hi friends,In this article i am going to explain the procedure of display evens in calendar from database in aspnet.Here we need to create two forms ,one for adding events in the form and another one for displaying that events in the calendar and gridview.so lets start how to do this First,we need to create a Entry form where we are going to enter the events For this,Select a new Web form and change the name as per your requirment.Here i am using the default name as Default.aspx NextAdd t... (more)
category: Web Dev | clicked: 30 | comment | | source: www.developerscode.com
tags: C#, c sharp, ASPNET, Control, ASPNETMVC, SqlServer 2008, ASP .NET, Database, Calendar, C# .NET, aspnetajax
5
Shouts
spam Shout it Mute it

how to store data in sqlserver from dynamically created controls
posted by taanu51taanu51 798 days, 15 hours, 23 minutes ago
Tuesday, March 15, 2011 3:28:52 AM GMT
Hi,In my previous article i am explained how to create a dynamic controls Now i would like to explain how to store the data in sqlserver from this dynamic controls and how to kept validations for this dynamic controls.. First,Open the MIcrosoft visual studio 2008 Next,Create one Asp.Net Web application Next,Open the Design page of the Default.aspx Next,Drag and Drop one Textbox and Two Buttons from the ToolBox and change the names of the buttons as AddTextBoxes and Submit Next,come to... (more)
category: Web Dev | clicked: 2 | comment | | source: taanu51.blogspot.com
tags: C#, ASPNET, SqlServer 2008, dynamically
4
Shouts
spam Shout it Mute it

Creation of SQL DATABASE using COMMAND PROMPT
published 811 days, 6 hours, 46 minutes ago posted by taanu51taanu51 812 days, 5 hours, 51 minutes ago
Wednesday, March 02, 2011 12:06:07 PM GMT Tuesday, March 01, 2011 1:00:41 PM GMT
Hi Friends,In this Article we will discuss the creation of sql database using Command line In Windows Operating System,First we have to click on the Start button and then click Run and Type cmd in Run command and press ok For, Access the Database  Type the following command in the command prompt C:\Program Files\Microsoft SQL Server\90\Tools\Binn>SQLCMD -SUSER\SQLEXPRESS -E Where USER\SQLEXPRESS is the server name and -E for Windows Authentication if... (more)
category: Web Dev | clicked: 3 | 1 comment | | source: taanu51.blogspot.com
tags: C#, c sharp, ASPNET, SqlServer 2008, command line, ASP .NET 4, C# .NET
2
Shouts
spam Shout it Mute it

SQL Trigger Example in SQL Server 2008
published 940 days, 21 hours, 24 minutes ago posted by eralpereralper 942 days, 8 hours, 9 minutes ago
Saturday, October 23, 2010 9:27:43 PM GMT Friday, October 22, 2010 10:43:30 AM GMT
What is SQL Server Trigger An SQL trigger can contain sql codes that are executed automatically by SQL Server engine when a certain event occurs. Since this sql tutorial is concentrated on DML (Data Manipulation Language) concepts right now, our sql code examples will be a DML sql trigger. And the following SQL Server trigger definition will be valid for DML commands. The events that trigger SQL Server triggers which are actually stored t-sql codes are sql INSERT, UPDATE and DELETE statements executed... (more)
category: Data | clicked: 3 | comment | | source: www.kodyaz.com
tags: SqlServer 2008, SQL, T-SQL, Trigger, SQLServer, sqlserver2005
10
Shouts
spam Shout it Mute it

Interesting enhancements to the VALUES Clause in SQL Server 2008 - Madhivanan's TSQL Blog
published 1015 days, 8 hours, 19 minutes ago posted by jacobsebastianjacobsebastian 1016 days, 9 hours, 4 minutes ago
Tuesday, August 10, 2010 10:32:44 AM GMT Monday, August 09, 2010 9:48:00 AM GMT
With SQL Server 2008, you can do many more interesting things using VALUES clause than the previous versions.The following examples will explain it's various usages in detail (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: TSQL, SqlServer 2008, SQLServer
5
Shouts
spam Shout it Mute it

Visual Studio –>Add Database –> Named pipe Provider Error for SQL Server
published 1023 days, 7 hours, 5 minutes ago posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1024 days, 8 hours, 10 minutes ago
Monday, August 02, 2010 11:46:52 AM GMT Sunday, August 01, 2010 10:41:42 AM GMT
Recently I have been working on a article for my blog for that I just tried to add a database file on my solution with visual studio and I have received following error. An error has occurred while establishing a connection to the server. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 5) An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2008, this failure may be caused by... (more)
category: Data | clicked: 2 | comment | | source: jalpesh.blogspot.com
tags: SqlServer 2008, SQL 2008 R2
3
Shouts
spam Shout it Mute it

Reboot require check fails while installing SQL Server 2008 R2 Express
posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 1026 days, 11 hours, 3 minutes ago
Friday, July 30, 2010 7:48:46 AM GMT
Before some days i was installing SQL Server 2008 R2 Express edition on my machine and every time when it runs checks for required settings it was failing giving error reboot required. I have rebooted my machine several time and result was same. After that i have search it on internet and found that was due to some registry settings. To pass this check you need to remove following entries.Go to HKEYLOCALMACHINE\SYSTEM\CurrentControlSet\Control\Session   Manager  Then find PendingFileRenameOperations an... (more)
category: Data | clicked: 0 | comment | | source: jalpesh.blogspot.com
tags: SqlServer 2008, SQL 2008 R2
Previous 1 2 Next