|
Hello everybody,
I am vs2003 to develop my application. I created a web application. In that in one page I inserted data to a table. In another page I have to retrieve the values based on the date values. I write the following codings for that
txtdate.Text = Calendar1.SelectedDate<br />
Dim conn As New OleDb.OleDbConnection("provider=microsoft jet 4.0 ole db provider;data source=c:\internalaudit.mdb;")<br />
Dim cmd As New OleDb.OleDbCommand<br />
<br />
Dim dates As New DateTime(Calendar1.SelectedDate.Year, Calendar1.SelectedDate.Month, Calendar1.SelectedDate.Day, 0, 0, 0)<br />
Dim adp As New OleDb.OleDbDataAdapter("select * from auditfinding where auditdate = " + dates, conn)<br />
Dim dt As New DataTable<br />
'dt.NewRow()<br />
adp.Fill(dt)<br />
adp.Dispose()<br />
lstarea.DataSource = dt<br />
lstarea.DataTextField = "processaudited"<br />
lstarea.DataValueField = "checklistid"<br />
lstarea.DataBind()<br />
Calendar1.Visible = False<br />
I didnt get any error. Also I am not get any output. Can anyone help me. Thanks in advance.
|
|
|
|
|
Dim adp As New OleDb.OleDbDataAdapter("select * from auditfinding where auditdate = " + dates, conn)
replace the above code with
Dim adp As New OleDb.OleDbDataAdapter("select * from auditfinding where auditdate = " + "'" + dates + "'", conn)
I hope this will work
|
|
|
|
|
I do have the following structure.
I have an page (SamplePage.aspx). In this page is some stuff. At the top there are some filter elements which can be used to filter the list below.
The list is build with an <asp:repeater>.
So, because there are many other elements on this side it takes a little to make a complete server roundtrip and to build up the hole page again. If the user changes the filter I want only to reload the list.
So my idea is to use a webservice call, to generate the HTML for the table again.
How can I do that. My first idea was to put the repeater into an user control and to load the user control dynamically from the web service method with
Dim oPage As New CPageBase
oUC = oPage.LoadControl("SampleUC.ascx)
But if I do so, the created object is not completely initialized. The "Application" variable of oUC and oPage is Nothing. But I can see in debugger, that the Application in my webservice method is set correctly.
Do you have any ideas how to make that working. Or do I have the wrong beginning.
Thanks
Erik
|
|
|
|
|
Have you looked at the ASP.net AJAX extensions?
|
|
|
|
|
I am using .Net 1.1 and I think the extensions are only available for .Net 2.0 and higher.
I have no change to migrate to a newer .Net version now.
Is it also possible to make this with .Net 1.1?
|
|
|
|
|
Hi Friends,
Can anyone tell me how to use javascript variable from server side.
Thanks & Regards
Senthil Kumar
|
|
|
|
|
the way to do this is to put a hidden field in your page, set it's value with javascript, then read it on the server.
Or you could redirect to the current page, but put the variable name and value on the URL
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Yet another idea would be to use cookies (set from JavaScript and read in ASP.NET). I would do the hidden field, though.
|
|
|
|
|
hi... i am designing a toolbox as like visual studio toolbox with some controls in it....
i have designed a panel too... now i need a control can be fixed in the toolbox panel...
the control that i am trying to add(inside the toolbox panel) should have drag and drop funcionality....
please advise me which control i can use inside the toolbox panel....
no tree view control suggesions plz..... my application look and feel should be same like visual stiod's.....
the control which i need should support image and name field and should have drag and drop options..
i am using 2.0/3.0 framework...
thanks in advance...
|
|
|
|
|
How use FTP Class in asp.net
i want upload file From One server to another server,
how use FTP class in ASP.NET 2.0(C#)
plz help me its urgent.
Never Think That You Have Failed Instead Always Think That u hav Better Chance Next Time...
|
|
|
|
|
How about Searching[^] ?
modified on Wednesday, December 12, 2007 5:32:15 AM
|
|
|
|
|
hey what is this..!!!!!!
Never Think That You Have Failed Instead Always Think That u hav Better Chance Next Time...
|
|
|
|
|
He suggested you to search in Google first..
|
|
|
|
|
|
It was a friendly reminder that you ought to do a basic homework search with your preferred search engine before throwing the query to a discussion forum.
Check out forum posting guidelines here: http://www.codeproject.com/scrapbook/forumguidelines.asp[^]
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi Friends,
i have two dropdowns- one to fill Country Names from Country table and the other one fills the State Names from State table
CountryId is foreign key in State table
When i select the Country name from country dropdown i want to fill States of that country in state dropdown.
this is my query
"select State_Id,State_name from State where country_id ='" & ddlCountry.selectedValue & "'"
How to do this in AJAX in ASP.Net application
can you send sample code
thanks in advance
|
|
|
|
|
I assume you are using AJAX toolkit. If so put your dropdowns inside update panel.
|
|
|
|
|
thanks Navaneeth
we need to give Autopostback is true in AJAX also??
because i have given the below code but SelectedIndexChanged Event of the ddlCountry is not Triggering
This is my html code
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
</asp:UpdatePanel>
<asp:DropDownList ID="ddlCountry" runat="server" >
</asp:DropDownList>
<asp:DropDownList ID="ddlState" runat="server">
</asp:DropDownList>
I tried to give dropdowns inside UpdatePanel but its showing error like
"Type 'System.Web.UI.UpdatePanel' does not have a public property named 'DropDownList'"
|
|
|
|
|
Hi,
put your both Dropdown in Update Panel and Set Autopost back property true for first Dropdown.
Hopen it will help you.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
I tried but its giving the same error
|
|
|
|
|
Hi,
what error you are getting.
Plz describe so can help you properly..
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
This is my html code
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
</asp:UpdatePanel>
<asp:DropDownList ID="ddlCountry" runat="server" >
</asp:DropDownList>
<asp:DropDownList ID="ddlState" runat="server">
</asp:DropDownList>
when i give dropdowns inside UpdatePanel its showing error like
"Type 'System.Web.UI.UpdatePanel' does not have a public property named 'DropDownList'"
|
|
|
|
|
|
Thank you Deepak,
I refered that link but in that, Country and State are hardcoded (Storing in Array) but my requirment is I should get from DataBase.
I searched in Google but i dint get sample code using Database.. please guide me
|
|
|
|
|
hi iam writting the if contdition in this way is this condition works
if((st1 <>0 and st2 is null)or(st1 =0 and st2 is not null)) then
do some thing
else
do some thing
end if;
|
|
|
|