Comments by Dave Paras (Top 38 by date)

Need to convert single column in multiple column.
First Select statement return SIX rows each with single column.
But i want output in N Columns. i.e. 2 columns and 3 rows. or 3 columns and 2 rows.

Is it clear?

What I want is, pass Comma separated string from front hand to back hand(sql server). back hand will convert Comma separated value in to table. That table will directly used to insert data in other table.
All this things is need for save trip from back hand to front hand and vice a versa.

Yeah I know.
But main prob is that how to create dynamic columns.
Functionality provided in link has already been achieved.
Thanks for ans.

Output in Single column has been already achieved.
Can you please provide function that can convert at least for 2 columns.
Thanks for your time and answer.

Can you please provide me code for the scenario you use. (let the user choose to save once he has loaded it to his browser)

I am doing this thing first time. So i don't have much idea of this. I know we can easily do this thing using anchor tag. But we want to use anchor.

What happens is that, Employee Number is split in to two row! :(
and same way for Employee Name.
I dont want to do that, label must not be split into multiple row

Hi Pasan,
But its requirement not to create additional column of Id.
Other reason is that database huge containing more than hundreads of tables, so this change take much time and its not affordable.

So in this context, if you will provide me any solution then it will be really helpful to me.

By the way Thanks for reply.

Nice and Sufficient information.

Add WHERE clause to apply filter.
See below posted answer posted by Dave Parth

Thanks for vote mkgoud..

Currently working on other things.. :)

Thanks Dave

Thanks Olivier!

Thanks for your help ..
As soon as I'll got solution, I'll post it.

:(Hope So

First of all thanks for your response.

I have check all three links.
First and last link contains thread that has been start when application start. (Global Level)
But what I want is, Thread should start on click of control, not at application level.

Second link contains window base application.
I have already test thread in window application.
It works fine.

By the way, Thanks for your time...

As per as my knowledge concern,
This thing can be implement in Window application..

Can you please tell me using normal application..

protected void LoadGrid1_Click(object sender, EventArgs e)
{
//Fetch the records by executing query
DataTable dtResult = database.FetchDataTable("Select * from TableName");

//Assign fetched result to Gridview
gv1.DataSource = dtResult;
gv1.DataBind();
}

protected void LoadGrid2_Click(object sender, EventArgs e)
{
//Fetch the records by executing query
DataTable dtResult = database.FetchDataTable("Select * from TableName");

//Assign fetched result to Gridview
gv2.DataSource = dtResult;
gv2.DataBind();
}

What's happening exactly when you click the button to load data? Is is hanging till the thread finishes
Same thing happen.

- Check that you are not accessing any UI components from the DoWork method.
In do work I'm just inserting record in Database. No more other then this.

Do you mean constructor as page_load method?
Its web application.
I cant found constructor! :(
So if you mean of constructor by something else, please let me know where I have to initializes it?

Thanks for your time...

LIKE THESE ???
It will not call DoWork Method, when workerLocal.RunWorkerAsync() executes... :(

----------------------------------------------------------------
BackgroundWorker workerLocal = new System.ComponentModel.BackgroundWorker();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
workerLocal.DoWork += new DoWorkEventHandler(DoWork);
workerLocal.WorkerReportsProgress = false;
workerLocal.WorkerSupportsCancellation = true;
workerLocal.RunWorkerCompleted += new RunWorkerCompletedEventHandler(WorkerCompleted);
}
}
protected void btnStartThread_Click(object sender, EventArgs e)
{
// Calling the DoWork Method Asynchronously
workerLocal.RunWorkerAsync();
}

Please post it in English.

Please ACCEPT this as ANSWER, as it works.
Thanks.

Alternate to above solution without using variable.

private void txtAmt_TextChanged(object sender, EventArgs e)
{
txtNewSalary.Text = Convert.ToString((txtAmt.Text.Trim() != "" ? Convert.ToDouble(txtAmt.Text) : 0) + (txtOldSalary.Text.Trim() != "" ? Convert.ToDouble(txtOldSalary.Text) : 0));
}

Here is TextChange event
------------------------

private void txtAmt_TextChanged(object sender, EventArgs e)
{
Double news;
/*(txtAmt.Text.Trim() != "" ? Convert.ToDouble(txtAmt.Text) : 0)
check if OldSalary and txtAmt is not blank, if is it so convert to double else return 0
initially Convert.ToDouble raise error when txtOldsalary does not contain anything, to avoid this use ternary operator.*/
news = (txtAmt.Text.Trim() != "" ? Convert.ToDouble(txtAmt.Text) : 0) + (txtOldSalary.Text.Trim() != "" ? Convert.ToDouble(txtOldSalary.Text) : 0);
txtNewSalary.Text = news.ToString();
}

steps
----
1. Add three textboxes and button in your form.
2. on button click event paste following code.
---
Double news;
news = Convert.ToDouble(txtAmt.Text) + Convert.ToDouble(txtOldSalary.Text);
txtNewSalary.Text = news.ToString();
---
3. Run program. (F5)
4. Enter 10 in txtAmt textbox
5. Enter 23 in txtOldSalary textbox
6. Click button
7. You'll get result in txtNewSalary textbox, sum of 10 and 23 (33).

Can you provide sample data you are using in txtAmt and txtOldSalary textbox