public void Save_Report(ArrayList arrlist) { DataTable dt = new DataTable(); dt = new DataTable("Report"); dt.Columns.Add("CONTROL_KEY", typeof(string)); dt.Columns.Add("CONTROL_VALUE", typeof(string)); for (int i = 0; i < arrlist.Count; i++) { PReportDAO obj = new PReportDAO(); obj = (PReportDAO)arrlist[i]; DataRow row = dt.NewRow(); row["CONTROL_KEY"] = obj.SZCONTROLKEY; row["CONTROL_VALUE"] = obj.SZCONTROLVALUE; dt.Rows.Add(row); } conn = new SqlConnection(strsqlcon); try { { conn.Open(); comm = new SqlCommand("SP_PREPORT", conn); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandType = CommandType.StoredProcedure; SqlParameter tblvaluetype = comm.Parameters.AddWithValue("@preport", dt); //Passing table value parameter tblvaluetype.SqlDbType = SqlDbType.Structured; // This one is used to tell ADO.NET we are passing Table value Parameter int result = comm.ExecuteNonQuery(); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } finally { conn.Close(); } }
public DataSet loadsearch(ArrayList arr) { SqlDataAdapter da; SqlConnection conn; SqlCommand comm; DataSet ds = new DataSet(); conn = new SqlConnection(); try { conn.Open(); comm = new SqlCommand("SP_GET_VISIT_OF_REF_OFF_LIST", conn); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; for (int i = 0; i < arr.Count; i++) { PReportDAO obj = new PReportDAO(); obj = (PReportDAO)arr[i]; comm.Parameters.AddWithValue("@SZ_COMPANY_ID", obj.SCOMPANY); comm.Parameters.AddWithValue("@SZ_OFFICE_ID", obj.SOFFICE); comm.Parameters.AddWithValue("@SZ_PROCEDURE_GROUP_ID", obj.SSPECIALITY); //comm.Parameters.AddWithValue("", obj.DTTYPE); comm.Parameters.AddWithValue("@DT_FROM_VISIT_DATE", obj.DTFROM); comm.Parameters.AddWithValue("@DT_TO_VISIT_DATE", obj.DTTO); } da = new SqlDataAdapter(comm); da.Fill(ds); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } finally { conn.Close(); } return(ds); }