TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
jaya krishnan
NA
1
0
SqlCommandBuilder
Sep 8 2009 6:43 AM
i am using pubs Database and Two Tables
1. A (Table name)
it contains two field
1 id int,
2 name varchar(10)
2. B (Table Name) - is is empty table
it contains two field
1 name varchar(10),
This is My problem using SqlCommandBuilder
string a = "server=.;database=pubs;uid=sa;pwd=jk;";
string b ="select name from A where id=1;
SqlConnection con = new SqlConnection(a);
SqlDataAdapter da = new SqlDataAdapter(b, con);
Dataset ds = new DataSet();
da.Fill(ds,"Temp"); ------------------Dataset 1
string c ="select * from B;
SqlConnection con1 = new SqlConnection(a);
SqlDataAdapter da1 = new SqlDataAdapter(c, con);
Dataset ds1 = new DataSet();
da1.Fill(ds1,"Vemp"); ------------------------- Dataset 2
SqlCommandBuilder buil = new SqlCommandBuilder(da1);
da1.Update(ds,"Temp");
is is possible to insert A table to B using Command Builder
Reply
Answers (
2
)
how to display content of textbox into another textbox in different form
why comparison operator overloading is done in pair