Sharing my .net C# VB ASP SQL XNA knowledge.

How to which control effect to post back? ASP.net C#

2011-10-05T22:29:00.000-07:00

How to which control effect to post back?
When we developing web base application we want to know which control effect to post back. In here we can do simple approach to find out control which effect to post back.

This is the simple method which can be found out the control. In here we have to pass the page as the parameter. In this example I assume that there are few buttons on my web page and I want to know which button force to post back.

///Method to find out control force to post back.

public static Control GetPostBackControl(Page page)
{
Control control = null;

string ctrlname = page.Request.Params.Get("__EVENTTARGET");
if (ctrlname != null && ctrlname != string.Empty)
{
control = page.FindControl(ctrlname);
}
else
{
foreach (string ctl in page.Request.Form)
{
Control c = page.FindControl(ctl);
if (c is System.Web.UI.WebControls.Button)
{
control = c;
break;
}
}
}
return control;
}

////
Method call
Control _ctlPostback =GetPostBackControl(this.Page);

By using this one you can do what ever thing according to your requirements.
In here i am use switch case to find out control.

if (_ctlPostback != null){
switch(_ctlPostback.ClientID.ToString())
{
#region
case "ctl00_plcContent__butAddRuletoProduct":///your button Client ID...
{
///YOUR CODE....
break;
}
}
}

NHIbernate Simple Windows App

2010-05-31T07:47:00.000-07:00

During Pass few weeks I tried to understand about NHibernate. Really when I start doing to understand about NHibernate actually I have not any idea about what is NHibernate is? What power which it has? What can we do with it? So on. I knew only there is some things called NHibernate . I searched and find out some articles tutorials related to that.
NHibernate is Object Relation Mapping (ORM).
With help of simple Windows Form Application I will show easily implement NHibernate base Application.
First it is very important to find out required DLL. You can download those from.

Create Simple Windows Base Application called NHIbernateTestEx1.
Add below DLL to your reference (Simply write click, brows required DLL and add)

 NHibernate.dll
 Log4net.dll
 NHibernate.ByteCode.LinFu.dll

Figure 1 show after Add required DLL.

In this Example tutorial I will use Local Database. Next add local database to Application. Simple write click on the NHibernateTestEx1 and add new item local database and give name it to EmployeeDB.mdf
Figure 2 show local DB.
Now it is time to add App.config file to project. Simply add App.config file and write as bellow. It will do simply configuration with NHibernate.
NOTE THAT : you must add your Data base connection string on

YOUR DATA BASE CONNCTION STRING GOES HERE

Code for App.config file.

NHibernate.Dialect.MsSql2005Dialect

NHibernate.Connection.DriverConnectionProvider

NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu

Data Source=.\SQLEXPRESS;AttachDbFilename=G:\MYExperiment\NHIbernateTestEx1\NHIbernateTestEx1\App_Data\EmployeeDB.mdf;Integrated Security=True;User Instance=True

false

NHibernate.Driver.SqlClientDriver

ReadCommitted
true

Next create class call Employee.cs (This class is come from the Database table which we created. It can be any class related to database table)
Employee.cs
using System;
using System.Collections.Generic;
using System.Text;

namespace NHIbernateTestEx1
{
class Employee
{
private int _sEmpId;
private string _sEmpName;
private string _sEmpAddress;
private string _sEmpContact;

public int EmpId
{
get { return _sEmpId; }
set { _sEmpId = value; }
}
public string EmpName
{
get { return _sEmpName; }
set { _sEmpName = value; }
}
public string EmpAddress
{
get { return _sEmpAddress; }
set { _sEmpAddress = value; }
}
public string EmpContact
{
get { return _sEmpContact; }
set { _sEmpContact = value; }
}
}
}

Next write the Employee.hbm.xml file for simply mapping process. For that create XML file. And add below code to it.
NOTE THAT: class name should be the class which we created in above step. Employee and it belong to NHIbernateTestEx1 namespace (NHIbernateTestEx1.Employee)
In here id tag is for Primary key of Employee table of Database. And others are the rest of columns.

Simply create form like below.

How to create ISession Factory?
Import bellows DLL.
using NHibernate;
using NHibernate.Cfg;
using System.Reflection;
And write below OpenSesion() method. And it will return ISession.
#region ISession Factory
public ISessionFactory _iSessionFactory;

public ISession OpenSession()
{
if (_iSessionFactory == null)
{
Configuration config = new Configuration();
config.AddAssembly(Assembly.GetCallingAssembly());
_iSessionFactory = config.BuildSessionFactory();
}

return _iSessionFactory.OpenSession();
}
#endregion
Insert Method. In this method get user entered data to text boxes and it will insert into Employee database table with the help of OpenSession() and NHibernate.
#region Insert Data NHIBERNATE
public void InsertEmpData()
{
Employee emp = new Employee();
emp.EmpName = textBox_EmpName.Text.ToString();
emp.EmpAddress = textBoxEmpAddress.Text.ToString();
emp.EmpContact = textBoxEmpContact.Text.ToString();

using(ISession session=OpenSession())
{
using(ITransaction transaction=session.BeginTransaction())
{
session.Save(emp);
transaction.Commit();
}
}
}
#endregion
When Insert Button Click it will call to InsertEmpData() method.
private void buttonInsert_Click(object sender, EventArgs e)
{
InsertEmpData();
}

IIS Config for ASP web Site

2010-05-19T07:11:00.000-07:00

IIS Config...

When we try to browse web sites which published on IIS sometimes it will not be shown in localhost and it will be given some error message by saying try again, XML page can not shown or likewise. Show Figure 1 and 2.

Figure 1

Figure 2

Figure 3 shows that the Error Message.

Figure 3

IIWe can fix that problem simply following below step.

Step 1: Goto Start----> Run
and type cmd

Step 2: now you can we see CMD.
on it goto C:\ (to root by cd.. xxxx)

And goto C:\Windows\Microsoft.NET\Framwork\v2.0.50727\aspnet_regiis.exe

And next should uninstall by typing -u

C:\Windows\Microsoft.NET\Framwork\v2.0.50727\aspnet_regiis.exe -U
Figure 5 show that how to follow 2 step

Figure 5

After uninstaled it looks like figure 6

Figure 6

Step 3: Now install again

C:\Windows\Microsoft.NET\Framwork\v2.0.50727\aspnet_regiis.exe

And next should uninstall by typing -i

C:\Windows\Microsoft.NET\Framwork\v2.0.50727\aspnet_regiis.exe -i
Figure 7 show that Step 3

Figure 7

Step 4: Now follow bellow step.
C:\Windows\Microsoft.NET\Framwork\v2.0.50727\aspnet_regiis.exe -r
show figure 8 and figure 9

Figure 8

Figure 9

Now error is fixed. now you can browse web site.

How to Activate Kaspersky antivirus Trail Version.

2009-11-20T09:58:00.000-08:00

Kaspersky Antivirus is a one of the best Antivirus. But it is issue free licence therefor we can use only Kaspersky antivirus trail vision. If we found some licence key related to that it also back listed with short period time. Therefor it is very huge headache for us for who use Kaspersky Antivirus trail version.

But there is some solution for that. We can use Kaspersky Antivirus without original licence key.

Follow below simply step.

To start step it is import to check whether you have already installed Kaspersky 2009 . If you already have not install Kasperskey download. And installe.

http://www.mediafire.com/?sharekey=9cf1fd10916b4282d5a101cf914073b4f157a242d7e9bf1a

Now I assuem you already installed Kasperskey 2009.

On Kaspsky Icon right click and it will pop up window like Figure 1.

Figure 1

On that select “Setting” now it will pop up window like Figure 2.

Figure 2

On that window Goto Option Check Figure 3.

Figure 3

Now it is very important to uncheck the Self Defence. And Apply changes. Check Figure 4.

Figure 4

Now goto Kaspersky Icon on bar and Rigth click and Exit like Figure 5.

Figure 5

Now here after we want application called Kaspersky Trail Reset. If you have not that download that one.

http://www.mediafire.com/?jjnemjxdztj

It contain basically 5 files. According to your PC you can selcet Kaspersky Trail Reseter according to your PC. Figure 6 shows that 5 fills. In here I am use Win32 file. After select trail reseter according to your Pc run it.

Figure 6

If you have not disable Self-Defense it will pop up window like Figure 7. If you have already disable Self-Defense it will not be poped up. (check Figure 1,2,3 if you not disable Self-Defense )

Figure 7

After installing success it will be given alert like Figure 8.

Figure 8

Now your can activate Trial Version using your internet connection. It will be valid 30 days.

Figure 9

Figure 10

After succsing all above step now you can finish process. Check Figure 11.

Figure 11

Now you have activated Kasperskey for 30 days. And after 30 days you can do same process from step by step can activate again and again.During trail period you can do lot of actions with Kaspersky. It will be huge benefit for users who use Kaspersky trail version.

CREATE 2D GAME YOURSELF TUTORIAL 1

2009-10-31T00:25:00.000-07:00

After successfully installing Visual Studio .net and Microsoft XNA Game Studio, we can start to create Window base game or XBOX360 base game our self.

1st step:

All programs-> Microsoft XNA Game Studio

After open XNA Game studio go to
File->New->Project or (ctr+shift+N)
Now it selects XNA Game Studio under Visual C#. And select Windows Game check figure 1.

Figure 1 show that selects Windows Game.

In here you should provide the name for the game which going to create and should provide the location to save the project after that press OK button.
2nd step:
Now you can see Solution Explorer. Check Figure 2.

Figure 2

Now it is better to know about the Game.cs file. By clicking on that you can see it has basically Five methods already. Now on here we can create game using that already created methods.

1) Initialize() -(Provide Game initial information)
2) LoadContent()- (Using that load resource files such as images,videos,sound files,font and so on)
3) UnloadContent()-(Using that we can unload resource which we load using LoadContent() method)
4) Update(GameTime gameTime) –(use to update action are goes here)
5) Draw(GameTime gameTime) – (Use to draw resource which we added)
Now I think you have some idea about how the game create procedure is going. Let’s check how to add image to our Game project.
How to add image to Game Project

Before you can start drawing backgrounds, characters, or so on having in your game to the screen, you will need to add these images to your game project. The image types you can add that are supported by the Content Pipeline are .bmp, .jpg, .png and a few texture file formats. Adding the images to your project makes them available to the XNA framework's Content Importer. This will compile them as ".xnb" files when you build your game and make them accessible to the Content Importer in the code for loading and unloading.

3rd step:

To add image to game project, Right click on Content and should provide existing items. Check figure 3.

Figure 3.

Now you can brows and able to provide image to your game project. After providing image path now you can see the image which you added is added to Content Pipeline. Check Figure 4.

Figure 4

Now you have added image. And next go to Game.cs and should provide added images reference. For that should use Texture2D mickymouse2D;

Next using above added reference we must load that image to our game project for that go to LoadContent() methods and add following line mickymouse2D = Content.Load("Mickymouse"); in here “Mickymouse” is the image name which I alredy added to Content Pipe. Now I have already loaded image to my game. Now my next step is draw that load image on my screen. To do that I must use Draw(GameTime gameTime) method. And add following few line on it.

Rectangle mickymouse2DPosition = new Rectangle(100, 100, 100, 100);
spriteBatch.Begin(SpriteBlendMode.AlphaBlend);
spriteBatch.Draw(mickymouse2D, mickymouse2DPosition, Color.White);
spriteBatch.End();
base.Draw(gameTime);

in here I provide the position which my image should draw. Now press play button and you can see the image is drawn on your game screen. Check figure 5.

Figure 5

Lets check complete source code.

using System;
using System.Collections.Generic;
using Microsoft.Xna.Framework;
using Microsoft.Xna.Framework.Audio;
using Microsoft.Xna.Framework.Content;
using Microsoft.Xna.Framework.GamerServices;
using Microsoft.Xna.Framework.Graphics;
using Microsoft.Xna.Framework.Input;
using Microsoft.Xna.Framework.Net;
using Microsoft.Xna.Framework.Storage;

namespace MyGame1
{

public class Game1 : Microsoft.Xna.Framework.Game
{
GraphicsDeviceManager graphics;
SpriteBatch spriteBatch;
Texture2D mickymouse2D;

public Game1()
{
graphics = new GraphicsDeviceManager(this);
Content.RootDirectory = "Content";
}

protected override void Initialize()
{
base.Initialize();
}

protected override void LoadContent()
{
spriteBatch = new SpriteBatch(GraphicsDevice);
mickymouse2D = Content.Load("Mickymouse");
}
protected override void UnloadContent()
{
// TODO: Unload any non ContentManager content here
}

protected override void Update(GameTime gameTime)
{
if (GamePad.GetState(PlayerIndex.One).Buttons.Back == ButtonState.Pressed)
this.Exit();
base.Update(gameTime);
}

protected override void Draw(GameTime gameTime)
{
graphics.GraphicsDevice.Clear(Color.CornflowerBlue);
Rectangle mickymouse2DPosition = new Rectangle(100, 100, 100, 100);
spriteBatch.Begin(SpriteBlendMode.AlphaBlend);
spriteBatch.Draw(mickymouse2D, mickymouse2DPosition, Color.White);
spriteBatch.End();
base.Draw(gameTime);
}
}
}

Now you can add image to your games screen.

Your Comments are highly appreciated; it will be improving my knowledge also.

Create SQL Maintenance Plan in SQL Server Management Studio (SSMS)

2009-10-24T10:52:00.000-07:00

SQL Maintenance Plan plays huge role in SQL Server. Therefore I am going to explain step by step how to create SQL Maintenance Plan. Using that you can do lots of plan simultaneously.

1st Step:
Flow below path to create SQL Maintenance Plan.
After login to SSMS go to
Management-> Maintenance Plan -> Maintenance Plan Wizard
Figure 1 shows that how to start Maintenance Plan.

Figure 1

It will popup window like Figure 2.

Figure 2

Press next.

2nd Step
After following 1st step it will be pop up window like Figure 3.

Figure 3

In here can provide Name for the Maintenance Plan, description for the Maintenance plans which going to create. It will provide to select Server. And according to that can logging using Windows Authentication or SQL Server Authentication. Press Next button and it will be pop up window like Figure 4.

Figure 4

3rd Step
It asks what the plans are. According to your requirements you can provide plans which want to create. Can be check on check box which wants to create Maintenance Plan. In here I checked some plans (Figure 4) which I want to make Maintenance Plan likewise you can select whatever plans. Click on next button.

4th Step
After following above step it will be popup new window like Figure 5. Using that window can be move up down selected plans. Click on next button.

Figure 5
Next it will be popup window like Figure 6. And using that can be provide validity to database it means that what are the data base that create Maintenance Plan belong.

5th Step
Next according to 2nd step which selected plans one by one SSMS provide window and you can provide database which you want to make plan.
Figure 6 show that According to Check Database Integrity Task.

Figure 6

Figure 7 show that According to Shrink Database Task.

Figure 7

Figure 8 show that According to Rebuild Index Task.

Figure 8

Figure 9 shows that Update Statistics Task.

Figure 9

Figure 10 shows Cleanup History Task

Figure 10

Figure 11 shows that how to create Backup

Figure 11

Now all my schedule plans were finish and it will be pop up new window like Figure 12.

Figure 12

Now you can change and create new Job schedule by pressing Change button. And it will be popup window like Figure 13.

Figure 13

By pressing next it will be popup new window and next it will be process and create Maintenance Plan according to your requirements.

Your Comments are highly appreciated; it will be improving my knowledge also.

HOW TO GET SQL BACK UP

2009-10-23T11:19:00.000-07:00

When we dealing with SQL server it is very import to get the SQL Back up because some time we want back up to resort data base if data base corrupt or loosing data. Basically SQL provide facilities to get back up.
Following below step you can get easily SQL back ups

Select whatever database which wants to get back up. And right click.

Task--> Back Up…..

Figure 1 shows that the pop up window.

1) By drop downing can select back up type. (Full, Differential, Transaction Log). In here select Full option from Backup combo box.
2) Provide Suitable name and description for backup which are going to take.
3) Back up set Expire. Inhere able to provide particular day or days to expire the backups. It will defend on user requirements.
4) By pressing Add button able to add new store folder to the back. Likewise we can add more physical location for our back up. Like wise we can remove store location by pressing Remove.

By pressing ok can get SQL backup easily.

Figure 2 show that the backup which created.

As well as following above steps we all so can do same process using SQL Query.
Open Query editor
And enter code like below.

BACKUP DATABASE [Name of Database] TO
DISK =N'Backup save path\backupname.bak’
WITH NOFORMAT, NOINIT,
NAME =N'DESCRIPTION OF BACK UP',
SKIP, NOREWIND, NOUNLOAD, STATS=10
GO

By executing above query can get backup also.

Figure 3 shows that example code.

AJAX

2009-10-23T07:54:00.000-07:00

----------------------------------------------------------------------------------------

Beginning Ajax with PHP From Novice to Professional

DOWNLOAD LINK: Beginning Ajax with PHP

-----------------------------------------------------------------------------------------

C# EBOOKS

2009-10-23T07:30:00.000-07:00

-----------------------------------------------------------------------------------------
Design Patterns for Searching in C# By Fred Mellender

DOWNLOAD LINK : Design Patterns for Searching in C#
-----------------------------------------------------------------------------------------

CRYSTAL REPORT BASIC

2009-10-17T23:13:00.000-07:00

When we consider about today day today activities, information management plays huge role. It means that data is a one of the resource we have. By managing using proper manner it will be help in many ways to success our day today activities. Therefore people use various types of reports to manage those valuable assets.
As well as, when we consider about software development it also use various types of report as a output of software process. In here I am going to explain basic ways to generate report using CRYSTAL REPORT using .NET C#.
Actually crystal report is one of very powerful tool we have to generate some report which we want. Using that we can easily manage our data and able to provide very good human interactive report.
In here I am use following Data base which I created. And so on I use that Data base to generate report. Figure 1 shows that Data base diagram which I use to generate Crystal Report so on.
Data Base Name: HGSResourceMgt
Data Base Table : StuDetails, StudentSubject, Subject, TeacherDetails, TeacherSubject

Figure 1

Using .Net IDE basically we can create Crystal report though Windows Application or even Web base Application (ASP.net). In here I am explain how to generate crystal report though Windows Application using.Net C#. First of all create new project using .net C#.

1st step:
To add new crystal report to your project simply follows below step.
Solution Explore r on your project right click AddAdd New Item
After that it will gives a popup window like Figure 2. From that select crystal report and by providing name for that able to add new crystal report to project.

Figure 2

2nd Step:
After adding crystal report it will popup new window figure 3 shows that popup window it ask about crystal report type and by selecting crystal report type can create crystal report.

Figure 3

3rd Step:
Next it is very import to provide the database connection details. It means that to generate crystal report definitely we want some database connection using database we can use data which belong to that to generate Crystal report. Figure 4 show that the new popup window. By using that we can provide SQL or any type of Database connection.

Figure 4

Step 5:
Next it will popup window like Figure 5. And using that window can be providing suitable Database connection to crystal report. In here I provide” Microsoft OLE DB Provider for SQL Server “.

Figure 5

6th Step:
Figure 6 show that popup window by providing SQL Server, UserID, Password and Database which going to create crystal report by using Data.

Figure 6
After providing SQL connection detail, it will popup new window like Figure 7. And it will show the SQL Database details which added to crystal report.

Figure 7

Step 7:
Now according to your purpose (To create crystal report using Data base) you can select whatever database table which belong o OLE DB(ADO) . By selecting suitable table you can add them to crystal report and here on you can deal with them and generate reports using data from that table which added. Figure 8 shows that how add database table.

Figure 8

After that simply by click on Next button it will popup window like Figure 9 and I will provide basic details which related to that.

Figure 9

8th Step:
After finishing above steps now it will create basic crystal report. Figure 10 shows that basic crystal report and basically it has five sections. Each and every section has own task and you can do whatever things using that.

Figure 10

Your Comments are highly appreciated; it will be improving my knowledge also.

SQL SERVER START/STOP 2

2009-10-11T09:37:00.000-07:00

SQL SERVER START/STOP

To start, stop or even refresh or so on the SQL Services we can use SQL Server. Follow below steps and you can easily identify how to manage SQL Services.

All Programs -> Microsoft SQL Server 2005 -> Configuration Tool -> SQL Server Configuration Manager

By following above steps you can see form like figure 1.

Figure 1

Basically it gives all the services avaliable currently and provide more information relating to that services.

By simply right clicking on the services you can easily start,stop,pause,rename,restart each and every services. And also by selecting propertise you can do more thing related to that services. Figure 2. According to Figure 2 the red circle indicate that using that button you can stop services or restart.

Figure 2

Your Comments are highly appreciated; it will be improving my knowledge also.

SQL SERVICES START/STOP 1

2009-10-10T22:54:00.000-07:00

SQL SERVICES START/STOP

It is very important to know about the SQL Services when we are working with SQL. Without knowing about SQL services and its function it will be hard to manage SQL. Therefore first of all I would like to show you how do we get to know about SQL Server.

Follow thess steps and it will be very easy to know about SQL services.

Go to :

My Comuper right click -> Manage -> Services And Application -> Services

After that you can see all the services currently avaliable on your PC. By scrolling also you can find out all the SQL Services currently avaliable on your PC. Check Figure 1.

Figure 1 shows that all the SQL Services avaliable on my PC.

Next simply right clicking on that services you can even Start the services which was stopped, Pause, restart and so on. And ever you can refresh the services currently running on your PC. check Figure 2.

Figure 2

By clicking on the Properties on the popup, you can see a form like Figur 3. Using that you can easily can manage your services. It gives that the Service name, discription and the path to execute. And also using that you can set Start type of each services such as Automatic, Manual or Disabled. As well as by using that you can check about Dependencies of that selected Services.

Figure 3

Your Comments are highly appreciated; it will be improving my knowledge also.

How to create a View using SQL Server Management Studio 2005.

2009-10-05T11:14:00.000-07:00

When we dealing with database it is very important to know about the Views of Database it will be help to create suitable SQL Statement and after createing that Views we can esily use them to do some task on our .net C# or VB application. Simply following below step you can create SQL Views.

1st step:

As a 1st step you must decide what is the database which you are going to create SQL Views. After that you can find number of option avalible with that selected data base. in here you must select View from that. Figure 1 show that Selecting View. By write clicking on that View and selecting New View you can create new view to you data base.

Figure 1 shows that how to create SQL View

2nd step:

After doing 1st step it asks what are the data base table to use to create the SQL Views. In here according to your requirement you can provide suitable data base table for your SQL Views. Figure 2 shows that how to add data base tables to SQL View.

Figure 2

3rd step:

After that I looks like Figure 3. In here you can do what ever SQL Statements with the Data base table which added to the SQL View. And after by providing suitable name for SQL View can create SQL View.

Figure 3

By following above three steps esaly can create SQL Views.

Your Comments are highly appreciated; it will be improving my knowledge also.

How to create new user login to SQL Server.

2009-10-05T10:32:00.000-07:00

When we install Microsoft SQL Server Management Studio 2005, during instaltion it will asked the password for SA account (Sa is a default login to SQL Server). In that step provide suitable password for default Sa account. After installed the Sql Server.

You can create user login accoding to your preferences.

1st step:

First of all it is must to loged in using SA account. After loged SA account go to Security of that account and it contain login and by write clicking you can add new login. Figure 1 show that how to create new login to SQL Server.

Figure 1 show that how to create Logins

2nd step:

After create logins, in the Genereal Tab of that open form, it ask what is login name, password and what is default data base and so on by providing that information. Figure 2 show that how to add login details.

Figure 2 show that how to add login details

3rd step:

Next in Server Role on Select page click. It provide such a form Figure 3.
In that select sysadmin.

Figure 3 show Server Role

4th step:

Next select Securables and it gives such a form Figure 4. In that form should select the server which we decide to use to create Logins.

Figure 4 show that how securable handle

5th step

Next should provide the status of the Logins. Figure 5 show that how to provide Permision to the data base.

Figure 5

After following above steps carefully it will be create new logins.

Your Comments are highly appreciated; it will be improving my knowledge also.

SQL TRANSACTION .net C#

2009-10-05T04:19:00.000-07:00

It is possible to work with more than one SQL Statement in a time. It means that if we want to insert data to database table as well as update data on database table as well as delete or so on at a same time. To handle such situation SQL Transaction will be helped to do work with more than one SQL Statement at a time. Using SQL Transaction it is very easy to work with multiple SQL Statements. When implement some SQL Transaction it check all SQL Statements execute perfectly it means that Committed or otherwise it will be rollback no SQL Statements execute.

Following below step easy to create SQL Transaction

Create SQL Connection and SQL Data Reader object
SqlConnection conn =new SqlConnection(“SQL CONNCTION STRING IS GOING HERE”);
SqlDataReader rdr = null;

Open SQL Connection
Conn.open()
Begging SQL transaction
SqlTransaction dbTrans = dbConnection.BeginTransaction();

try
{
//Set Transaction object to Sqlcommand
SqlCommand dbCmd = dbConnection.CreateCommand();
dbCmd.Transaction = dbTrans;

//SQL STATEMENT GOES HERE YOU CAN ADD ANY NUMBER OF SQL STATEMNET

//IF SQL STATEMENT EXECUTE Transction will be Commit
dbTrans.Commit();

}
catch (Exception qe)
{
//IF ANY error occure Transaction will be rollback
dbTrans.Rollback();
}
finally
{
//Close Database Connection
Conn.close();
}

Your Comments are highly appreciated; it will be improving my knowledge also.

Sending Parameters to Stored Procedures

2009-10-05T02:06:00.000-07:00

Using parameters for stored procedures is the same as using parameters for query string commands. The following code shows this:

// 1. create a command object identifying
// the stored procedure
SqlCommand cmd = new SqlCommand(
"CustOrderHist", conn);

// 2. set the command object so it knows
// to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;

// 3. add parameter to command, which
// will be passed to the stored procedure
cmd.Parameters.Add(
new SqlParameter("@CustomerID", custId));

1st and 2nd steps are use to execute stored procedure. And 3rd step is use to provide the suitable parameter according to the stored procedure.
In here we can add Parameters. For that use cmd.Parameters.Add(new SqlParameter(“@param”,xxxx)).

According to above example I have mention above @Variable take single parameter. And we can parse value to that parameter according to our requirement.

Your Comments are highly appreciated; it will be improving my knowledge also.

Executing a Stored Procedure

2009-10-05T01:31:00.001-07:00

When we consider about the SqlCommand type it has basically Stored Procedure, Table Direct and Text. Therefore we can easily provide the SqlCommand type as a Stored Procedure. And can be used to execute it. To success that basically it should require two tasks.

• SqlCommand object should know which Stored Procedure to Execute.
• SqlCommand object that it is executing a stored procedure

These two steps are shown below.

// 1. create a command object identifying
// the stored procedure
SqlCommand cmd = new SqlCommand(
"Name of Stored Procedure to Execute", conn);

// 2. set the command object so it knows
// to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;

According to that SqlCommand object have two parameter first one is the Name of the Stored Procedure which you are going to execute. And next parameter is the data base connection.

As second step it shows that it selected command type property as a Stored Procedure it is very important. Otherwise it will not be work properly according to our purpose.

Your Comments are highly appreciated; it will be improving my knowledge also.

Create Stored Procedure Using MS SQL Mgt Studio

2009-10-05T01:31:00.000-07:00

Stored procedure Introduction

When we consider about the SQL Stored Procedure basically it is a one of the powerful characteristic which SQL Server exits. Basically Stored Procedure has following characteristic.

• Pre- Defined
• Reusable routine that is stored in a DB
• Efficient
• Dynamically building queries
• Parameter support

Create Stored Procedure Using Microsoft SQL Server Management Studio.
As a first step it is very important to select the database which you want to create Stored Procedure. And next select the Programmability in there select Stored Procedure. Write click on Stored Procedure and by giving suitable name for Stored Procedure you can create Stored Procedure. Figure 1 show how to create Stored Procedure.

Figure 1: How to create Stored Procedures for particular Database.

When you create stored procedure you can find file as Figure 2. According to your purpose you can create suitable stored procedure by adding necessary code on that Stored Procedure file and you can save them. After that easily can use to our application.

Figure 2 show that Stored Procedure File.

Your Comments are highly appreciated; it will be improving my knowledge also.

CREATE STORED PROCEDURES USING .NET IDE

2009-10-04T22:46:00.003-07:00

CREATE STORED PROCEDURES USING .NET IDE

We can create stored procedures using modern IDE such as Visual Studio .Net and using some languets such as C#, VB and etc. As well as, we can easily manage stored procedures through that one. By following below simple step it will be very easy to create stored procedure without using Microsoft SQL management studio. In here I am going to explain how to create a SQL Server Project using .net C#.

1st step:
Create the Data base project. Follow step.
File->New->Project->Database

By providing necessary details can create Database project. Figure 1 how to create database project.

Figure 1 show that how to create a SQL Server Project.

2nd step:
Adding a database reference

Now it will ask for a database reference. In here you can add new data base reference or can use existing data base references. Figure 2 explain that how to add data base reference for SQL Server Project.

Figure 2 show: can use existing Db reference or Add New Reference

Figure 3 show how to add new Database Reference to SQL Database Project.

Figure 3 show how to create new database reference by adding necessary details.

3rd step:
Adding a Stored Procedure to SQL Database project

Write click on the Project and add a stored procedure. By adding stored procedure you can create whatever stored procedure you want. Normally there are few templates available from that template select stored procedure template. Figure 4 introduce how to add new stored procedure file to project.

Figure 4 show that adding new stored procedure to SQL Database project.

Now I have already created stored procedure on my SQL Database project. Open stored procedure file. It will be simply like this.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void TestStoredProcedure()
{
// Put your code here
}
};

4th step
Now in the method we have to add suitable SQL query and able to create simple Stored procedure. By adding following codes to that methods. Make SqlPipe object and SqlCommand object.

Important: The function from stored procedure want to perform should enter as SQL query. Stored procedure works according to the SQL query we are placing here. Therefore we must identify SQL query is working correctly otherwise Stored Procedure will not be working correctly according to our requirements.

public static void TestStoredProcedure()
{
// Put your code here
SqlPipe sqlPipe;
SqlCommand sCmd = new SqlCommand();
sCmd.CommandText = "SELECT Name FROM NameOfStudent";
sqlPipe = SqlContext.Pipe;
sqlPipe.ExecuteAndSend(sCmd);
}

5th step:
Deploy the Stored Procedure

Build the project and then deploy it.
Run the Stored Procedure
Make sure the CLR is enabled with your SQL Server by running the following SQL.

sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

Your Comments are highly appreciated; it will be improving my knowledge also.

SQL Mathematics Function

2009-10-04T22:46:00.002-07:00

SQL Mathematics Function

Basically SQL mathematics function provider idea about mathematic function. By using those function can do same mathematics calculation easily.

• SQL ABS Function
• SQL Cell (or Ceiling ) and Floor Function
• SQL Power Function
• SQL Rand Function
• SQL Round Function
• SQL SQRT Function
• SQL PI Function
• SQL Exp Function
• SQL Log Function
• SQL Trigonometric Function

SQL String Function

2009-10-04T22:46:00.001-07:00

SQL String Function

Basically SQL String Function allows you to manipulate character data effectively.

• SQL ASCII Function
• SQL CHR or CHAR Function
• SQL CONCAT Function
• SQL LENGTH or LEN Function
• SQL Replace Function
• SQL Lower Function
• SQL Upper Function

SQL Aggregate Function

2009-10-04T22:44:00.000-07:00

SQL Aggregate Function

Basically SQL Aggregate Function allows you to summarize the result of an expression for the group of rows and returns a single value for that group.

• SQL AVG Function
• SQL Count Function
• SQL MAX/ MIN Function
• SQL Sum Function

SQL Function Introduction

2009-10-04T22:20:00.001-07:00

SQL FUNCTION
When we consider about the SQL FUNCTION we can identify three types of SQL functions such as SQL Aggregate Function, SQL String Function, and SQL Mathematic Function. By using those functions you can easily SQL query according to your requirements.

SQL Aggregate Function
Basically SQL Aggregate Function allows you to summarize the result of an expression for the group of rows and returns a single value for that group.

• SQL AVG Function
• SQL Count Function
• SQL MAX/ MIN Function
• SQL Sum Function

SQL String Function
Basically SQL String Function allows you to manipulate character data effectively.

• SQL ASCII Function
• SQL CHR or CHAR Function
• SQL CONCAT Function
• SQL LENGTH or LEN Function
• SQL Replace Function
• SQL Lower Function
• SQL Upper Function

SQL Mathematics Function
Basically SQL mathematics function provider idea about mathematic function. By using those function can do same mathematics calculation easily.

• SQL ABS Function
• SQL Cell (or Ceiling ) and Floor Function
• SQL Power Function
• SQL Rand Function
• SQL Round Function
• SQL SQRT Function
• SQL PI Function
• SQL Exp Function
• SQL Log Function
• SQL Trigonometric Function

How check SQL Connection is Success?

2009-10-04T22:09:00.000-07:00

How check SQL Connection is Success?
You can easily check your connection is success or not by using following steps. In here you do not want to run the SQL Management Studio for that.

1st step:
Open a note pad.
Start ->Run ->cmd -> type (notepad)

2nd step:
When notepad opens you must save it using any name with the udl extension. You can save it.
File ->Save As
Ex. Sqlconn.udl

Now you can see some icon with Sqlcon.udl is created on your folder which you save in previous step.

3rd step:
Next you must open that one, simply by clicking on it. Figure 1 show that when you opened your Sqlconn.udl.

Figure 1 shows that, when opened the Sqlconn.udl which you created on previous steps.

Select your prefer connection from that. In here you must select, “Microsoft OLE DB Provider for SQL Server”. And go to Next>>

4th step:
By providing your Server name, User name, Password and database you can test connection. If connection is success it provide Connection success message otherwise provide Connection not success message. Figure 2 is connection.

Figure 2 shows that how to provide connection details and check connection is success.

5th step:
Go to Sqlconn.udl and right click and give open with notepad. When it opens with notepad you can see the connection string. It will generate connection string.

Your Comments are highly appreciated; it will be improving my knowledge also.