Skip to main content

Stored Procedures in SQL SERVER 2005

Step1: Open SQL SERVER 2005
Step2: Create an empty database
Step3: Go to tables and then create an empty table
Let's consider table name as login, the table is look like

Click on Tables
|
Programmability
|
Stored Procedure
|
Create new stored procedure
Step4:create procedure sp_insert(@sno varchar(10), @ sname varchar(10))
as
begin
insert into emp values(@eid,@ename,@esal)
end


Step5: Now open Visual Studio create new website.
Step6: In code behind file write

SqlConnection con;
SqlCommand comm;

con = new SqlConnection("Data Source=BASHA;Initial Catalog=prasad;Integrated Security=True");
con.Open();
comm = new SqlCommand("sp_insert", con);
comm.CommandType =CommandType .StoredProcedure ;
comm.Parameters .AddWithValue ("@eid",TextBox1 .Text );
comm .Parameters .AddWithValue ("@ename",TextBox2 .Text );
comm .Parameters .AddWithValue ("@esal",TextBox3 .Text );
comm.ExecuteNonQuery ();
Response.Write("inserted successfully");



Comments

Post a Comment

Popular posts from this blog

Difference between two Dates in C#.NET ?

To find the difference between two dates is very simple in VB — By using DateDiff method. But in C#, there is no direct method to do so. but there is a way to achive this. For this we need to understand TimeSpan Class. The following code snippet will show you how to find the difference. DateTime startTime = DateTime.Now; DateTime endTime = DateTime.Now.AddSeconds( 75 ); TimeSpan span = endTime.Subtract ( startTime ); Console.WriteLine( “Time Difference (seconds): ” + span.Seconds ); Console.WriteLine( “Time Difference (minutes): ” + span.Minutes ); Console.WriteLine( “Time Difference (hours): ” + span.Hours ); Console.WriteLine( “Time Difference (days): ” + span.Days ); By concatenating all this you will get the difference between two dates. You can also use span.Duration(). There are certain limitations to. The TimeSpan is capable of returning difference interms of Days, Hours, mins and seconds only. It is not having a property to show difference interms of Months and years. Hope this...
2 comments
Read more

.NET Reflection

Reflection is the feature in .Net, which enables us to get some information about object in runtime. That information contains data of the class. Also it can get the names of the methods that are inside the class and constructors of that object. To write a C# .Net program which uses reflection, the program should use the namespace System.Reflection. To get type of the object, the typeof operator can be used. There is one more method GetType(). This also can be used for retrieving the type information of a class. The Operator typeof allow us to get class name of our object and GetType() method uses to get data about object?s type. Example program: namespace Reflection { public class TestDataType { public TestDataType() { counter = 1; } public TestDataType(int c) { counter = c; } private int counter; public int Inc() { return counter++; } public int Dec() ...
Post a Comment
Read more

Splash Screen in Visual Studio 2008 using C#.NET

Creating Splash Screen is now very easy just follow these steps to make your application look very rich. 1.Suppose, Welcome.cs is your main form and SplashScreen.cs is your splash screen form. 2.Write the following code in the page_load event of your Welcome.cs form Hide(); bool done = false; ThreadPool.QueueUserWorkItem((x) => { using (var splashForm = new SplashForm()) { splashForm.Show(); while (!done) Application.DoEvents(); splashForm.Close(); } }); Thread.Sleep(3000); // Emulate hardwork done = true; Show(); 3. It's done!!
Post a Comment
Read more