no probs i got the solution i modified my query to string sql = "select format([dateregistered],'MM/dd/yyyy') as Dates,[user],[client facility],sum([payroll score]) as LC from [sheet1$] group by [user],[client facility], format([dateregistered],'MM/dd/yyyy') order by [user]"; its working for me.......... ;) ;) modified on Monday, December 1, 2008 4:54 AM

sunilwise wrote: string sql = "select CONVERT(varchar ,[dateregistered],103) Dates,[user],[client facility],sum([payroll score])LC from [sheet1$] group by [user],[client facility], CONVERT(varchar ,[dateregistered],103) order by [user]"; no probs i got the solution i modified my query to string sql = "select format([dateregistered],'MM/dd/yyyy') as Dates,[user],[client facility],sum([payroll score]) as LC from [sheet1$] group by [user],[client facility], format([dateregistered],'MM/dd/yyyy') order by [user]"; its working gr8 for me

see header

I found your driver from Intel website[^], but there is no driver for windows 2003. But the driver for windows xp is available. If you have a test machine, may be you can try an xp driver for your 2003 OS? Hope this help

Check this Link[^] Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

sir can you please tell me in detail how to handle the event

Thank you. Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

plz help me out of this problem

thank u ray for u r replies it helped me some what by the way i used javescript function and some code var gridViewCtlId = '<%=gvAuditErrors.ClientID%>'; var gridViewCtl = null; var curSelRow = null; function getGridViewControl() { if (null == gridViewCtl) { gridViewCtl = document.getElementById(gridViewCtlId); } } function onGridViewRowSelected(rowIdx) { var selRow = getSelectedRow(rowIdx); if (curSelRow != null) { curSelRow.style.backgroundColor = '#ffffff'; } if (null != selRow) { curSelRow = selRow; curSelRow.style.backgroundColor = '#99cccc'; alert(rowIdx); } } function getSelectedRow(rowIdx) { getGridViewControl(); if (null != gridViewCtl) { return gridViewCtl.rows\[rowIdx\]; alert(rowIdx); } return null; } private Int32 m_iRowIdx; protected void gvAuditErrors_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { //string m_iRowIdx; e.Row.Attributes.Add("onclick", "onGridViewRowSelected('" + m_iRowIdx.ToString() + "')"); } m_iRowIdx++; } http://www.netomatix.com/Development/GridViewRowSelectedStyle.aspx[^][^]

John Prabhu wrote: on the click of the record by passing the ID of the Selected Row as QueryString the main problem for me is passing ID of the selected row sir can you please tell me in detail how to pass the ID of the selected row if possible with example regards sunil

please anybody send me some solution

Sun Rays wrote: Convert.ToDecimal(txtPoints.Text.Trim()) or Decimal.Parse(txtPoints.Text.Trim()) ok i got it both are working my thanx to all those have answered my question from the bottom of my heart

Try this string sourceFile = "C:\\Documents and Settings\\PrateekGupta\\Desktop\\pref.xml"; Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/octet-stream"; FileInputStream filIpStrm = null; MemoryStream ms = new MemoryStream(); filIpStrm = new FileInputStream(sourceFile); sbyte[] buffer = new sbyte[1024]; int len = 0; while ((len = filIpStrm.read(buffer)) >= 0) { byte[] bbuffer = new byte[1024]; System.Buffer.BlockCopy(buffer,0,bbuffer,0,1024); ms.Write(bbuffer,0,1024); } Response.OutputStream.Write(ms.ToArray(), 0, Convert.ToInt32(ms.Length)); filIpStrm.close(); Response.End(); let me know if it will work for u...

That is not a good way to format the date, as different dates will share the same folder. For example, the dates 2007-01-11 and 2007-11-01 will both become "1112007". If you really need to create that format anyway, you can use .ToString("Mdyyyy") to format a date that way. A better format would be "MMddyyyy", as that would give a unique value for each date, so 2007-01-11 becomes "01112007" and 2007-11-01 becomes "11012007". An ever better format would be to follow the ISO 8601 order "yyyyMMdd". This is unambigous (as opposed to the dd/MM/yyyy and MM/dd/yyyy formats), and you even get the folders in date order in the explorer. :) Experience is the sum of all the mistakes you have done.

thanks for u r answers sir its working fine :):):):cool: