I have a text file. now I want to insert those text file's data into my database by C#.net
my text file is like:
rec alex dallas usa 25/2/1989
rec farguson la 12/8/1988
rec hopkins ny 17/9/1988
I want to insert data from name (alex, farguson...etc). I don't want to insert 'rec' keyword.
If one record is already inserted then that record will not be added again.
I'm new onto LINQ and im working on a asp.net application which uploads a requisition from a preformated text file that is coming from another application.
Th format of the file its like:
HDR 001000 Description
DTL PartNumber CatalogNumber ItemDescription RequestedQty RequiredDate
DTL PartNumber CatalogNumber ItemDescription RequestedQty RequiredDate
DTL PartNumber CatalogNumber ItemDescription RequestedQty RequiredDate
I want to insert information gathered from the text file readed using streamreader with master/detail using LINQ datacontext into the database.
Heres the code of a test page to loop through the file:
[Code]....
Conseptually what I'm doing is simple, and technically it may even be simple, but I'm still rusty. Here's what I'm trying to do:
I have a webform that allows the user to enter a new record, and in there I have also included a couple FileUpload controls. Upon clicking the "Save" button, I'm saving the details entered into one table (ITEMS), and also inserting the FileUpload details (path, id, upload_user) into another table ATTACHMNTS). Because one ITEM can have many attachments, I needed to split the tables up. So on save, I need to save the ITEM, save the ATTACHMENT, and then also put the ITEM_ID in the ATTACHMENT table. I'm second guessing myself because I think all I'd have to do is after I do the ITEM insert, do a SELECT MAX on the ITEM table and hold the newest (MAX) id in a variable and then use it in the ATTACHMENTS update. I'm not 100% on this because there IS a chance that someone else could save a few milliseconds later and I'll link the wrong ITEM. See my delima?
Suppose we have a website with 10,000 viewers each second. And we want to insert the viewer's information to the SQL database. So we must insert 10,000 records to the SQL each second. And it may take long time to do.
My question is: How can we decrease this process.
I have code for inserting a record into the db, it works fine from the admin part of my website but when i put it on the customer side duplicate records are inserted into the db, any ideas? I cant for the life of me see why. I have just also noticed that when i add the claim the first time it adds the duplicate entry, if i press the button again it only adds the entry once, if i refresh the page add the info again, 2 entries, click add again 1 entry?
[Code]....
I am using LINQ Expression to insert records in SQL Table. My Table dosen's have any Primary Key Field. Whenever I Am trying to Insert Records in Table using LINQ Expression, this always occurs an Error that 'the Table You are using to insert Dosen't Have Any Primary Key Field.
How I Will Insert Records Without Having Primary Key ?
I have Gridview on my webapplication and it is getting filled with multiple rows . When clicked on Save I want to Insert all rows without calling multiple database hits.
Is there any way I can insert all rows by single db hit?
i have one xml blank file in my project .. i want to insert data from text boxes... my xml structure like
<?xml version="1.0" encoding="utf-8" ?>
<userdata>
<Project_name id="">
<datasource></datasource>
<database></database>
<server></server>
</Project_name>
</userdata>
project_name should be like Primary Key.. how can insert data through code
i am using an ImageButton with onClick Event above a profile on a footballer.
On Click event, a logged in user on the site can save the footballer to a Junction table called FavouriteFootballer that has
a GUID UserId and FootballerId GUID as Primary Keys.
The problems is I need to warn the user if they already have the Footballer Stored as a favourite in the database
(With a Label or MessageBox PopUp) and not sure how to with the code I have.
In code behind I have the following
[code]....
[Code]....
this is my html code
[Code]....
this is my code behind
[Code]....
this is my bal code
acuttally
in my javascript popup i am getting the checked values but i need it in record by record in the lblsave data
I want a tutorial or an example showing on how to upload details or records on text file to Gridview.
The way it is with Excel file where we upload to Griview.
I want to be able to insert any kind of text into a sql 2005 database. The column im using to store this is ofVARCHAR(MAX) type . Basically , even if the text contains special charectars or unicode content or html tags I should still be able to insert it into the database without any errors. Please guide me on how to achieve this.Things I tried that did not work !- changed the column to type NVARCHAR(MAX)-Tried Server.HTMLencode for the column that accepts the textIs regex a solution for this problem. If so how can i implement it?
View 8 RepliesI have one table with three columns, one of them datatype is nvarchar and I want to insert text in this columns in diferents lagauge.
Lets assume Hindi langauge. I know I can insert text in hindi laguage by using N prefix.
for example. Insert into myTable(column1) value('इमरान खान').
But I dont know how to use this N prefix in stored procedure.
when need to insert into Text.boxes details from user (name,e-mail, e.tc.) and to get record of it into DB on other page. I try to get after pressing Submit btn:
DataSource.InsertCommandType=SQLDataSourceCommandType.StoredProcedire
DataSource.InsertCommand="CustomerInsert" ....,
but I'm getting: Server.Transfer("ErrorHangler.aspx")
I want to insert username and password into two tables (say table1 as well as table 2) using stored procedure.
View 4 Repliesthis is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db.
the problem is the excel file may be updated or changed and i have to periodically import it and perform the process but I still cant check or compare between the two Data Source (excel, sql) as I violate the entity integrity (PK)
i found a kind of stupid approach that each time i want to import the file i will empty the table then re-insert the data, but at this step a new problem raise that other tables are !engaged! with it ... so i will violate the referential integrity (FK)
i looking for solution to compare between two sources for each tuple / row, ignore the existing one and insert the new
[Code]....
I am using an sql server 2005.
I want to insert to my table a column of some date,like that the user can insert a text file.
how to do that?
and how can I make that the user can only insert an int of length 9 for id?
I am having a list of contents in the notepad.
I having the following content.
000012|vasanth|Sofware Engineer|Chennai|
0000215|Arun|ASE|Keral|
The field is static and the column name is ID,name,Designation,City.
I need to read the note pad charecter by charecter and i have to insert the records corresponding in the field which is seperated by "|".
I need a way of doing the following:
I receive data in .csv format. I have a some records on a table, so what I need to do is to check if the data I receive exist on the table of records that I need to match against.
If the record exist, then an email/sms should be sent to notify me that the records has been matched and then that record should be flaged that it has been tested so that I don't test it again as the incoming data are saved.
I am using sql to create a table from stored procedures and then streamwriter in vb.net to create a text file based on the sql table. Where and how do I control the right or left justification of the records in the text file?
View 1 Replieshow to get sql query output in text file?
View 1 RepliesI would like to do an attachment on my database but I lost the full-text catalogs file. Sql server won't let me attach the database without it. What do I need to do to overcome this issue? Is there a way to tell Sql Server to skip the missing catalogs? If not, how do I generate another full-text catalogs file to replace to lost one?
View 3 RepliesI need to insert and edit a textfile content in C#. How to find the line number of the text file.
View 5 RepliesI am trying to Export data from SQL server table to a text file using OpenRowSet.
View 3 RepliesI am trying to pass in as an insert parameter for SQLds2 the scope_identity of the insert of SQLds1.
Exception Details: System.InvalidOperationException: Error executing 'InsertCommand' in SqlDataSource 'SqlDataSource1'. Ensure the command accepts the following parameters: @Name1, @NewId
[Code]....