我想在空数据库中添加一些数据, 这是我的代码之一
private void readSQLCE()
{
db = new MyDataContext("isostore:/qq.sdf");
cust newcust = new cust
{
C_Id = 1,
C_Name = "Amop",
C_Place = "Poik"
};
db.CS.InsertOnSubmit(newcust);
}
要将我的数据插入 SQL 服务器 CE 数据库,还需要增加什么?
你需要一个
db.SubmitChanges();
SQL Server question. When doing INSERT INTO T1 SELECT (C1, C2) FROM T2 I don t want to specify column names of T1 because they are the same as in T2 Is it possible to do so? Currently I m getting ...
I need to duplicate a row a couple thousand times. I need to change one column from the copied row based on a list of ids. Psuedo-code: INSERT INTO MyTable (TabID, Other Columns) VALUES (TabID = (...
I ve been battling this for a while. I m trying to implement a many to one association. I have a bunch of rows in a table, called readings. These accumulate over time, and every now and then I want to ...
After I copy mdf file (and his log file) I tries to Insert data. I receive the following message: "An attempt to attach an auto-named database for file [fileName].mdf failed. A database with the same ...
I have this table: CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), PRIMARY KEY (P_Id) ) 1. insert into ...
I have a temp table (question_desc, ans1, ans2, ans3, ans4, correct_ans, marks) with say 10 entries. From this table I have to insert values in two other tables: questions (q_id(auto-generated), ...
I am trying to work out the best way to stop double booking in my application. I have a table of unique id s each can be sold only once. My current idea is to use a transaction to check if the ...
I have created a database where I use uniqueidentifier as the primary key. I m trying to run a parametrized query that in the end looks like this. (insert into someTable (uniqueID) Values( 76c14693-...