First of all you need to design a Report and then you will assign the data set to the report .. Importing thing all the report field name same as in the DataSet.. < CrystalReportViewer1.ReportSource = CrystalReportSource1 Dim ds As DataSet Dim objCMTransaction As New ForMerchantCard2Merchant ds = objCMTransaction.CardToMerchant(Session("fromDate").ToString, Session("toDate").ToString, Session("UserName")) ' Report Parameters Dim param1Fileds As New CrystalDecisions.Shared.ParameterFields Dim param1Field As New CrystalDecisions.Shared.ParameterField Dim param2Field As New CrystalDecisions.Shared.ParameterField Dim param1Range As New CrystalDecisions.Shared.ParameterDiscreteValue Dim param2Range As New CrystalDecisions.Shared.ParameterDiscreteValue param1Field.ParameterFieldName = "DateFrom" param1Range.Value = Session("fromDate").ToString param1Field.CurrentValues.Add(param1Range) param1Fileds.Add(param1Field) param2Field.ParameterFieldName = "DateTo" param2Range.Value = Session("toDate").ToString param2Field.CurrentValues.Add(param2Range) param1Fileds.Add(param2Field) Me.CrystalReportViewer1.ParameterFieldInfo = param1Fileds Me.CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables(0)) > Rgds, Nadeem.

Hi All, I want to add a text box in my windows form at run time.. and also want to get the values of these text boxes in array......... like i have already one text box in my vb form and in run time if i need 5 text boxes they will add and i will put data in them and when i press the button to save the data the data will transfer in to array or directoly into the data base one by one.. Thanks in Advance.. Muhammad Nadeem.

Hi All, I want to add a text box in my windows form at run time.. and also want to get the values of these text boxes in array......... like i have already one text box in my vb form and in run time if i need 5 text boxes they will add and i will put data in them and when i press the button to save the data the data will transfer in to array or directoly into the data base one by one.. Thanks in Advance.. Muhammad Nadeem.

Dear Kirthikirthi, first of all you have to store all e-mail address into string. then u will set the e-mail to = string. Dim SQL As String Dim st As Integer dim email as string SQL = "SELECT Email FROM Users where date ='18-02-2006' Dt2 = Objdb.ReturnDataTable(SQL) email = "" ' For Check the Users who want to news letter If Dt2.Rows.Count > 1 Then For st = 0 To Dt2.Rows.Count - 1 If st <> 0 Then email = email & ";" + Dt2.Rows(st).Item(0) Else email = Dt2.Rows(st).Item(0) End If Next Else If Dt2.Rows.Count = 1 Then email = Dt2.Rows(0).Item(0) End If End If in send mail in to field just pass the email string... Rgds, Muhammad Nadeem.

Hi to All, I want to Insert and Retrive data from Excel File using ASP.net any one has idea or code...... quries will pass same as in SQL.. Thanks in Advance. Muhammad Nadeem.

Ok if you already creating a session and when u log off from your account (dispose the session .. or abondon the session ) you have to write the B/M Code in Every page load's Event If Session("uname") = "" Then Server.Transfer("login.aspx") Else lblmsg.Text = " Well Come to " & Session("uname") End If when page will load it will check for the username if user will login the page will show else the page will not show and Control will be transfer to login.aspx page.. Regards, Muhammad Nadeem.

Dear Anjani, The Solution of your problem is Session variable you need to create a session when user login into his account a session will start and then user will check its Balances and related info When page will load first of all it checkes for login session if the user is login then page will open if the user has log out then page will not open.:^) every time page will check for scession if scession will expire then page will not open and request for re-login. Rgds, Muhammad Nadeem.

First of all you have to Create Virtual Directory for your Application and then check your virtual directory is working and your IIS is also working ..... i hope after configuration of your server and Virtual directory your Application will work fine. Regards, Muhammad Nadeem.

Hi All, I want to Import Data From Oracle DUMP File *.DMP into SQL Server. how can i import data from Oracle Exported *.DMP to SQL sever , Thanks in Advance. Muhammad Nadeem.