a single row of data with commas -> INTO -> multiple tuples?

I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:

protected void BTN_RunReport_Click(object sender, ImageClickEventArgs e)
        {
            CrystalReportViewer_ClientLetter.Visible = true;

            ConnectionInfo con = new ConnectionInfo();
            con.ServerName = Constants.ServerIP;
            con.DatabaseName = Constants.DatabaseName;
            con.UserID = Constants.UserID;
            con.Password = Constants.Password;

            CrystalReportViewer_ClientLetter.ReportSource = Server.MapPath(Constants.ClientLetters);
            ParameterFields parameter = CrystalReportViewer_ClientLetter.ParameterFieldInfo;
            ParameterField batchdate = new ParameterField();
            batchdate.Name = "@BatchDate";
            ParameterDiscreteValue batchdate_value = new ParameterDiscreteValue();
            batchdate_value.Value = Convert.ToDateTime(txtBatchDate.Text);
            batchdate.CurrentValues.Add(batchdate_value);
            parameter.Add(batchdate);

            foreach (TableLogOnInfo tlf in CrystalReportViewer_ClientLetter.LogOnInfo)
            {
                tlf.ConnectionInfo = con;

Hi experts,

I need to insert/update data to 3 or more tables on a single button click.What is best method for achieving this?I am using mysql as my DB.

Thanks for your valuable reply in advance.

 i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset 

like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid  as a compact data and combination of 3 tables from d single dataset.....

can some1 help me please.....

 Hi,

I have a dataset in my SSRS report where I am getting the data like this. It has 3 rows.

ID Parameter Value

1. Client Name-  XYZ

2. Client Email - xyz@s.com

3. Clinet Phone- 234567

I need to check condition in expression, so If parameter is Client name then It will show in client name textbox of Report. How can write expression for this.

Hi friends,

I need to make multiple button in a single image in asp.net.

and need coding also for vb.net.

thanx in advance

In a single page  has two buttons , ddown and tempname.

I wrote two actionresult separetly each one for ddown and tempname.

I need one is post and another one is get method. so i gave like

1. Get Method

------------------

[ActionName("ddown")]
        [AcceptVerbs(HttpVerbs.Get)]
        [AcceptParameter(Name = "button", Value = "tempname")]
        public ActionResult ddown_tempname(string statusName, NewsLetterAdminViewModel viewModel)
        {

return View();

}

2.Post Method

------------------

[ActionName("ddown")]
        [AcceptVerbs(HttpVerbs.Post)]
        [AcceptParameter(Name = "button", Value = "ddown")]
        public ActionResult ddown(string statusName, string button, NewsLetterAdminViewModel viewModel, FormCollection collection)
        {

return View();

}

if i call the post method its worked well. but if i call the get method, the code does not execute. the brea

Hi I have li like this

<li class="game">
                                    <div class="game-thumb">
                                        <a href="include/games/words.swf" class="gamelink">
                                            <img src="include/games/words.jpg" /></a></div>
                                    <div class="thumb-desc">
                                        Word</div>
                                </li>
                                <li class="game">
                                    <div class="game-thumb">
                                        <a href="include/games/cat.swf" class="game2">
                                            <img src="include/games/dots.jpg" /></a></div>
                                    <div class="thumb-desc">
                                        Trap the CAT</div>
                                </li>
                                <li class="game">
                                    <div class="game-thumb">
                                        <a href="include/games/gravitymaster.swf" class=&qu

I want to store employee name,designation and department in session variable and
retrieve in another page how to do this.

Hi,

I want to use my asp.net mvc application with multiple domains (maybe of hundreds),

so I have created custom Route class that matches requests including domain.

Each domain could has different routes, so the number of routes in RouteTable can be huge

(eg 500 domains, each 20 routes = 10000 routes in RouteTable).

I am considering how it will be efficient?

I have an idea to replace RouteTable.Routes (of type RouteCollection)

with custom one (of type Dictionary<string, RouteCollection>).

But how I can override default route matching mechanism with my custom mechanism which will be two step:

1) retrieve RouteCollection from dictionary based on domain name

2) retrieve specyfic Route object (standard route matching mechanism)

How can I do this?

Maybe someone has better idea for solving this problem?

Thanks in advance

Janusz