tag:blogger.com,1999:blog-7805972021499203804.post8572391923810260195..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: How to Export Data from Gridview to Excel in Asp.net using C#, VB.NETSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger43125tag:blogger.com,1999:blog-7805972021499203804.post-51383347877704704902017-12-03T23:05:16.834-08:002017-12-03T23:05:16.834-08:00Extender control 'txtInterviewFromDate_Calenda...Extender control 'txtInterviewFromDate_CalendarExtender' is not a registered extender control. Extender controls must be registered using RegisterExtenderControl() before calling RegisterScriptDescriptors()<br /><br />i have this problem pls suggest meAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-22914216561639911592017-01-10T01:12:30.369-08:002017-01-10T01:12:30.369-08:00 export gridview to excel how to add a formula col... export gridview to excel how to add a formula columnUkani Dharmendranoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-58530563053226846022016-09-12T22:41:48.319-07:002016-09-12T22:41:48.319-07:00How to download multiple excel from multiple grid ...How to download multiple excel from multiple grid in a single button click.Naveen Murugahttps://www.blogger.com/profile/18045085777199158803noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-55999971055433664562016-09-08T08:54:14.608-07:002016-09-08T08:54:14.608-07:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/06372778331779212950noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-69707722872649937652016-09-08T08:52:44.202-07:002016-09-08T08:52:44.202-07:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/06372778331779212950noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-3996079882092911702016-02-15T01:53:10.928-08:002016-02-15T01:53:10.928-08:00hihiRajeshhttps://www.blogger.com/profile/05465398371080306054noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-8432518264595574792015-02-16T05:29:44.555-08:002015-02-16T05:29:44.555-08:00Hi, Suresh ,It helped me alot but the problem is a...Hi, Suresh ,It helped me alot but the problem is after exporting to excel im getting links under excel header columns, please tell me how to avoid underlines / links.Anonymoushttps://www.blogger.com/profile/06323561694409186439noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-81715531730322864992015-01-22T20:42:49.014-08:002015-01-22T20:42:49.014-08:00#region createtable
protected DataTable create... #region createtable<br /> protected DataTable createtable()<br /> {<br /> Session["dtMyTable"] = new DataTable("tblnamedb");<br /> ((DataTable)Session["dtMyTable"]).Columns.Add("new", typeof(string));<br /> ((DataTable)Session["dtMyTable"]).Columns.Add("workdate", typeof(string));<br /> ((DataTable)Session[&Anonymoushttps://www.blogger.com/profile/16232868625094727817noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-67477963827001799762015-01-22T20:41:13.773-08:002015-01-22T20:41:13.773-08:00if (BtnSave.Text == "Submit")
{
...if (BtnSave.Text == "Submit")<br /> {<br /><br /> if (((DataTable)Session["tmpDataTable"]).Rows.Count > 0)<br /> {<br /><br /> GetNewRectoInsert();<br /><br /> int status = tasksht.bulkInsertSchemeMaster(myDtNewRec);<br /> if (status == 1)<br /> {<br /> lblresult.TextAnonymoushttps://www.blogger.com/profile/16232868625094727817noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-60507327758169304002015-01-22T20:39:48.477-08:002015-01-22T20:39:48.477-08:00public int bulkInsertSchemeMaster(DataTable myDtNe... public int bulkInsertSchemeMaster(DataTable myDtNewRec)<br /> {<br /> con.OpenConnection();<br /><br /> int i = 0;<br /><br /> try<br /> {<br /> SqlBulkCopy bulkCopy = new SqlBulkCopy(con.GetConnection);<br /> <br /> SqlBulkCopyColumnMapping mapping1 = new SqlBulkCopyColumnMapping("workdate", "workdate");<br /><br Anonymoushttps://www.blogger.com/profile/16232868625094727817noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-33690924251209995132015-01-22T20:37:57.007-08:002015-01-22T20:37:57.007-08:00#region GetNewRectoInsert
private void GetNewR...#region GetNewRectoInsert<br /> private void GetNewRectoInsert()<br /> {<br /> myDtNewRec = (DataTable)Session["tmpDataTable"];<br /> DataView dv = new DataView(myDtNewRec);<br /> dv.RowFilter = "new = 0";<br /> myDtNewRec = dv.ToTable();<br /> }<br /> #endregion <br />Anonymoushttps://www.blogger.com/profile/16232868625094727817noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-55628497023123498142015-01-22T20:20:04.125-08:002015-01-22T20:20:04.125-08:00private void fillTaskmappingGrid(DataTable tmpTabl... private void fillTaskmappingGrid(DataTable tmpTable, string txtDate, string sltdLocation, string Client, string Project, string TaskType, string TaskActivity, string TaskMode, string taskDesc, string EstdHrs, string EstdMins, string actlHrs, string actlMins,string assignedby,string status,string remarks, string Created_by, string news)<br /> {<br /> dtr = tmpTable.NewRow();<br /><br />Anonymoushttps://www.blogger.com/profile/16232868625094727817noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-36243469018742129472015-01-22T20:17:28.299-08:002015-01-22T20:17:28.299-08:00if (BtnAddnew.Text == "Add New")
...if (BtnAddnew.Text == "Add New")<br /> {<br /> grdDetails.Visible = true;<br /> try<br /> {<br /> //if (grdDetails.Rows.Count == 0)<br /> //{<br /> // Session["dtMyTable"] = createtable();<br /> // Session["tmpDataTable"] = ((DataTable)Session["dtMyTable&Anonymoushttps://www.blogger.com/profile/16232868625094727817noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-27374099954953697772015-01-22T20:16:44.387-08:002015-01-22T20:16:44.387-08:00pls explain this codepls explain this codeAnonymoushttps://www.blogger.com/profile/16232868625094727817noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-22635584555005781072014-10-25T06:43:46.212-07:002014-10-25T06:43:46.212-07:00Please tell me how should i import data from gridv...Please tell me how should i import data from gridview to excel in desktop application<br />Anonymoushttps://www.blogger.com/profile/03693264470661721494noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-6833669623142506072014-09-16T21:33:07.114-07:002014-09-16T21:33:07.114-07:00How to create the VerifyRenderingInServerForm func...How to create the VerifyRenderingInServerForm function. Please can you explain.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-30837832489221273952014-09-02T05:26:15.720-07:002014-09-02T05:26:15.720-07:00it shows HttpException near "GridView1.Render...it shows HttpException near "GridView1.RenderControl(htw);" that Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server. but i have placed inside a form tag with runat=server. what to do?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-35742094913138819632014-07-18T00:24:45.484-07:002014-07-18T00:24:45.484-07:00Hello,
How can i rename sheet and also add new Sh...Hello,<br /><br />How can i rename sheet and also add new Sheet?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-55130809988585797732014-07-05T03:21:31.400-07:002014-07-05T03:21:31.400-07:00I try this code but i got following error...plz he...I try this code but i got following error...plz help me...<br />"RegisterForEventValidation can only be called during Render();"<br />at this line<br /> GVPurity.RenderControl(htw);Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-34569224552361869412014-06-17T23:56:51.560-07:002014-06-17T23:56:51.560-07:00It is nice Program But i want to ask one thing whe...It is nice Program But i want to ask one thing when i am doing the same code m getting some Null refrences error u wrote in design of gridview<br />AutoGenerateColumns="false"<br />But when i delete it works fine but when i put AutoGenerateColumns="false" then will get an error "Object reference not set to an instance of an object."<br />Can u tell me why this errorAnonymoushttps://www.blogger.com/profile/03471015498237369835noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-37323820214172510452014-06-17T13:50:05.918-07:002014-06-17T13:50:05.918-07:00I tried your code, it works but give me this error...I tried your code, it works but give me this error when try to open the Excel file, "the file you are trying to open is in a different format than specified by the file extension", can you please help?<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-50632438106958375482014-06-12T21:47:47.915-07:002014-06-12T21:47:47.915-07:00hello sir this tanmay i want to export data to exc...hello sir this tanmay i want to export data to excel without using any loop can it be possible<br />please help me<br />Tanmay Nehetehttps://www.blogger.com/profile/04360699013500750550noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-50752601908592127172014-05-26T22:12:57.564-07:002014-05-26T22:12:57.564-07:00Grate
bt sir i want to set the excel cell propert...Grate <br />bt sir i want to set the excel cell property as text format how can i do this..???Tanmay Nehetehttps://www.blogger.com/profile/04360699013500750550noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-32503747047756179672014-05-22T11:22:11.418-07:002014-05-22T11:22:11.418-07:00please give me code for above program by using LIN...please give me code for above program by using LINQAnonymoushttps://www.blogger.com/profile/10766448635263844263noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-20685113561400361362014-05-18T23:25:30.502-07:002014-05-18T23:25:30.502-07:00How to generate the excel and save it in a folder ...How to generate the excel and save it in a folder in server?<br />Anonymoushttps://www.blogger.com/profile/01883909099119436420noreply@blogger.com