I have 2 different databases in my project. Examples like MyDB1 and MyDB2.In MyDB2 am having a procedure, for that am sending 73 parameters. My DB is taking all the parameters data which i sent from code behind. Then it is showing selectant output.up to here it is fine. But in front end that selectant data is not coming to the data table means it is not properly binding to the database. Example in Selectant output am having 30 columns out of that 30 columns i am getting hardly 5 columns and the remaining columns are showings as empty.
My required and database output is like this,
But am getting like this
My Code goes like this,
DataTable dt = new DataTable();
dt= Cost(Parameter1,Parameter2,Parameter3......);
public DataTable Cost(int Parameter1, int Parameter2, int Parameter3,........)
{
DataTable dt = null;
DBConnect objdb = new DBConnect();
errmsg = string.Empty;
try
{
System.Data.SqlClient.SqlParameter[] p = new SqlParameter[73];
p[0] = new SqlParameter("@Parameter1", Parameter1);
p[1] = new SqlParameter("@Parameter2", Parameter2);
p[2] = new SqlParameter("@Parameter3", Parameter3);
----------------------------------------------------------
----------------------------------------------------------
----------------------------------------------------------
----------------------------------------------------------
p[72] = new SqlParameter("@Parameter72", Parameter72);
dt = objdb.ExecuteProcForData("MyProcedureName", errmsg, p);
objdb = null;
}
catch (Exception ex)
{
ex.Message.ToString();
}
return dt;
}