Hi, if we are trying to add the several columns in select statement without using Aggregate functions and only one condition in group by. how can we do that ??

hi thanks for u reply.. can u help me in writing the query for that requirement.If u have any thing about the dynamic sql and like generic procedures ..please help me by giving some sample query.

hi all, i want to write a generic Insert & update procedure.It should work with different tables having diffrerent datatypes.suppose let say table1 may have col1 int,col2 varchar... and let say table2 may have col1 varchar,col2 char..like that..and so on.. generally till now wat iam doing is that iam writting different stored procedure for different tables.. Now i want to write One Insert & update procedure in my project...and for all the tables in the project i want to use only that procedure. Is it Possible? If yes kindly help me ..on resolving this issue.. Thanks & regards suman

how to insert,update,to fill data to datagrid..using XML?

hi in my windows based application i need to export data from grid to excel,word. iam very new to c#.net.please kindly help me.

hi all, i want to import all the inbox mails in my gmail account to my web application.Could anyone explain me how to access to the Gmail inbox or simply retrive emails? Thanx

hi iam facing same problem....... help me .....how u solved this problem..........kindly help me........

don't give ur work to others....first u try ....if struck any where ask us we r ready to help u

hi all i have a dropdownlist in datagrid and have to populate it data in pageload along with grid.later i have to fire the ddlselectedindex when it is in grid

hi all, i have 2 textboxes(multiline).if i select text in one textbox i have to drag that text and drop in another textbox. how i have to do it?help me it is urgent

hi all, can anyone provide a very very good meterial for oops

hi all, help me in generating the crystal reports in webapplication asp.net 2.0 using c#.net

hi all, i need code for not pressing ctrl c in input field form to copy text and also no right click copy

hi all how to send and recieve mails using .net2005 give me some examples... heip me....it is urgent

hi help me and tell me how to use postback url in .net2005?plz give an example

how to use request.form?

how to use response.form ? give me an example

it is working fine for me i tested again ok bye best of luck

as an example take a sample grid and populate with data from database and then press button here text and id of button is word protected void word_Click(object sender, EventArgs e) { //string attachment = "attachment; filename=f.xls"; SqlDataAdapter da = new SqlDataAdapter("select * from empdata", cn); DataSet dsExport = new DataSet(); da.Fill(dsExport); System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); //DataGrid dgGrid = new DataGrid(); //dgGrid.DataSource = dsExport; DataGrid1.DataSource = dsExport; // //Report Header hw.WriteLine("" + "Report for the Employee Information: " + ""); //hw.WriteLine("
"); //// Response.AddHeader("emp info", attachment); // // Get the HTML for the control. //dgGrid.HeaderStyle.Font.Bold = true; //dgGrid.DataBind(); //dgGrid.RenderControl(hw); DataGrid1.HeaderStyle.Font.Bold = true; DataGrid1.DataBind(); DataGrid1.RenderControl(hw); // // Write the HTML back to the browser. Response.ContentType = "application/msword"; this.EnableViewState = false; Response.Write(tw.ToString()); Response.End(); }

word_click is just list button_click.......ok here button text&id is word