Refresh database fields in crystal report designed
In windows application I designed the crystal report from a .xsd file. I generated the .xsd from a DataSet generated by executing a stored procedure. Later I changed the stored procedure and anoter column for returning. Againg I generaed the .xsd, but the new field is not displayed database field of field explorer of crystal report.
Please help me.
Follwing code I used. commented section I used for creating .xsd
SqlCommand cmdVendor=new SqlCommand("usp_rptPurchaseAnalysis");
cmdVendor.CommandType = CommandType.StoredProcedure;
cmdVendor.Parameters.Add("@fromVendor",txtStarting Vendor.Text.Trim());
cmdVendor.Parameters.Add("@toVendor",txtEndingVend or.Text.Trim());
DataSet dsVendor = objDb.getData(cmdVendor);
/*dsVendor.WriteXmlSchema("d:\\test1.xsd");
MessageBox.Show("complete");*/
ap4_8 objRpt = new ap4_8();
objRpt.SetDataSource(dsVendor.Tables[0]);
clsCRP objCRP =new clsCRP(objRpt);
|
RE:Database field in Crystal Report
