C# - Want To Update Picturepath With Fileuploadpaths(string) In The Same Table (Pictures)?
Mar 26, 2011
How do you do an update statement?I would like to update UserID with this string theUserid and I would like to update picturepath with fileuploadpaths(string) in the same table (Pictures)
OdbcCommand cmd = new OdbcCommand("UPDATE Pictures
SET ('" + theUserId + "','" + fileuploadpaths + "')
WHERE (UserID, picturepath)", cn);
Not sure if its
UPDATE Pictures
SET UserID = "+ theUserid +"
picturepath="+ fileuploadpaths +"
Where UserID = theUserid
picturepath = something already in my db?
EDIT:Ive tryed this:OdbcCommand cmd = new OdbcCommand("UPDATE Pictures SET picturepath ='" + fileuploadpaths + "' WHERE UserId = '" + theUserId + "')", cn);
but I get the error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
I'm trying to select UserID, FirstName, SecondName, PicturePath(from Pictures table) LIKE FirstName (string search = textbox.text)
OdbcCommand("SELECT UserID, FirstName, SecondName, p.PicturePath FROM User LEFT JOIN Pictures p ON p.UserID = u.UserID WHERE FirstName LIKE '%" + search + "%' ORDER BY UserID DESC", cn))
Ok says i have a folder thats like www.some-url.com/data/ and in data there is all picture files there and i want to use a ASPX controller like in PHP to dispaly all the pictures in a image boc thats 250 250 and be a clickable link but in a table too how would i do thing..
In a break down
I need to view all the picture files as picture in a image controller like the asp:Image
I am trying to update my table ARTICLES and it has a field COUNTER, Everytime a user enter this ARTICLES, the page_load event runs a LINQ to SQL query taking the QueryString as parameter, increasing the COUNTER field in 1.
I'm working on an ecommerce project that is missing 5,000 product pictures.
I am trying to assign all products without pictures into a category located on a mapping table.
I know an insert can be accomplished from one table (or subquery) to another but I only need to find the product IDs and insert them with default values into the category mapping table that has all non-null columns.
The following code is the farthest I can get without help (I'm not strong in SQL), it won't work because my subquery returns many rows while the SQL statement is designed to insert one - I don't know how to handle this...
[Code]....
Any help would be appreciated from those more experienced than I. BTW... there are no known search results for this type of solution - if there is even a solution.
I've got a single table, with project information and schedule information. To make the data easier to present, I created a tab control with two panels (a detailsview in each). The first tab is for project info, the second tab is for schedule info (again, all fields in the same table). The problem is, if i change info in both tabs, and then hit the update button, only the data from one tab is added to the table. I think this problem is simple to fix, and boils down to the way I have the page organized, but I can't quite figure it out.
I've boiled my code down to the following conceptualized structure:
[code]....
When you click the update button, you return to the listview, but with only the information from your current tab saved. How can I get it to update from both detailsviews?
I'm sure this has been answered many times already, but I still can't seem to find exactly how to search for this issue, so apologies in advance.
Anyway, I have a VB script for entering a row of data into a table by a web user. When this row of data is entered, I wish to take some of the values from the columns of the "primary" table, and have that data automatically create a new row of data in a "secondary" table. I think I'm part of the way there, here is my script:
[code]...
"ProductsByMfr" is the "primary" table - the table that the user adds data into when the button click event is fired.
"DealerPricing" is a "secondary" table that I wish to have some of the data from the newly-entered row in ProductsByMfr copied into. Am I even close here?
I'm using the ASP.Net Membership provider, but I don't want to allow system administrators to DELETE any users. Instead, I simply want to mark them as locked out (aspnet_Membership.IsLockedOut) of the system so they can't log in when an administrator assigns them to a role titled "Inactive". Make sense? Right now my trigger isn't throwing any errors, but it's not working either. Here's my trigger (which is on the aspnet_UsersInRoles table):
I am trying to delete or add rows in a table but since the table is in an update panel,upon deletion the row goes away and then comes back.I have tried using return false but it does not seem to work in IE or FF.
UPDATE SPECT SET SRE = CLSS.NEWSID FROM SPECT INNER JOIN student (NOLOCK) ON student.ID = SPECT.ID INNER JOIN CLSS ON CLSS.GID = SPECT.GID ON CLSS.GID = student.GID WHERE student.PID = '20201' AND CLSS.PID = '20201' AND SRE IS NOT NULL
However, student.PID and ClSS.PID need dynamically reach through from table CLSS to get each row of PID.
I have table a and would like update table a whose values from table b, but not update all rows at table a. Only update record ID in table a match record ID in tableC.
Here is my query
update a set a.Desc = b.Desc, a.Value = b.Value from TableA a, TableB b where a.name = b.name and a.ID = b.ID and a.ID in ( select ID from TableC)
I only have 12 a.ID match TableC, but above query update whole TableA.
How to only update 12 record at TableA from TableB?
I'm trying to update one my my tables from a field in another table.
I have Address fields on both tables and the old table has some addresses I need to copy over (I dont want to copy/paste or type them all in obviously). I basically need to:
I have to find the best way to do this using LINQ. I need to summarize an amount in a iTransaction table by
Account (e.g. 12345) and add that amount to an same Account ( e.g12345) if it exists in a iAccount table . Here is the code which syntax checks ok and tested ok up to the .submitChanges statement (i.e. I stopped and didn't allow the submit.
Following is the LINQ code. (1) Is that a good way to do this. OR should I try the INTERCEPT.
(2) How is the best way to insert a new record/row in the iAccounts table if it DOES NOT exist in the iAccount Table.
i want to make my site to have one backround picture that doesnt scroll i want the scroll in the table that will be inside the backround. for exmple this page here. [URL]
In my website on Home page, at the Top I am showing 5 pictures which are displayed fade-in, fade-out mode, one after another. Now, the requirement is to randomize these pictures.
I have image paths that comes from database and I want to show small ones in Listview and when I click it opens in ModalPopup window with Next and Previous, Close Features..Something like lightbox..I can't make it to work with lightbox.net...
I want to use auto complete in a textbox to display the item. I have a vague idea to do that. But the requirement need the company logos with the names in the auto complete.
Although it may not seem like that but there is a little questions about this subject.I am not asking if I should use DB or filesystem, the file system it is, but I am asking what is the best way of organizing pictures in file system that will be used with asp.net application? I am talking about tens or even hundreds of thousands of picture.
To elaborate a question a bit.
Where should repository be located, create another VD in IIS or in application VD, or somewhere outside IIS? How to organize file patsh, put them all in one folder or create subfolders. If so how to name all those folders?How to handle multiple sizes of the same image? where to locate them?How to sync folders and images with database?What else crosses your mind, and you think it's important..
I've done something myself allready, but I am asking if someone had some experience with this. Maybe it could be done better yours way.
I put things like this
I stored pictures in IIS folder, because storing them outside of iis make them unable to use in web, because of paths. You cannot use file path in web, it must be virtual file path.
http://images/1.jpg istead of C:images1.jpg in the root I had subfolder for each picture size
root- +400x300 +600x400 +1024x768
Named images by id from database. If the ImageID from database is 45678909, the name of picture is 45678909.jpg an it's location is
I sliced the picture name two by two, and create subfolders. the point was not to have more than 100 files in folder. Was this good idea or stupid one? How would you organize this? For person, this organization with tons of folder is not easy to use.
Name of the image with its relative path I saved in database table with description and time of insert etc. path: 45678945678909.jpg
I have imaages stored on my data base as VARBINARY(MAX) DataType. I would like to display them in a user profiles. I don't understand how to load images from code behind in asp.net controls.The code I have so far is ass follows but this code does not display picture in a control. The code snipet is as follows:
I have upload control on my asp.net page. I upload pictures in folder cars and they show in windows explorer when I open that folder (cars), but in Visual Sudio they act like they not include in project ( that is the reason why they don't show on image control which point to some of them. What did I make wrong ?
