Whenever I create a master page (or a user control), the VS environment doesn't create the code-behind links, nor, if I do it manually, which, of course, I shouldn't have to, it doesn't link them, call the .cs, understand the code file is there, or even show it in the window when Intellisense tries to locate it with the codefile directive. Strange. It shows both files when added to the Project Browser view (the "template".master, and the "template".master.cs), but it doesn't put one indented under the other, indicating linkage, like it does with normal web pages (.aspx). I have exactly the same problem with user controls (.ascx) I can't figure out why, and have apparently applied all latest fixes. Can anyone help me diagnose this? I suppose I could back everything up (projects), delete and reinstall, but it seems like it ought to be simpler than that.... Thanks!!

The logic and the simplicity of that just dawned on me - I still get "protected" storage from the site, and retain search and keyword capbilities. Plus I don't have the overhead of database load/unload and the associated database size issues. Thanks Paul - that seems to be the most sensible approach and also easiest.

That would certainly make it easier, but won't having a database and an "add picture and keywords" type of functionality make it easier to store, retrieve, and catalog? I have literally thousands and thousands of travel photos from all over the world, and want to be able to give friends and family the ability to search by subject, then return those that match the criteria, which would then show thumbnails, and a click would bring up the full size image.... Thanks for all the help!

Thanks Paul. I also have the ability to use Access, and have samples for storing & retrieving files from that. Any advantage to MySQL, since I don't have MySQL, but do have Access? i.e., it'll cost me some money to use MySQL, where I can use Access for free, and this is a personal web site for storing photo's, etc.

Thanks - I'll go get a book and see if I can find some examples.

I'm generally familiar with SQL Server 2005 and I know there's an IMAGE data type that I can use to store pictures in the db. Can MySQL do the same? I'll be heading to the book store tomorrow to pick up a book and read up on this, but any experience in this area, particularly including taking pictures that are saved on my local disk and storing them in a web-based MySQL db would be greatly appreciated. I've seen sample apps for SQL Server 2005 that do this, but not MySQL and get the impression it's not nearly as easy, but probably possible. Thanks!!

modified on Monday, December 24, 2007 10:29:00 PM

Thanks. I guess working in SQL Server Studio Express isn't the full product and isn't giving me all the options. I'll get the SQL Server access in the next few days and try it on there directly.

I used to work in SQL Server 2000 and it's been a while. Now getting into a project with SQL Server 2005. I used to be able to create an auto-filling sequential record ID (effectively a long unique ID) assigned to every record so I could use that as a relational field among related tables. This seems to have been replaced by the uniqueidentifier type in SQL 2005? The problem is that a GUID is effectively a formatted string and a lot of characters, where the long is preferrable for me. How can I get a long int id that is sequential, and therefore unique for each record? Thanks!

Here's what I've got: This handler: this.dataGrid.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgItem_Command); And this code: private void dgItem_Command(object sender, DataGridCommandEventArgs e) { switch(((LinkButton)e.CommandSource).CommandName) { case "Delete": case "Edit": case "Select": DGResponder(((LinkButton)e.CommandSource).CommandName, e); break; default: break; } } void DGResponder(string cmdType, DataGridCommandEventArgs e) { if((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) { // Retrieve the text of the Unique value from the DataGridItem // In: Convert.ToInt64(e.Item.Cells[3].Text) or whichever 0-based column(cell) // Get the type of item - delete, select, update, etc. // In: cmdType Response.Redirect(/*Page to display on*/); } } Hope that helps... Mike L.

Here's what I've got: This handler: this.dataGrid.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgItem_Command); And this code: private void dgItem_Command(object sender, DataGridCommandEventArgs e) { switch(((LinkButton)e.CommandSource).CommandName) { case "Delete": case "Edit": case "Select": DGResponder(((LinkButton)e.CommandSource).CommandName, e); break; default: break; } } void DGResponder(string cmdType, DataGridCommandEventArgs e) { if((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) { // Retrieve the text of the Unique value from the DataGridItem // In: Convert.ToInt64(e.Item.Cells[3].Text) or whichever 0-based column(cell) // Get the type of item - delete, select, update, etc. // In: cmdType Response.Redirect("JobDetails.aspx"); } } Hope that helps... Mike L.

Hi, I'm hoping someone can help me with a problem - I'm a newbie, and trying to write a somewhat simple app. I've gotten Word documents uploaded to my SQL server, using the FileUpload Demo as a model. With the documents in SQL Server (image column), I need to be able to pull them out and open them, either in a browser window, or in the Word app - either one is fine. The code below shows how I'm trying it now, but it seems that since I'm writing out to the .aspx page using Response. OutputStream, the application doesn't see it as a Word document, even though I've set the ContentType properly as "application/msword". They are retrieved from the SQL server OK - my problem is opening them either in the browser (preferred) or in the Word app. On my laptop, they open as gibberish in Front Page, rather than Word. Can someone show me the error of my ways and help me fix this problem? I'd really, really appreciate it! My code to do this is as follows: private void ShowTheFile(long FileID) { // Define SQL select statement string SQL = "SELECT FileSize, FileData, ContentType, FileName FROM tUserDocuments WHERE UniqueFileID = " + FileID.ToString(); // Create Connection object SqlConnection sqlCon = new SqlConnection(RM.GetConnString()); // Create Command Object SqlCommand sqlComm = new SqlCommand(SQL, sqlCon); // Open Connection sqlCon.Open(); // Execute command and receive DataReader SqlDataReader dbRead = sqlComm.ExecuteReader(); // Read row dbRead.Read(); // Clear Response buffer Response.Clear(); string conType = RM.Clean((string)dbRead["ContentType"]); byte[] fileData = (byte[])dbRead["FileData"]; int fileSize = (int)dbRead["FileSize"]; long fileID = FileID; string fileName = RM.Clean((string)dbRead["Filename"]); // Set ContentType to the ContentType of our file Response.ContentType = conType; // Write data out of database into Output Stream Response.OutputStream.Write(fileData, 0, fileSize); // Close database connection sqlCon.Close(); // End the page Response.End(); } Thanks VERY much for any help you can give. Mike in Bangkok -- modified at 0:55 Monday 12th September, 2005

Hi, I'm a newbie trying to write a fairly simple web app in C# with two complex issues - I need to present a document dialog box to the user, let them select a (usually MS Word) document on their local drive(s) and store it in a SQL Server 2000 table/column. I'm wondering if someone has some sample code (preferably C#) and can tell me what type of column needs to be defined in SQL Server to hold the document. I'll also need the reverse: pulling the document out (mostly Word documents) and displaying it in the browser window. I'm basically trying to store and retrieve these Word documents from various users in SQL Server 2000. Any help would REALLY be appreciated! Thank you very much in advance! Mike L.

Thanks - we checked the MS KB's but it says we should be able to do the install on a fresh Win2003 server. We can't deinstall the server and install XP to try this - the server's already up and running. We're faced with how to get SQL Server 2000 on a running Win 2003 Server.....

Can anyone help us with this? We're trying to install SQL Server 2000 on a Windows 2003 Server. MSDN says we should be able to complete the install and then update to SP3. When we launch the installer and tell it that we know it's not supported but go ahead anyway, the installer goes away and never comes back. The process remains alive with no activity, but doesn't install or give any additional messages. We can't get an installer CD with SP3 already applied, of course, so we're unable to get the SQL Server installed. Has anyone seen this? Solved it? Have some consoling words of wisdom? Thanks - any help is really appreciated!

I sure could use some help. I have a web app with frames. I want to be able to notify frame2 when something takes place in frame1. Should be simple, but maybe I'm the simple one. I've got the event structure working because I can fire an event in frame 1 and receive and act upon it in frame 1. But when I fire it in frame 1 and try to handle it in frame 2, it is apparently never received. The event appears to fire fine (I get no errors and see it pass the statement OK in the debugger), but the handler (which also appears to be declared correctly, since I get no compile errors) never seems to receive it. Can someone point me in the proper direction? I really appreciate it! Mike.

Me and a business partner have what we believe is a great idea. We've started working on it. While the overall concept isn't too difficult, we're in a little over our heads. We're looking for a Web, .NET, C# programmer who wants to join us, who lives here in the Bay Area (San Francisco). To be clear, we're doing this on a shoe string. We can't pay, but we're offering a part of the company that we hope will be lucrative once we go active. We have several trial sites lined up and are ready to go. Not having a product is a kind of limiting thing... We know we have a great concept - we can fill you in on the whole thing under NDA - but we need a sharp person to help us make it real. Interesting in joining a dream? Reply to this message and we can get together and see if it all makes sense! Thanks! Mike.

My project framework currently uses an HTML frame page (once the user logs in). The frame is fairly simple in concept (banner at top, then a contents column, and a main area, both below the banner/menu). A click in the banner/menu area should change the form in the main and contents frames. I can create an event which issues a Redirect to both the contents and main windows (they almost always need to change at the same time), but the Response.Redirect won't work in that context - I get a .NET error saying so (I assume because the event receiver is in the form which then is redirected...) I can't simply use a BASE, TARGET tag in html, since both sub-windows(contents and main) need to be redrected by a single click. Can someone suggest another means of page redirection that will work with frames and events? What I basically require is a menu area at top, and two indepently scrollable (horiz and vertical) areas below (they don't need to be resizable, but that would be a nice plus). Thanks very much for your help!

Thanks very much for this. I'll give it a try. I'm travelling in China, so my time sync is... well - isn't. But this gives me what I need to get working.

I must be missing something in the big picture.... Using CodeBehind, how can I dynamically create new controls (in this case, TextBoxes) which I can relocate on the Web Form programatically? I can see how this is possible using Windows Forms (the LEFT and TOP calls are there), but not in a Web Form (I can't seem to find a way to change the location, just WIDTH and HEIGHT). The number (I also can't seem to create controls programatically, either...) and location of text boxes and potentially other controls will vary in my application, depending on the number of db rows retrieved from a user query. Any help is appreciated! Thanks! MikeRoad