i have one doubt C#

Question

hi anyone please help me i will send SP query for Update database please check it it is right or wrong and i need how to execute the stored procedure in your c# code by passing the appropriate parameters please send me a code or send me a link

Nanddeep Nachan · Accepted Answer

Hi Amudhan, Can you please post the SSIS query as a separate question under SQL Category https://www.c-sharpcorner.com/forums/technologies/database/sql   This will help you to get quick and correct response from SQL, SSIS experts from C# Corner experts.

Amudhan Kuppan · Answer

ok nandheep

Amudhan Kuppan · Answer

hi i have one error in SSIS anyone please rectify that i will send code and error screenshot please check if any mistake please update me #region Namespaces using System; using System.Data; using System.Web; using System.Data.SqlClient; using Microsoft.SqlServer.Dts.Runtime; using System.Windows.Forms; #endregion namespace ST_1df65fa73d334f9baf6f5e196eb4a972 { [Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute] public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase { public void Main() { using (SqlConnection con = new SqlConnection(" ")) { using (SqlCommand cmd = new SqlCommand("updatedatabase", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@toDatabase", SqlDbType.VarChar).Value = "To IT TEST1"; cmd.Parameters.Add("@fromDatabase", SqlDbType.VarChar).Value = "From IT TEST"; con.Open(); cmd.ExecuteNonQuery(); } } } } }

Amudhan Kuppan · Answer

thank you nandeep

Nanddeep Nachan · Answer

Hi, Thank you for providing the screenshot of error.   SqlConnection object requires reference of  System.Data.SqlClient dll   Add reference of System.Data.SqlClient from Assembly (GAC) In your code add below using statement using  System.Data.SqlClient;

Amudhan Kuppan · Answer

thank you nandeep but i got some error i will send document please check

Nanddeep Nachan · Answer

Below code might help you.  using  (SqlConnection con =  new  SqlConnection( " " )) {        using  (SqlCommand cmd =  new  SqlCommand( "updatedatabase" , con)) {         cmd.CommandType = CommandType.StoredProcedure;            cmd.Parameters.Add( "@toDatabase" , SqlDbType.VarChar).Value =  "To Database Name" ;         cmd.Parameters.Add( "@fromDatabase" , SqlDbType.VarChar).Value =  "From Database Name" ;            con.Open();         cmd.ExecuteNonQuery();       }    }