I need to save more than 20 rows at a time in database, i did it for previous requirement using a loop, provided rows were not exceeding 10.
Now i have rows exceeding more than 20 or 50, how can mass save operation be performed using asp.net web application.
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
My XML will be like this
<root>
<Customer>
<CustomerID>GUID1</CustomerID>
<CustomerID>GUID2</CustomerID>
<CustomerID>GUID3</CustomerID>.....
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesI am new in asp.net..My Problem is i have 3 textboxes..
in first text box i enter A1,
Second Textbox i enter 3,
Third Textbox i enter 5
after button click i want to store
A1B1,A1B2,A1B3 as per second textbox i enter 3
A1C1,A1C2,A1C3,A1C4,A1C5 as per Third Textbox i enter 5
how to generate the above rows and how to save in database
how to save the log out time of the user when it clicks on log out button?
and also, if there is any way if user closes browser directly instead of clicking on log out button..
I have check box field in grid view and I want to save checked row in sql server 2005.how i can save.
View 1 RepliesI have used Jquery Qucik serach Plugin and Its working fine for me. But I want to get the each record after filter when click on save button.
let's say gridview has total records are 4 then filtered records are 2.When click on Save button 4 records are getting.
write the query for merging two rows in a table with same date and time into one row...
2009/12/23 13:46:50 -0.43546 0.02395 -7.1621 0.45529
2009/12/23 13:46:50 0 0 0 0
2009/12/23 13:47:00 -0.47114 -0.00515 -7.1779 0.42751
2009/12/23 13:47:00 0 0 0 0
i want to merge this same datetime rows into one row ..
I have success to store the login tim for the user but i am unable to save the logout time for logged in user
When saving logged in time, logout time is saved as null(thats ok for me)
but when user log outs it is saving the logout time on the next row instead of saving in last updated row for that user
I need to calculate the time diffrence in hours for particular date for the users
I'm having a little issue, currently my code, first it saves to DB then send an email in both codes it saves and send the current date and time. I use the following function to get the current date Now() . The problem is when it saves to DB, it saves the current time and date using the timezone of DB server location and the email send the date and time and appear in my wanted timezone (easter time zone). I was wondering if it's possible to make the also save to DB with the correct time zone without using any javascript.
View 2 RepliesIs it possible to edit images using a javascript library and then send the edited image to the server for saving.
Edits will be in real time, means the user can see the edit result in the same time he is editing without the need to refresh the page.
I want a javascript library to do some edits on an image on a webpage 'such as crop, resize, rotate,...' and send send the edited result to the server.
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
I want to allow user to save time ..... How can I manage the time.....
I mean How I will provide interface to user to insert time ...How will I manage in database...
im using sqlbulkcopy to import all the columns and rows in an excel file to a database. My question is, if my database has 1 more extra column which i have to map it to a session variable and that extra column in the database is not found in the excel, isit possible to do something like dat?
View 3 Repliesi believe That Saving Files In DataBase is good for Security Issue , But in My Scenario i didnt Care about Secrurity Issue,
i want to ask U guys which Better Save Files into DataBase or save it on Directory on Server, where This Issue Required:
1-(Reduce Load on Server and didnt affect server Memory).
2- Security not important.
if they have the same result i will move to DataBase Saving.
I have a data entry and editing form and in every data entry or update event, I have to send an email to a dynamic list of recipients. I have been sending the email as soon as the user clicks the save or edit buttons but am thinking of first saving the data to the database, and then sending the email later. I want to do this partly to improve the response time of the application as the email sending tends to take a long time than desired.
View 4 RepliesI want to save binary information like images, files ,etc to SQL server database.
View 1 RepliesI want to insert multiple rows of data from a gridview to database table in a single button click event.
View 1 RepliesHow could I go about having a client in various time zones select a date and time in their web browser and save it as utc time in my sql database? This date is a date in the future, so whether or not the date is in daylight savings time could change so I'll need to account for that.
The site is a asp.net c# site.
I have an excel sheet that contains around 30,000 rows and 18 colmns. These no of rows and columns may increase in future. I need to read all these records from excel sheet and insert into a table in sql database. For reading the excel book I am using Oledbconnections. The possible solutions I have known as per my knowledge, to insert the data are
1. To insert one record at a time which makes 30,000 database hits. How will this affect the performance?
2. To use liked servers - bu this is not working for me.I do not have database permissions to use linked servers. So, the only option i have is the first one.
I am Generating a Word Document by using Following Code:
StringBuilder str1HTMLContent = new StringBuilder();
str1HTMLContent.Append("<html>".ToString());
str1HTMLContent.Append("<body>".ToString()); [code]....
The word file is Created and popup on windows .How can i save this created word Document on Database, or on server folder?
how to save a base64 string without losing any of the bytes in the process.
View 2 Repliesi would like to do a project that enable to capture photo from webcam, and record audio from microphone store to database. but the photo and audio store in folder and the database only store the filename. later i set the path and its play back the audio and show the photo.
View 2 RepliesI would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that?
View 3 Replies