|
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
|
|
|
|
|
in windows apllication, i want to select table's data and show it in datagrid
but i dont undertand how will i bind the data
is there any way to use datagrd view manager or something like this????
m confused!!!
$h@ma!|@
|
|
|
|
|
execute SQL statement.....and fill a DataSet with your information
if you use ACCESS as a database and VB.NET as your language then follow...
Dim mySql AS String="SELECT * FROM myTable"<br />
<br />
Dim ds As DataSet<br />
Dim da As OleDbDataAdapter<br />
<br />
da = New OleDbDataAdapter(mySql, myConnection)<br />
ds = New DataSet<br />
da.Fill(ds)<br />
<br />
DataGrid1.DataSource=ds
Tirtha
Do not go where the path may lead, go instead where there is no path and leave a trail.
Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
|
|
|
|
|
well! isnt there any need to use data reader??
well my code is
//connection as conn
strQuery = " SELECT * FROM table";
SqlCommand com1 = new SqlCommand(strQuery, conn);
DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter();
SqlDataReader dr = com1.ExecuteReader();
if (dr.Read())
{
da.Fill(ds,"table");
}
its not working i mean data is not displaying in the grid..and the exception that is shown is
"The SelectCommand property has not been initialized before calling 'Fill'."
$h@ma!|@
|
|
|
|