I have a FormView through which I set up the default new, update and delete commands for communicating with an SQL Server database. When the CREATE command is executed the data is added to the database and some images are uploaded to a server and linked to the database.
When I press the Visual Studio's default FormView DELETE command I obviously only delete the selected row in the database and not the images on the server. I marked the uploaded images with images ID + "name" , so I could delete them if I could only retrieve the ID of the row being deleted by the DELETE command. How do I do retrieve the ID of the deleted row in C#?
How can I retrieve information from delete rows. I delete some rows from table in dataset, then I use method GetChanges(DataRowState.Deleted) to get deleted rows. I try delete rows in original table on server side, but it finished with this errors. I try get value of columns from row, which was deleted [Code]....
my requirement is to delete database value automatically on a given date. In my application i am inserting records in database, now admin will give the expiration date for the value inserted in db. On that particular date, the value should be deleted automatically. I want a logic for this in asp.net. I am using SQL 2005 with C#.
I have a site that show infomation that are contained in div blocks. The info is taken from a database so the user can change the info or delete it. When the user deletes a div block i want to use jQuery to animate that its disappearing and also that its deleted from the database. How can i do this without doing a postback, i dont want the site to reload, i just want the Div block to disappear visually and be gone from the database at the same time. Would i use Ajax update panel to achieve this ?
i have created a table in sql server 2005 with two fields ImgId and ImageURL,where ImgId holds the serial number and Image URL holds the URL of the image file about where it is located in my hard disk.
Now i want to retrieve images from the database using its filepath.
I think i had done everything right,I tried to retrieve images in a gridview but dont know why it doesnt shows anything when i build the code.
I have a question regarding how to retrieve an mp3 file stored as a byte[] array from the database and display it in a form and let the user to download/play it?
I have 5 radiobutton list and 5 checkbox list.Data come for this radiobutton list and checkbox list from the database.
now after user selecte items from this control i want to retrive back those data with the price from the database.further more I am creating string from this checkbox list to display image.the string came from radiobuttonlist and checkboxlist values.I
I write the following code but there is an error. I just want to retrive the image which I have save into tha database from the sql server and to display in the picture Box(image)
On my website, I'm using webservice to retrieve the data from (SQL Server) database. To improve performance, I like to use jQuery to retrieve the data from the webservice instead of using C#. The data values should be assigned to the drop-down list which I'm using in the aspx. Can anybody tell me how to do this? I'm a newbie to jQuery.
i got a Food table and a Notification table. each Food has an expiry date. I wish to put all foods which are going to expired into the notification table. since user can create new food anytime, how can i update the Notifcation table once got any new food (but with near expiry date) added? and how to make sure the Notification table retrieve the nearly-expired food everytime (mayb update once everyday??)
it contains the following field "id","name","amount"
when the user enter the "id" in TextBox1 and click the button then the "name" and "amount" to that corresponding id should be dispalyed in the TextBox2 and TextBox3.
i have made a webpage for user registration where i have to save image of user in data base which i have done successfully but i am unable to retrieve that image
I want to get the customers info and companies of this companies of products they deal with here is my query in linq
var query = from sd in db.Survey_Details select new {[code]...
customer table has about 3000 customer who every one of them fill a survey of 2500 product till now survey_details table has about 90,000 recored an will increase by 100% every year this query run good without binding in RowDataBound when i want to work with RowDataBound this is too slow and data never come i think i may take about 5 hours to come
i am reading image from database (sql server) by using handler and getting it in memory stream. now i want to store that image on server in the folder named Images.
I have followed the example from this page for vb.net. [URL] The upload works fine, but not the download. Everything is as the example but its not working. This in running in my development enviroment i.e httpL/localhost. Do i have to configure my asp.net or something, or the image control on my web page.
I have some problems in database connection and wonder if I have something wrong in my code. Please review. This question is related: Switch between databases, use two databases simultaneously question.
[code]....
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
i was wondoring which thing is better from below two... first one- retrive data by creating webservice second one- create database connection from code behind call storeprocedure and retive data
