Im a computer technician and deal with arounf 35 pcs a day that are all diff and all of them have a ID numbet that is unique. I want to keep track of the repairs on each of the ID's so i can search a ID and input different repairs each time that pc comes in. Im not sure what kind of DB would be suitable or how to do that. Im not asking for someone to do it for me but if you could give advice or examples that would help alot. I imagine a list of IDs and when i click one it brings up a history of the repairs done and i can create another one if needed.
I am trying to use a single RouteURL to route to different pages dependent on the Route name but when I click on a button within my aspx page the page gets routed back to itself:Here is what I have in my Global.asax
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs) ' Code that runs on application startup RegisterRoutes(RouteTable.Routes)[code].....
In the program that im working on for a friend, are a lot of addresses (ex: 123 henry blv, City, State, Zip, county)
This is all in database, but he want to be able, to select a few of them, for ex all the ones in one county, and than the program need to put them in order fot the shortest route btween them.
All i need is the list at the and, right now he does this in a routeplanner program, but take about two hours for 15 to 20 adresses,
The current project I'm working on requires me to automate some VB.NET code to run every 24 hours. Currently I have everything tied to a local webpage and I've just been calling it all from a button click in a browser.
My question is....what is the best way for me to start getting this to run on a schedule time frame? I've been looking into triggers, but if I'm not mistaken those are supposed to execute when an event is taken on the actual database. No action is taking place, I just need the code to execute. I've executed SQL statements with VBScript and task manager, but I've never had to work with VB.NET and SQL Server (using 2008) in this manner.
I am converting an existing classic ASP website to (VB) MVC and I don't want any of the existing URLs to break. I have read many posts (like this one: Routing Classic ASP Requests To .NET - SEO Redirects) about how to do the proper 301 redirect. With the latest MVC release, I've gathered that
Response.RedirectPermanent(objRedirect.new_url, True)is all that is needed.
I have entered all of my old URLs in a database table with a corresponding column of the new URL. I have added code in my custom 404 page to get the original URL:
Dim strURL As String = Request.RawUrl.Substring(Request.RawUrl.IndexOf("aspxerrorpath=") + 15).ToLower()
so I can look it up in the database. (Interesting sidenote, MSDN's documentation here - Redirect Mode - seems to say that if I set RedirectMode=ResponseRewrite in the CustomErrors section of my web.config, I won't have to worry about doing the above, but when I've tried that, I get IIS errors saying it won't serve an ASP page?The problem I am encountering is that any of my old, Classic ASP URLs that have the same directory as a new MVC route are somehow being partially routed. For example, "/test/default.asp" shows up as "/test/test" in the above strURL variable of my error page.
I just have a short question about adding an destination methode as variable argument into my calling methode.
I want to send a "TextChanged" event to a special textbox. But I want to have a "variable" in my methode to add the handler to the textbox. Because it is possible to change the textbox and then I can change the handler where the "Changed Events" should be routed to.
can you replace the questionmarks below??
Dim TextBox1 as TextBox Dim TextBox2 as TextBox Private Sub DoIt
im looking to do a trace route to an ip (specified in a text box) and have the results displayed in a textbox. I know that this has been brought up in the forums before but im yet to find a version thats compatible with vb 2008 express edition. The vb.netmvps example is exactly the functionality im looking for but it throws up 80 +errors(*** is no longer supported etc)[URL]the host resolution isnt an issue becasue i already have the list of ip's and corresponding host names that i would be tracing in a db.
does anyone have a tracert app that is compatible with this version of vb or indeed know where i could find one ?
I am trying to code to capture the packet loss on computers, but the only way I've been able to do so was to run the NetStat.exe and the TraceRt.exe processes and capture them to a listbox (using the code below):
I'm trying to understand how to route the events of my IMAPI2 burning progress but not sure how to do it. I've coded event handling before, but just not familiar with the IMAPI2 library so having some trouble.
The reason I am starting a new thread is to be more concise; explain the exact issue I now face in detail. Reading my last thread may help, but what I provide here should be sufficient. I am basically trying to find the best route I should take for my program as far as UAC and Vista is concerned. My program (SysPad) is accessible through my sig).
My program requires constant write access. The purpose of my program is to provide access to a quick notepad-esque program that is directly accessible from the Notification Area. It saves every time the user types into one of the textboxes.
The issue lies in the fact that when UAC is enabled on Vista, there is no folder that is writable to without elevation to Administrator rights. The hitch is that my program is designed to be a startup utility and the issue is that a user who has UAC enabled will have to allow my program through UAC confirmation every time my program runs at startup.
Basically, I am looking for options that will resolve this and make it less "painful" on the end user who uses UAC.
Basically, the only idea I've been able to come up with that is least annoying/intrusive, is to create a Launcher.exe program that does not require elevation and have it sitting in the Notification Area with the same icon as my program at startup. When the user goes to access the program, it then launches the actual program (exiting the launcher) thus invoking the UAC verification.
Of course this would happen every time they boot their PC or restart my program; but, at least they won't be asked for UAC verification as soon as their PC boots.
Does anyone have any other suggestions? I really would like to get this to work with UAC as best as possible. Otherwise, I could just make my program check if UAC is enabled, and if it is, tell them they can't use my program lol. But, I'd rather not do that.
I'm trying to use ASP.NET MVC with older versions of IIS that have trouble with MVC's default routing. I found a suggestion to add .mvc.aspx to my routes. So instead of this:
I have a asp.net mvc route that is taking a url and doing a simple get and return the status code from the request.
<AcceptVerbs(HttpVerbs.Post)> _ Public Function ValidateUrlStatusCode(ByVal url As String) As ActionResult Dim code As Integer = 0
[Code]....
Now if I use firefox (using Firebug) and go to the url http://www.facebook.com/blah.html, I get the expected 404 returned. However if I use my application to call the mvc route via an ajax call, I get 200. If I set the request object's AllowAutoRedirect to false, I get 302. I never get a 404. I am verifying this once again through Firebug.
I have two classes clsRoute and clsStop. Each route has a collection of stops. So I created a Stops collection in the route class and a method to add stops and remove stopsThis seems to work for me. owever, the clsStop properties that I declared are not showing in intellisense.i.e. oRoute.Stops.item(i).StopName and oRoute.Stops(i).StopName
Public Class clsStops Private _stopNumber As Integer = 0 Private _stopName As String = String.Empty
So, if someone enters:[URL]...Even though that page doesn't exist, the application pulls up default.aspx
Now, if this wasn't using a wildcard it would be easy to pull this value in on default.aspx like so:
Dim prospect as String = Page.RouteData.Values("value")
But this doesn't seem to work with wildcards, e.g.:Dim prospect as String = Page.RouteData.Values("*value")
How can I get the page to pick up these variable values? e.g. one time might be janedoe, another johndoe, another goose, another 12345, etc. Whatever it is, I want it to be returned into the string prospect.
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error. My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
I'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
Friends I have Developed my Data base Project on vb6, using adodc and datagrid using ms access database file, it was working nice in vb6, I also put Search box there and used adodc1.recordsource="select * from table" sql query.
later i needed to convert it in vb.net I converted it, every thing is working fine, but one problem appears, an adodc's Recordsource query for searching records is not working, it only works if there is data in dataset (Datagrid),suppose once i pressed search button to search record and if no record found then dataset / datagrid becomes empty, now i wanted to search an other record with other name, but this time it does not work and following error appears Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA.
For example there is a database called DB1 with a REDATA table inside it, and then DB2 with a RECDATA table inside it, DB3 with a RECDATA table inside it est. So I need to put all the Recdata into 1 Database file, or to copy all the RECDATA from all the database files to 1 RECDATA they all have the same columns All I need is to get all that data into 1 RECDATA table.
The program where this database comes from is a voicerecording system creating a new database every day. There is 1 database just for indexing (to view the recordings) and then the daily database is where the recording lies in, that Colum is called RECFILE. I will give you a example of the 2 database.
I have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error: Failed to retrieve data from the database. Details: [Database Vendor Code 9421]
Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.
I have VS 2005 installed in my sytem fyi.We have two databases, say source database and destination database. The databases is in Oracle. Now we need to pull data from Source database, manipulate it and push it into the destination database on daily basis.We are planning to use VB .Net for this and would like to know if this is feasible. Using windows forms through VB .NET, is it possible to create a exe and schedule the exe on nightly basis to pull the data from source to destination.how to do this as for manipulation of data, there is no intermediate database for us?
i need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow now the problem is here i declare something later in the code i write to it objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
