Now i got it to work but the bulk copy is inserting the rows twice, instead of once
and i know the table has the correct rows because i can see it in the gridview correctly
I FIXED THIS PART
my program works fine when i run it in debug mode but not when i place it on the server, it doesnt run the stored procedure when i put it on my server.
[Code].....
Why is my bulk copy duplicating each row, so in my database table the row shows twice.
[code]....
I need to test the counts shown in SSRS report. The report reads the counts from one of the tables.
I need to verify the counts shown in the report. For this I need to insert bulk records in the table (with different userid, datetime, etc).
How can I do this? I really don't want to do this manually.
Looking to build a web application which provides a platform for sending bulk SMS on reasonable rates. Whether i have to sign an agreement with GSM providers for sending SMS or is there an alternative for this? If so, how can i embed the SMS service with my application code?
View 1 RepliesI want to send and receive sms in my asp.net website.I am currently targetting users in India.I may need to send the same sms to thousands of users at the same time.How can I achieve this?
View 4 Replieshave the DataTable having thousands of record ,I need to modify the rows using some c# function,I do not want to iterate through each row.So how can I use linq for it.
View 3 RepliesI'm working on a project for my companies intranet which requires that multiple attached documents to the main DTO of the project need to be autoprinted in the background. The problem is it's a web project and I want the printing to be done under the surface. Now because it's on an intranet only certain people can use it and I can set a communal printer in the background but I'm wondering hwo to actually print under the surface, the attachments could be anything from photocopy gifs/jpegs to pdf/word docs. Should I use the PrintDocument class? Not really sure how to implement this one.
View 1 RepliesI am working on a project that requires a part of it to send Bulk SMS to a particular town( eg Toronto) or any other town, I can generate the coordinates of the town, but my problem is how to get the GSM numbers in the town.
View 3 RepliesI'm using checkbox to select the rows in the gridview. How do I insert the muliple selected rows into the table opening the connection for only one time.
View 2 RepliesI have to update the users based on input value..
here is my code..
[Code]....
using this I can update only one user perfectly but I need to loo update all users based on generic Filedset values?
Lets say i have a button control on a page and a label control. On clicking this button it performs series of actions say Action 1 , Action 2. Action 20 which will take say approx 1 hour to complete. What i need is, once this long processing is started, My web page should show the status of each action on label. Eg. After clicking a button, Label1 text should be "Action 1 is started" after Action1 is completed and Action 2 is started ,.... Label1 text should be "Action 1 Done...Action 2 started" I need this so that my user can see whats the current state of processing.
View 7 Repliesi'm dealing with an ASP.NET 4.0 Web Forms Application in which the DAL is built with a combination of LINQ-SQL and classic ADO.NET (for auditing transactions, and bulk updates).
I have an admin page on the site which performs an update on a bunch of records (could be thousands), and not to mention there is T-SQL triggers in place on those records. Needless to say, its a killer of an update.
So of course, the page is timing out. The update transaction is performing with the following code:
db.ExecuteCommand("UPDATE [tblFoo] SET [IsFoo] = 0 WHERE [Bar] = {0}", bar.Id);
So it's a classic ADO.NET bulk update.
What i've tried to do is make the call to this method asynchronous, by firing off a thread on the button click on the form:
[code]...
The method OnMyAsyncMethod simply executes the above ADO.NET call.
This solved the UI problem, being the page now posts back and refreshes immediately. But then around 30 seconds lateri see that wonderful little flashing light on my Visual Studio toolbar - "an unhandled exception has occured, would you like to attach to process, etc".
So of course, now the actual call in the DAL is timing out.
Am i doing this wrong - is there a way i can perform the update transaction (db.ExecuteCommand) totally asynchrously?
Hopefully you see what im trying to do - i just need to fire off a killer of a T-SQL transaction. The only thing i need back from the call is the number of rows updated.
I want to send sms to the member of my website in USA from my website. how can i progress?
Is it required to buy a web service to send SMS. if So what web service is the best? Is there any free webservice to send SMS? What is that? My main terget to send sms to USA member.
Can i write my own web service to send SMS? If so what is the process.
This may not the best place for this question, but I'm going to give it a shot. I have a large (3GB) file that contains maybe 100 fields, CSV. ALL FIELDS are surrounded by double quotes, a standard CSV file. So, it looks like this:
"12345678", "SMITH", "JOHN", "GARLAND, TEXAS", "75043","","","","37" (and so on)
I need to import this into SQL server but have been unable to find any simple way of doing so using the BULK INSERT. I could obviously do it with some coding [a lot, given the number of fields] but one would think a product like MSSQL would have this most basic of functionality built in.
I have a database of members that I would like to add to a asp.net membership. The client records have no username or password currently, just a table with name and email. how I could do a bulk insert and give each client a username and password.
View 2 RepliesI am making a website. It searches some data from database. When It fetch 1000 records, it runs very softly but when it fetches more then 10000 records then it doesn't display data for second page and I get a error that "Internet Explorer cannot display the webpage".
I also want to share the functionality of the site. It display only 10 records in the page and rest of data will be kept on the object. When user click on next page then it fetches data from that object only. It doesn't go back to database.
It workds nicely when it fetches 1000 records but it gives error when it fetches more then 10000 records.
I am using sqlbulk copy data from tableOne in serverOne to tabeTwo in serverTwo.If data is alreay copied from tabeOne in serverOne to tabelTwo in serverTwo, those data will not beneeded to be copied. How to copy data from tableOne in serverOne not exist in tableTwo in serverTwo toserverTwo in serverTwo?
View 1 RepliesI have another question concerning the bulk insert. I am doing a bulk insert from a text file like (delimiter is | and I have 2 columns):
1|12334
2|23232
How can I check if the user has a file like:
1|12234|2323
2|23233
I mean how to check the wrong columns numbers.
Say i am inserting the data into the database using bulk insert that is from asp.net to sol 2008.Now i Want to Validate the data How can i do that.
View 2 RepliesI have a web form which will send bulk email to our site suscribers, they maybe hundreds or even thousands.Is System.Net.Mail optimal for this purpose?
View 18 RepliesI am creating a bulk email sending facility for our website.I have got all the email in one table so i know i can use email sending features with one loop that take all the emails from the table and send it to everybody.I would like to give them a link that will opt out them from the list.If anybody has done it recently or know any link please suggest it.
View 2 RepliesI suing this code to upload csv file data to sql table.
BULK
INSERT uploadtemp
FROM 'F:ArruniArruniRaj-NathanSchoolcvsparents_with_pupil_adm_nos.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '
'
)
END
After i upload data each and every data inside double quatation like
"Mr J and Mrs P Abbott"
"Abbott"
"Gemma"
"N00390"
"Olivia Abbott"
"N00595"
"T"
How can i upload data without " . And also i want start upload data start from second row. How can i do that? [URL]
I have two servers. One is a web server and one is a sql server. What I'm trying to do is as follows: User uploads a document to a web site. File is stored on a web server in a directory, verified that it's a certain type of file, and saved. When the user presses a submit button, the page is uploaded and the Onclick event triggers a sql bulk insert (not on the same web server.) That's it in a nutshell. The basics of this page are done. The file can be saved but for whatever reason, I'm getting a Operating system error code 3(The system cannot find the path specified.) I've modified the machine.config on the web server to impersonate another user. I've made sure that the directory in question can be reached from both servers (and it can.) I can open/edit/delete the file from the directory from both sides, but evidently that's not the issue.
View 2 Repliesi am having a folder which contains 100 files and each file contain the columns separated by the ' |(pipeline)' and similarly that file contain data also.so i need to bulk upload this folder to the ms sqlserver2005 so that automatically these tables with data added in the database so how to do that one? tell me if any store procedure or the any asp.net program is available for that.
View 1 RepliesI have a requirement that I need to read an excel sheet using asp.net/C# and insert all the records into mysql table.The excel sheet consists of around 2000 rows and 50 columns. Currently,upon reading the excel records ,I am inserting the records one by one using a prepare statement into mysql table.But its taking around 70 secs to do so because of the huge data.
I've also thought of creating a new datarow, assigning values to each cell,adding the resulting datarow to datatable and finally calling dataadapter.update(...).But it seems to be complex because I got around 50 columns and hence I'll have to assign 50 values to the datarow.
