;P

Thanks, it works like a charm. cb

Sorry, I was thinking of a different stored proc. Handle the SqlConnection.InfoMessage event. This gets you the text that is printed using the PRINT statement in SQL (among other things). This is what sp_helpdb uses to print the information about whatever database name you passed as a parameter. Microsoft MVP, Visual C# My Articles

The obvious solution is to use a state variable. While loading, this variable could be unset. Once the form is done loading (say, in the OnLoad override in your Form), set this variable. In your client event handler, determine if the variable is set. Only then do you execute your code. Microsoft MVP, Visual C# My Articles

You're Welcome. I suggest getting a book, it will helpyou greatly to get started with C#.

Handle the SqlConnection.InfoMessage event. With each message printed by the server this event is raised. You can get the message from the SqlInfoMessageEventArgs that is passed to your handler. Microsoft MVP, Visual C# My Articles

Either escape them using "\" (so "\\") or use the literal string identifier "@" before the string, like "@C:\Program Files...". Looking at the documentation for the compiler error would've told you that. Microsoft MVP, Visual C# My Articles

Missed that, danm Evyln Woods! Thanks, cb

Check your event log (Application events).

betterc wrote: In the end it worked :rose: There is nothing new under the sun, But there are lots of old things we don't know. - Ambrose Bierce

Agrreed and thank you. I have bought several ADO.NET books and am picking it up really quickly. I was doing pretty good until I needed to write an application using an MSDE DB on a distributable CD. In one sense since my application will be just referencing (reading) the DB my work is easy. The hardwork is in developing a 'setup' routine that installs MDAC, .NET, MSDE, my application and reference the data on the CD. This kind of through me into using transact-sql, something I've never needed to do before. I found plenty of examples of transact-sql statements and I've written qutie a few ExecuteNonQuery() routines but I couldn't find an example that put it all together. What you pointed out was that my commandtype = storedprocedure which I didn't think I needed. So with your help and my recently purchased "The Guru's Guide to Transact-SQL" I'll get to experimenting. Thanks again, cb

Hi I wrote a custom column style. The style only allows viewing, not editing. (Time is money, and money is something my client doesn't like parting with.) The main problem is that the column style needs to return the preferred, and minimum, width and height for it's contents BEFORE the paint operation takes place. I fiddled this by making a fixed height, and then the form housing the datagrid resizes the wrapped column so that the sum of the column widths equals the datagrid width. Too much code to include here, but you get the idea. Imperfect solution for an imperfect world. (Or is the world imperfect because people like me are willing to settle for less than perfection?) Don't worry, nobody lives forever.

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