Regarding Inserting Data From GUI To Database

Hi iam working with the form which has fields like AuditName,Industry Name,Company Name,Plant Name,Group Name,AuditStartedOn,Auditperiod upto,CreatedOn,createdby

I have dropdownlists for Industry Name,Company Name,Plant Name,Group Name.Data will be filled into Industry Name,Group Name when pageloads from the database and later depending on industryname company name and depending on company name plant name ddl's wiil be filled.

Later to insert this into the Audit table i had given the Stored procedure as :

create procedure CreateAudit

(

@AuditName nvarchar(50),

@IndustryName nvarchar(50),

@IndustryID int output,

@CompanyName nvarchar(50),

@CompanyID int output,

@PlantName nvarchar(50),

@PlantID int output,

@GroupName nvarchar(50),

@GroupID int output,

@AuditStartedOn datetime,

@AuditScheduledto datetime,

@CreatedOn datetime,

@CreatedBy int

)

as

begin

//Here iam getting the Id of the industryname selected in the ddl from industry table into an output parameter  @IndustryID

select @IndustryID=Ind_Id_PK from Industry where Industry_Name=@IndustryName

//Here iam getting the Id of the companyname selected in the ddl from company table into an output parameter  @CompanyID

select @CompanyID=Cmp_ID_PK from Company where Company_Name=@CompanyName

//Here iam getting the Id of the plantname selected in the ddl from plant table into an output parameter  @PlantID

select @PlantID=Pl_ID_PK from Plant where Plant_Name=@PlantName

//Here iam getting the Id of the Groupname selected in the ddl from Group table into an output parameter  @GroupID

select @GroupID=G_ID_PK from Groups where Groups_Name=@GroupName

Insert into Audits(Audit_Name,Audit_Industry,Audit_Company,Audit_Plant,Audit_Group,Audit_Started_On,Audit_Scheduledto,Audit_Created_On,Audit_Created_By)values(@AuditName,@IndustryID,@CompanyID,@PlantID,@GroupID,@AuditStartedOn,@AuditScheduledto,@CreatedOn,@CreatedBy)

end

Later called these parameters into class file:

 

namespace xyz{

public class clsCreateAudit

{SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["constr"]);

SqlCommand cmd = new SqlCommand();SqlDataAdapter da = new SqlDataAdapter();public clsCreateAudit()

{

con.Open();

}public void CreateAudit(string Audit_Name, int Audit_Industry, int Audit_Company, int Audit_Plant, int Audit_Group, DateTime Audit_Started_On, DateTime Audit_Scheduledto, DateTime Audit_Created_On, string Audit_Created_By)

{

cmd.Connection = con;cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "CreateAudit";

SqlParameter AuditName = new SqlParameter();AuditName.ParameterName = "@AuditName";AuditName.DbType = DbType.String;

AuditName.Value = Audit_Name;AuditName.Direction = ParameterDirection.Input;

cmd.Parameters.Add(AuditName);

SqlParameter AuditIndustry = new SqlParameter();AuditIndustry.ParameterName = "@IndustryName";AuditIndustry.Direction = ParameterDirection.Input;

AuditIndustry.Value = Audit_Industry;AuditIndustry.DbType = DbType.String;

cmd.Parameters.Add(AuditIndustry);

SqlParameter IndustryID = new SqlParameter();IndustryID.ParameterName = "@IndustryID";

IndustryID.Direction = ParameterDirection.Output;IndustryID.DbType = DbType.Int32;

//IndustryID.Size = 100;

cmd.Parameters.Add(IndustryID);SqlParameter AuditCompany = new SqlParameter();

AuditCompany.ParameterName = "@CompanyName";AuditCompany.Direction = ParameterDirection.Input;

AuditCompany.Value = Audit_Company;AuditCompany.DbType = DbType.String;

cmd.Parameters.Add(AuditCompany);SqlParameter CompanyID = new SqlParameter();

CompanyID.ParameterName = "@CompanyID";CompanyID.Direction = ParameterDirection.Output;

CompanyID.DbType = DbType.Int32;

//IndustryID.Size = 100;

cmd.Parameters.Add(CompanyID);

 SqlParameter AuditPlant = new SqlParameter();

AuditPlant.ParameterName = "@PlantName";AuditPlant.Direction = ParameterDirection.Input;

AuditPlant.Value = Audit_Plant;AuditPlant.DbType = DbType.String;

cmd.Parameters.Add(AuditPlant);SqlParameter PlantID = new SqlParameter();

PlantID.ParameterName = "@PlantID";PlantID.Direction = ParameterDirection.Output;

PlantID.DbType = DbType.Int32;

//IndustryID.Size = 100;

cmd.Parameters.Add(PlantID);SqlParameter AuditGroup = new SqlParameter();

AuditGroup.ParameterName = "@GroupName";AuditGroup.Direction = ParameterDirection.Input;

AuditGroup.Value = Audit_Group;AuditGroup.DbType = DbType.String;

cmd.Parameters.Add(AuditGroup);SqlParameter GroupID = new SqlParameter();

GroupID.ParameterName = "@GroupID";GroupID.Direction = ParameterDirection.Output;

GroupID.DbType = DbType.Int32;

//IndustryID.Size = 100;

cmd.Parameters.Add(GroupID);SqlParameter AuditStartedOn = new SqlParameter();

AuditStartedOn.ParameterName = "@AuditStartedOn";AuditStartedOn.Direction = ParameterDirection.Input;

AuditStartedOn.Value = Audit_Started_On;AuditStartedOn.DbType = DbType.String;

cmd.Parameters.Add(AuditStartedOn);SqlParameter AuditScheduledto = new SqlParameter();

AuditScheduledto.ParameterName = "@AuditScheduledto";AuditScheduledto.Direction = ParameterDirection.Input;

AuditScheduledto.Value = Audit_Scheduledto;AuditScheduledto.DbType = DbType.String;

cmd.Parameters.Add(AuditScheduledto);SqlParameter CreatedOn = new SqlParameter();

CreatedOn.ParameterName = "@CreatedOn";CreatedOn.Direction = ParameterDirection.Input;

CreatedOn.Value = Audit_Created_On;CreatedOn.DbType = DbType.String;

cmd.Parameters.Add(CreatedOn);SqlParameter CreatedBy = new SqlParameter();

CreatedBy.ParameterName = "@CreatedBy";CreatedBy.Direction = ParameterDirection.Input;

CreatedBy.Value = Audit_Created_By;CreatedBy.DbType = DbType.Int32;

cmd.Parameters.Add(CreatedBy);

cmd.ExecuteNonQuery();

con.Close();

}

}

}

Then i called these function into .aspx.cs file:

 

using xyz;protected void btn_CreateAudit_Click(object sender, EventArgs e)

{SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["constr"]);

PCRA.clsCreateAudit obj = new PCRA.clsCreateAudit();

SqlCommand cmd = new SqlCommand();

//Iam getting the Session(UID) from my login page.obj.CreateAudit(txt_AuditName.Text, Convert.ToInt32(ddl_Industry.SelectedItem.Value), Convert.ToInt32(ddl_Company.SelectedItem.Value), Convert.ToInt32(ddl_Plant.SelectedItem.Value), Convert.ToInt32(ddl_Group.SelectedItem.Value), Convert.ToDateTime(txt_StartingOn.Text.ToString()), Convert.ToDateTime(txt_AuditPeriod.Text.ToString()), System.DateTime.Now, Session["UID"].ToString());lbl_Mesg.Text = "Your Audit Details are added succesfully";

}

 

But iam getting an error here near obj.CreateAudit as:

Input string was not in a correct format.

I even want to know if my storedprocedure reaches the requirement which i specified.

please help me with this.Its very urgent.