|
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 ?
|
|
|
|
|
RegisterForEventValidation can only be called during Render();
|
|
|
|
|
Magh_M wrote: How to get the remaining dates...,
Change your algorithm..
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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....
|
|
|
|
|
Attributes.Add("OnClick",-----) pe likho
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
in the javascript tag i am writing following code....
if(document.Form1.textbox1.value=="")
{
alert("please fill it");
}
is it right?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Sonia Gupta wrote: OnClick="validation();" />
If you are using ASP.NET 2.0, replace onclick with onclientclick . If your version is 1.1, the go with attributes.add("OnClick","function();") .
If you specify onclick like what you specified now, ASP.NET will think it is a server side function and will look for it's references that leads to the error.
|
|
|
|
|
thanks navaneeth.....
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
function validation()
{
if(document.Form1.txtfirstname.value=="")
{
alert("Please fill the First name");
document.Form1.txtfirstname.focus();
return false;
}
in page load
btnaccept.Attributes.Add("onclick", "return validation();")
jai prakash
|
|
|
|
|
Your best solution is here.
Use OnClientClick instead of OnClick event
i.e
<asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="return validation();" />
and Javascript
<script language="javascript" type="text/javascript">
function validation()
{
if(document.Form1.textbox1.value=="")
{
alert("please fill it");
return false;
}
}
</script>
Best Regard
Pathan
GOD HELP THOSE WHO HELP THEMSELVES
|
|
|
|
|
still same situation...
messagebox is not showing up.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
try By this condition <code>if(document.GetElementById('textbox1').value=="")</code>
Best regard
Pathan
GOD HELP THOSE WHO HELP THEMSELVES
|
|
|
|
|
<script language="javascript" type="text/javascript">
function validation()
{
if(document.GetElementById("textbox1").value=="")
{
alert("please fill it");
return false;
}
}
</script>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (Not Page.IsPostBack) Then
Button1.Attributes.Add("OnClientClick ", "return validation();")
End If
End Sub
still messageox is not showing up...
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Sonia Gupta wrote: Button1.Attributes.Add("OnClientClick ", "return validation();")
Button1.Attributes.Add("OnClick ", "return validation();")
|
|
|
|
|
no....
still same problem...
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
try it <asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="return validation();" />
and remove this line
Button1.Attributes.Add("OnClientClick ", "return validation();")
Best regard
pathan
GOD HELP THOSE WHO HELP THEMSELVES
|
|
|
|
|
Imran.....still same problem
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Sonia Gupta wrote: document.GetElementById("textbox1").value
document.getElementById("textbox1").value
|
|
|
|
|
i am using 2005 .
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
jase lika hun wase likhna ok
function validation()
{
if(document.form1.TextBox1.value=="")
{
alert("please fill it");
}
else
{
alert(document.Form1.TextBox1.value);
}
}
page lode pe
Button1.Attributes.Add("onclick", "return validation();")
(case sensitive ka dikat tha dear)
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
have u done
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
HI.
U can use
Button.Attributes.Add("onClick","function();");
but out of Ispostback
U can also call javascript function by onclientClick event in source code
If u call by Onclientclick plz remove code from codebehind file.
Best Regard
Pathan
GOD HELP THOSE WHO HELP THEMSELVES
|
|
|
|