What tool to use??????
-
I have been developing applications in VB.NET and have developed some simple Web applications but have not used ASP.NET. A project has come my way where the client needs an emergency backup CD of a couple thousand records and wants the CD to have the ability search and retrieve records stored on the CD. My question is what tool should I use. I first think that what I should do is write a simple VB.NET application using ADO.NET to search and retrieve data. Of course to run the application on the disk I take it that it will have to be installed along with the framwork. I next wonder if what I should do is somehow convert the data into XML (using ADO.NET???) and then search using web applicaiton using (ASP.NET????). What do you all think would be the best approach to provide a CD that the client could just insert into their PC and bring up a search application??? Thank you, Craig
-
I have been developing applications in VB.NET and have developed some simple Web applications but have not used ASP.NET. A project has come my way where the client needs an emergency backup CD of a couple thousand records and wants the CD to have the ability search and retrieve records stored on the CD. My question is what tool should I use. I first think that what I should do is write a simple VB.NET application using ADO.NET to search and retrieve data. Of course to run the application on the disk I take it that it will have to be installed along with the framwork. I next wonder if what I should do is somehow convert the data into XML (using ADO.NET???) and then search using web applicaiton using (ASP.NET????). What do you all think would be the best approach to provide a CD that the client could just insert into their PC and bring up a search application??? Thank you, Craig
If you've got to distribute a CD to the client then including the .NET Framework isn't that big of a deal. You can use the bootstrap installer sample from MS to install the Framework when the CD is loaded. You could use MSDE for the database. If there are thousands of records I would opt for this rather than XML. If your data is on the CD, distributed to the client, why would you need to create a web app to search it. Last, forget VB and use C#
-
If you've got to distribute a CD to the client then including the .NET Framework isn't that big of a deal. You can use the bootstrap installer sample from MS to install the Framework when the CD is loaded. You could use MSDE for the database. If there are thousands of records I would opt for this rather than XML. If your data is on the CD, distributed to the client, why would you need to create a web app to search it. Last, forget VB and use C#
-
I don't know anything about MSDE or C# but I'm always up for a new adventure. Also, the client is giving me time to play. Can you tell me a little of why C# and why MSDE? I'm very interested. Thank you, cb
MSDE is basically the desktop version of SQL Server. C# because VB/VB.NET sucks :laugh:;P
-
I have been developing applications in VB.NET and have developed some simple Web applications but have not used ASP.NET. A project has come my way where the client needs an emergency backup CD of a couple thousand records and wants the CD to have the ability search and retrieve records stored on the CD. My question is what tool should I use. I first think that what I should do is write a simple VB.NET application using ADO.NET to search and retrieve data. Of course to run the application on the disk I take it that it will have to be installed along with the framwork. I next wonder if what I should do is somehow convert the data into XML (using ADO.NET???) and then search using web applicaiton using (ASP.NET????). What do you all think would be the best approach to provide a CD that the client could just insert into their PC and bring up a search application??? Thank you, Craig
I've had to do the same thing - create an asp.net web application that would work online and in an offline CD. My solution was to create an export routine that loaded data from sql server into a dataset then call the GetXml method and save as an xml file onto the disk. I then used html pages with javascript that loaded the xml files into a MSXML object and did a search through all the nodes using XPath and string functions. This selected the relevent result and I then applied an xsl stylesheet transformation of the xml and inserted the html into the search page.
function doSearch(sSearch, sDataSource) { try { // Load the XSL var xsl = new ActiveXObject("Msxml2.DOMDocument.4.0"); xsl.async = false; xsl.load("xsl/searchresults.xsl"); var xmlSearchDoc = getSearchResults(sSearch, sDataSource); // Transform results.innerHTML = xmlSearchDoc.transformNode(xsl); } catch(e){results.innerHTML += "doSearch(sSearch, sDataSource) " + e.message + " "} } function getSearchResults(sSearchString, sDataSource) { try { var sDataXmlFile = "xml/" + sDataSource + ".xml"; var xmldata = new ActiveXObject("Msxml2.DOMDocument.4.0"); xmldata.async = false; xmldata.load(sDataXmlFile); var sXml = ""; var oDataNodes = xmldata.selectNodes("/Response/Data"); sSearchString = sSearchString.toLowerCase() var sFieldText; var oDataNode; var oFieldNode; var parentXml; var iDataNodesLength = oDataNodes.length; for(i=0;i"} }Jim