how to use WCF to retrieve data from sQl server2005.

Question

how to use WCF to retrieve data from sQl server2005. using asp.net c# language and show it in crystal report.

if i pick the date i have to select the data from the table where date='"+date.+"'  after click the button and show it in crystal report

Answer 1

Use this code in selected index changed event of combobox

 

for(int i=0; i<dataGridView1.Rows.Count;i++)

{

   dataGridView1.Rows[i].Cells[6].Value=comboBox1.SelectedValue;

}

 

 

Answer 2

Hii Ranjit,

thank you for your reply. there is just one little change I have to do that is instead of 'combobox1.SelectedValue' I added 'SelectedItem'. it is because when I used SelectedValue, and changed the value from combobox, all the values went blank...

 

'combobox1.text' also works.

 

anyway, my problem is solved.

thank you once again.

 

Mayank Jani