private void FillTree()
{
con = new System.Data.SqlClient.SqlConnection();
dsl = new DataSet(); [code]....
I think it has something to do with the Root and Jobs being at Node0. I tried to do and conditional statement to skip the parentNode = "Node0" and NodeName = "Jobs" but for some reason it never sees the NodeName as "Jobs" in the conditional statement.
How can I populate a dropdownlist in an InsertItemTemplate in a ListView when it depends on another dropdownlist i.e. First DropDownList has a list of continents, once this one is selected DropDownList2 should be populated with the countries of the selected continent. Mind, of course both DropDownLists are inside the same InsertItemTemplate.
I'm trying to get Quartz.net working by embedding into my .Net MVC2 application. I know this is not ideal, but I'm just trying to get it up and running before moving it over to a service. I can't get my jobs to fire off, but I think I'm configured correctly. In my Global.asax.cs:
I'm trying to run my SSIS packages as a step inside a sql agent job.This runs normally when the package uses the SAME database as used to create my job.The problem occurs if I create a job to run the package and this package must execute queries in another database. Probably authentication problem. So how to authenticate my package and the job runs normally ?
I am trying to use HTTPWebRequest to login to a site and then retrieve the page after login. However, it seems as if I can't get past the login. I also investigated with Fiddler and tried mimicking Fiddler almost completely and still no luck.
I have a form that collects some dates. The users can go to this form any time, view the data, and edit the data.
The user should only be able to enter today or future dates only. We don't want users to go in here and be able to past date these dates.
So I created a compare validator which compares the text box against today's date. This works great. The user saves the form and life goes on.
But then, lets say they come back 1 week later and want to change a date. Now all the old dates will fire this validator and they can't save anything unless they change all the dates to today or newer. This is a problem.
So what I thought was when I load the form with the data from the database, I would just disable the validator if there is a date, and if it's null enable the validator. But this won't work because then they can back-date all of those dates with the validator disabled.
So for the dates that are not null, it shouldn't fire the validator unless they change the date.
When I load the form, I'm going to load all these dates into Viewstate. I'm going to create a custom validator and check the value they enter against the previous date that is in Viewstate. If it matches that date then it is valid, if it doesn't match that date then I will run it through the validator to check for past-date.
My students are working on an ASP.net VB application for a Web Programming competition and we are having problems with a page where we want an URL string to return all values from our database. Here is the page: [URL] If you use the jobs by category menu on the left side, if you select a job category (ie retail) it will pull up all the jobs from that category. By using a query in the URL like this: [URL] What we need is an option that would pull up all of the records regardless of category. So we made a menu option that passes the value "all". Like this: [URL] We use this information for the dataset we created (we're using Dreamweaver, ASP.net VB and and Access Dbase). We made a dataset SQL as follows:
SELECT * FROM jobs, businesses WHERE jobs.contactlogin=businesses.contactlogin and jobcategory = ? ORDER BY jobs.dateposted DESC
This works fine if a value is passed. For example if "retail" is picked from the menu it passes the value just fine and returns all jobs that have "retail" as the job category in the database. My problem is, how do I modify the above Select statement to show all jobs in the database if the value "all" is passed for the jobcategory. My first thought was to create an If statement that says something to the effect of:
If jobcategory = all THEN SELECT * FROM jobs, businesses WHERE jobs.contactlogin=businesses.contactlogin ORDER BY jobs.dateposted DESC ELSE SELECT * FROM jobs, businesses WHERE jobs.contactlogin=businesses.contactlogin and jobcategory = ? ORDER BY jobs.dateposted DESC END IF
But I haven't been able to figure out the correct syntax. I also tried making this work by using a query in MS Access:
SELECT * FROM jobs, businesses WHERE jobs.contactlogin=businesses.contactlogin AND (jobcategory = @jobcategory or @jobcategory = 'all') ORDER BY jobs.dateposted DESC;
(which does work within MS Access) and calling the query in the Dreamweaver dataset but apparently MS Access can't do that.This seems like it should be easy but so far this problem is kicking my butt.
I have an updatepanel. Inside that i have some controls for selecting search criteria. For search button onclientclick iam calling javascript functon for validation and in onclick iam calling the mathod to populate the gridview. On clicking search first time it is not loading the grid and clicking the second time it populates.
Periodically a rash of occurrences of the following error happen. I believe they're the result of hack attempts. Whether that's the case or not, my question is how can I handle the error? I want to avoid unhandled exceptions. The TreeView control is just a standard .Net TreeView control, not a custom one. If you suggest a code solution, please code it in VB.Net as that's what I'm using.
Message: Input string was not in a correct format.
Stack Trace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Web.UI.WebControls.TreeView.LoadPostData(String postDataKey, NameValueCollection postCollection) at System.Web.UI.WebControls.TreeView.System.Web.UI.IPostBackDataHandler.LoadPostData(String postDataKey, NameValueCollection postCollection) at System.Web.UI.Page.ProcessPostData(NameValueCollection postData, Boolean fBeforeLoad) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
I want to know how to create a textbox in VS2005 where in the box I would type the name of my favourite sports team and once I've pressed the submit button a Gridview table would populate displaying the the name of the team and a image of the club/team shirt.
Does anyone know how to do this so when I select something the 1st dropdown and the 2nd one becomes visible and populates list from a Select statement. I really need help on how to do in an aspx and not on the code behind page.
I have a treeview which will be generated dynamically which need to be displayed on left side and when user clicks on a node it need to open a page on the right side of the same page. and each node has different aspx page. so whenever user selects a node the page details should be displayed on the right side .we can use an iframe on the page which will display the different pages clicked on the node.Is there any alternative i can use to display different pages based on the user selection on the right side without using iframe.
I have a gridview pulling all data from one user. This gridview has an edit button and when that is clicked the gridview becomes too wide for the div/screen and I get a scroll bar. Since this gridview can only have one user in it anyway is it possible to display each field on seperate lines instead?
I have an application that populates a gridview based on criteria in a table. I have another table that holds data to be omitted. I will post the current LINQ code and also the end result SQL code that I need to figure out in LINQ. Below is my code:
Current LINQ Code: Dim TestType = (From test In db.Table _ Where test.TypeId = TypeID _ Select test.Id, test.Title)
I have a Gridview with edit/delete button & in row data one field is a month value.
I want the edit/delete button in that row to disappear if the month in the row is past month.
How could I do this ? I have set the label1.text = current month but I do not know how to set the edit/delete button to be visible/invisible on the condition of the data in the row.
I have a gridview that has the following colums Category, Weight , and an option to delete row. I user would like to be able to highlight two columns in excel Category, Weight and then past them from clipboard to gridview.