ASP.NET

ganesh das wrote:

how can i create table in 1 database 2 another database in vb.netFrown

using Microsoft.Reporting.WebForms;

 
reportViewer1.Visible = true;
reportViewer1.ShowToolBar = true;
reportViewer1.SizeToReportContent = true;
reportViewer1.LocalReport.ReportPath = "report1.rdlc"; 
reportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
//Note:DisplayReport will be your method to get data based on your parameters with return type as datatable.  
DataTable dtReportSource = DisplayReport(fromDate,todate,process);

//Note schema for dtReport and dtReportSource should match.
//Note: name format of dataset and datatable in .xsd file

reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsReport_dtReport", dtReportSource ));

use Test2
select Convert(decimal(7,2),moneyPrice) from test1 where id=1

double y = (int)x - x
//y would now be the decimal values, since (int)x will only give the whole number
if (y !=0) 
{
int decValue = (int)y*10 ; //this is done so that only the first 2 decimal values is 
                           //captured into the decValue variables
double backToDecimalPlaces = (double)decValue/10;

x +=backToDecimalPaces;    //now x will contain 61 or 61.xx where xx is the decimal values
}