ASP.NET Discussion Boards

N a v a n e e t h9-Jul-07 0:55

9-Jul-07 0:55

Archana New to Dotnet wrote:
s there any faster way of exporting to excel sheet .The one above is really faster because it exports it directly from the grid.

Your method looks fine.

Archana New to Dotnet wrote:
Actually I used the below code to export to excel sheet from datagird,but this is not working if I apply Paging to the Grid.

What is the error you are getting ?

My Website | Ask smart questions

Re: datagird to Excel sheet

Archana New to Dotnet9-Jul-07 1:09

Archana New to Dotnet

9-Jul-07 1:09

RegisterForEventValidation can only be called during Render();

Re: From stored procedure to bind datas to datagrid...,

N a v a n e e t h9-Jul-07 0:00

N a v a n e e t h

9-Jul-07 0:00

Magh_M wrote:
How to get the remaining dates...,

Change your algorithm.. Confused | :confused:

My Website | Ask smart questions

Re: From stored procedure to bind datas to datagrid...,

Member 38798819-Jul-07 0:04

Member 3879881

9-Jul-07 0:04

Sorry my dear frd,
I got another way from another member..,
Check this :
DECLARE @startDate datetime
declare @nextdate datetime
DECLARE @endDate datetime
declare @tbl_date table (mydate datetime)
set nocount on
SET @startDate = CAST( CAST( 2007 AS varchar(4) ) + '0101' AS datetime )
SET @startDate = DATEADD( m, 6 - 1, @startDate )
set @enddate=dateadd(m,1,@startdate)
while @startdate < @enddate
begin
--SET @nextdate = DATEADD( d, 0, @startdate )
insert into @tbl_date values (@startdate)
set @startdate=dateadd(d,1,@startdate)
end
select * from @tbl_date

Thanks for ur reply...,
Keep in touch,

Regards,
Magi

Re: From stored procedure to bind datas to datagrid...,

Archana New to Dotnet9-Jul-07 0:36

Archana New to Dotnet

9-Jul-07 0:36

i tried this Navaneeth by using Stored Procedure,its very slow.will it be like that only ?or is there any good way ..plz tell me

Dim sep As String = ""
For Each dc As DataColumn In dt.Columns
Response.Write(sep + dc.ColumnName)
sep = "" & Microsoft.VisualBasic.Chr(9) & ""
Next
Response.Write("" & Microsoft.VisualBasic.Chr(10) & "")
Dim i As Integer
For Each dr As DataRow In dt.Rows
sep = ""
i = 0
i = 0
While i < dt.Columns.Count
Response.Write(sep + dr(i).ToString)
sep = "" & Microsoft.VisualBasic.Chr(9) & ""
System.Math.Min(System.Threading.Interlocked.Increment(i), i - 1)
End While
Response.Write("" & Microsoft.VisualBasic.Chr(10) & "")
Next

Solution

Archana New to Dotnet9-Jul-07 1:39

Archana New to Dotnet

9-Jul-07 1:39

the below code is super fast and got it through searching inside Code project itself

Dim ds As DataSet
ds = New DataSet()
Dim dg As New System.Web.UI.WebControls.DataGrid()
'fill datagrid
da.Fill(ds)
dg.DataSource = ds
dg.DataBind()
'datagrid formatting
dg.Font.Name = "Verdana"
dg.BorderStyle = System.Web.UI.WebControls.BorderStyle.Solid
dg.HeaderStyle.BackColor = System.Drawing.Color.Blue
dg.HeaderStyle.ForeColor = System.Drawing.Color.White
dg.HeaderStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center
dg.HeaderStyle.Wrap = False
dg.HeaderStyle.Font.Bold = True

'export to excel
Context.Response.Buffer = True
Context.Response.ClearContent()
Context.Response.ClearHeaders()
Context.Response.ContentType = "application/vnd.ms-excel"
EnableViewState = True
Dim tw As New System.IO.StringWriter()
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
dg.RenderControl(hw)
Context.Response.Write(Now)

Context.Response.Write(tw.ToString())
Context.Response.Flush()
Context.Response.Close()
Context.Response.End()
da.Dispose()
da = Nothing
ds.Dispose()
ds = Nothing
con.Close()
con.Dispose()
con = Nothing

java script error [modified]

Sonia Gupta8-Jul-07 23:08

Sonia Gupta

8-Jul-07 23:08

i am writing the following code

<script language="javascript" type="text/javascript">
function validation()
{
if(document.Form1.textbox1.value=="")
{
alert("please fill it");
}
}
</script>

<asp:Button ID="Button1" runat="server" Text="Button" OnClick="validation();" />
It shows the following error.
Error 1 'validation' is not a member of 'ASP.waste_aspx'.
Error 2 Character is not valid.

-- modified at 5:18 Monday 9th July, 2007

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....