Sunday, December 25, 2011

Bulk Copy Operation


Bulk Copy Operation

This code shows you how to do bulk copy operation using C#.
string connectionString = "";
 using (SqlConnection sc = new SqlConnection(connectionString))
 {
     sc.Open();
 
     SqlCommand commandSourceData = new SqlCommand("SELECT * FROM StoresBackup;", sc);
     SqlDataReader reader =  commandSourceData.ExecuteReader();
     using (SqlConnection dc = new  SqlConnection(connectionString))
     {
         dc.Open();
         using (SqlBulkCopy bulkCopy = new SqlBulkCopy(dc))
         {
              bulkCopy.DestinationTableName = "Stores";
              bulkCopy.WriteToServer(reader);
         }
     }
 }

Reading web.config from Timer Job



Reading web.config from Timer Job. to read the connection string from the Web.config of the Web Application
Configuration config=System.Web.Configuration.WebConfigurationManager.
OpenWebConfiguration("/",SPContext.Current.Web.Site.WebApplication.Name);
 
 string  _sqlConnectionString = config.ConnectionStrings.
ConnectionStrings["DBConnectionString"].ToString();

Wednesday, December 21, 2011

Get The OUTPUT Paramete Value from SP Using Dot Net



Get The OUTPUT Paramete Value from SP Using Dot Net using asp.net. This code can be used to get the data from database using Out parameter

Imports System.Data
Imports System.Data.SqlClient

Partial Class SP
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
 Handles Button1.Click
        Try

            Dim Con As New SqlConnection
            Con.ConnectionString = "Password=RR;Persist Security Info=True;
User ID=RR;Initial Catalog=RR;Data Source=RR"
            Con.Open()
            Dim INparam, OutPram As New SqlParameter
            INparam.Direction = ParameterDirection.Input
            INparam.SqlDbType = SqlDbType.Int
            INparam.ParameterName = "@ID"
            INparam.Size = 20
            INparam.Value = Textbox1.text

            OutPram.Direction = ParameterDirection.Output
            OutPram.SqlDbType = DbType.String
            OutPram.ParameterName = "@Name"
            OutPram.Size = 200

            Dim com As New SqlCommand
            com.Connection = Con
            com.CommandType = CommandType.StoredProcedure
            com.CommandText = "spGetOutput"
            com.Parameters.Add(INparam)
            com.Parameters.Add(OutPram)
            com.ExecuteNonQuery()

            Label1.Text = OutPram.Value()

        Catch ex As Exception

        End Try
    End Sub

End Class

Sunday, December 18, 2011

Creating SQL Connection



Showing how to create a sql connection by code...(Basic). Type this code to create a sql connection using ADO.Net
//con is the object of SqlConnectoin_
 
 SqlConnectoin con= new SqlConnetoin();
 con.ConnectionString = "Data Source =Sqlservername ; Initial Catalog = table name; Integrated Security = True";
 con.Open();
 //Here Sqlserver name = your computer name
 
 (You can see your computer name by :
 right click on MyComputer --> Properties -->Computer Name (tab) --> Change (BUtton)
 
 //If you are connecting sql with user id and
 
 password than remove Integrated security and type :
 SqlConnectoin con= new SqlConnetoin();
 con.ConnectionString = "Data Source =Sqlservername ; Initial Catalog = table name; User id = youruserid; password = yourpassrd";
 con.Open();
Read More......

Action Method in Mvc

In this section, you will learn about the action method of controller class. All the public methods of a Controller class are called Act...