DotNetShoutout - Stories tagged with SQLServer

SQLServer

atom rss
2
Shouts
spam Shout it Mute it

Two ways of Implementing CRUD Operations in Aspnet with C# | Developers Code
published 453 days, 11 hours, 46 minutes ago posted by taanu51taanu51 462 days, 17 hours, 3 minutes ago
Monday, February 27, 2012 9:47:43 AM GMT Saturday, February 18, 2012 4:30:37 AM GMT
Hi friends,In this article i would like to explain the procedure of CRUD Operations in two ways.we already know Creation,Updation,Deletion operations are very Important.So lets start with First way that is Implementing CRUD operations Outside of the GRID.that means while we are the Editing GRID the data will be Bind to the Forms Controls.In the second way Inside the grid , that means while we are the Editing GRID the data will be bind inside. In my view First method is best. why because,   1. Editing... (more)
category: Web Dev | clicked: 40 | comment | | source: www.developerscode.com
tags: GridView, C#, ASPNET, SQLServer
3
Shouts
spam Shout it Mute it

what is cloud computing for beginners | DevelopersCode
posted by taanu51taanu51 655 days, 18 hours, 45 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 655 days, 18 hours, 45 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 655 days, 18 hours, 46 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 654 days, 7 hours, 17 minutes ago posted by taanu51taanu51 655 days, 18 hours, 46 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 655 days, 18 hours, 47 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: 193 | 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 655 days, 18 hours, 47 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 655 days, 18 hours, 48 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 655 days, 18 hours, 49 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
12
Shouts
spam Shout it Mute it

Many to Many Relationship Made Simpler
published 652 days, 14 minutes ago posted by pinaldavepinaldave 656 days, 11 hours, 41 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Monday, August 08, 2011 9:53:27 AM GMT
We need a new process to map this complex relationship. Sometimes tables exist for the sole purpose of allowing indirect relationships between tables. What do you call tables the handle relationships for other tables? Common terms for these type of tables are mapping tables, bridge tables, or junction tables. Learn about Many to many relationship and Win Free Book (more)
category: Data | clicked: 62 | 2 comments | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
3
Shouts
spam Shout it Mute it

Display Monthly sales information in graph using Aspnet | DevelopersCode
published 656 days, 1 hour, 34 minutes ago posted by taanu51taanu51 656 days, 12 hours, 31 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 656 days, 1 hour, 34 minutes ago posted by taanu51taanu51 656 days, 12 hours, 32 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 656 days, 1 hour, 34 minutes ago posted by taanu51taanu51 656 days, 12 hours, 33 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 656 days, 1 hour, 34 minutes ago posted by taanu51taanu51 656 days, 12 hours, 34 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
11
Shouts
spam Shout it Mute it

Learning SQL Server - Efficient Query Writing Strategy - Gift Book
published 652 days, 14 minutes ago posted by pinaldavepinaldave 660 days, 3 hours, 48 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Thursday, August 04, 2011 5:45:47 PM GMT
Some people may push back on this next technique or misunderstand until getting to the very end. The goal is to have fewer errors as you write complex queries more quickly by making sure the easy stuff works first. (more)
category: Data | clicked: 56 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
2
Shouts
spam Shout it Mute it

Default FileStream filegroup is not available in database 'DatabaseName'
published 666 days, 4 hours, 25 minutes ago posted by eralpereralper 667 days, 10 hours, 54 minutes ago
Friday, July 29, 2011 5:09:28 PM GMT Thursday, July 28, 2011 10:39:44 AM GMT
With SQL Server 2011, a new table type FileTable is introduced for SQL Server developers and administrators. To create FileTable is easy but has some prerequisites. Before completing these prerequisites if t-sql developers try to create FileTable using CREATE TABLE command, the following SQL Engine error might happen Msg 1969, Level 16, State 1, Line 1 Default FILESTREAM filegroup is not available in database 'DatabaseName' (more)
category: Data | clicked: 14 | comment | | source: www.kodyaz.com
tags: SQL Server, denali, SQLServer, FILESTREAM, sql 2011, SQL Server 2011
10
Shouts
spam Shout it Mute it

Find Nth Record Quickest Way in SQL Server
published 664 days, 1 hour, 42 minutes ago posted by pinaldavepinaldave 668 days, 1 hour, 36 minutes ago
Sunday, July 31, 2011 7:52:05 PM GMT Wednesday, July 27, 2011 7:58:14 PM GMT
A Very simple tutorial to find Nth Record (more)
category: Data | clicked: 47 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
2
Shouts
spam Shout it Mute it

SQL LEAD() Function in SQL Server 2011 for Calculating Next Value
posted by eralpereralper 675 days, 14 hours, 38 minutes ago
Wednesday, July 20, 2011 6:56:08 AM GMT
SQL LEAD() function is one of the recent enhancements among SQL Analytic Functions introduced with Denali, CTP3 for SQL Server 2011 developers. What SQL Server Lead() function does is returning simply the next Nth row value in an order (more)
category: Data | clicked: 2 | comment | | source: www.kodyaz.com
tags: function, SQLServerDenali, T-SQL, SQLServer
5
Shouts
spam Shout it Mute it

Arabic Series in Microsoft SQL Server– Part2 Database Infrastructure « Technical tips around you
posted by https://me.yahoo.com/mosessaur#7fe0dhttps://me.yahoo.com/mosessaur#7fe0d 679 days, 20 hours, 16 minutes ago
Saturday, July 16, 2011 1:17:37 AM GMT
Arabic Series in Microsoft SQL Server– Part2 Database Infrastructure (more)
category: Data | clicked: 6 | comment | | source: ahmedmosa.wordpress.com
tags: SQL Server 2008, SQL, SQLServer
3
Shouts
spam Shout it Mute it

New Arabic Series in Microsoft SQL Server– Part1 Database Infrastructure « Technical tips around you
published 678 days, 12 hours, 56 minutes ago posted by https://me.yahoo.com/mosessaur#7fe0dhttps://me.yahoo.com/mosessaur#7fe0d 679 days, 20 hours, 17 minutes ago
Sunday, July 17, 2011 8:37:44 AM GMT Saturday, July 16, 2011 1:16:58 AM GMT
New Arabic Series in Microsoft SQL Server– Part1 Database Infrastructure (more)
category: Data | clicked: 4 | 1 comment | | source: ahmedmosa.wordpress.com
tags: SQLServer
Previous 1 2 3 4 5 6 7 8 9 Next