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();

Read More......

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

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......