Click here to Skip to main content
15,912,400 members
Home / Discussions / C#
   

C#

 
GeneralRe: Dictionary.ContainsKey Pin
NanaAM26-Nov-07 0:48
NanaAM26-Nov-07 0:48 
AnswerRe: Dictionary.ContainsKey Pin
Pete O'Hanlon26-Nov-07 0:37
mvePete O'Hanlon26-Nov-07 0:37 
AnswerRe: Dictionary.ContainsKey Pin
PIEBALDconsult26-Nov-07 9:13
mvePIEBALDconsult26-Nov-07 9:13 
Questionunknown sign Pin
ghanavat25-Nov-07 23:26
ghanavat25-Nov-07 23:26 
AnswerRe: unknown sign Pin
N a v a n e e t h25-Nov-07 23:30
N a v a n e e t h25-Nov-07 23:30 
Questionform cast Pin
md_refay25-Nov-07 22:56
md_refay25-Nov-07 22:56 
AnswerRe: form cast Pin
NanaAM26-Nov-07 0:18
NanaAM26-Nov-07 0:18 
QuestionDifferent type of class Instantiation - C# 3.5 Pin
N a v a n e e t h25-Nov-07 22:46
N a v a n e e t h25-Nov-07 22:46 
AnswerRe: Different type of class Instantiation - C# 3.5 Pin
darkelv25-Nov-07 23:03
darkelv25-Nov-07 23:03 
GeneralRe: Different type of class Instantiation - C# 3.5 Pin
N a v a n e e t h25-Nov-07 23:15
N a v a n e e t h25-Nov-07 23:15 
GeneralRe: Different type of class Instantiation - C# 3.5 Pin
N a v a n e e t h25-Nov-07 23:50
N a v a n e e t h25-Nov-07 23:50 
Questionhow to show image in ListView ColumnHeader Pin
VenkataRamana.Gali25-Nov-07 22:30
VenkataRamana.Gali25-Nov-07 22:30 
AnswerRe: how to show image in ListView ColumnHeader Pin
TJoe26-Nov-07 2:07
TJoe26-Nov-07 2:07 
Questionenable the menus Pin
keyto25-Nov-07 22:27
keyto25-Nov-07 22:27 
AnswerRe: enable the menus Pin
Pete O'Hanlon25-Nov-07 23:48
mvePete O'Hanlon25-Nov-07 23:48 
Questionhow to ZIP and UNZIP in C# Pin
E_Gold25-Nov-07 22:19
E_Gold25-Nov-07 22:19 
AnswerRe: how to ZIP and UNZIP in C# Pin
VenkataRamana.Gali25-Nov-07 22:37
VenkataRamana.Gali25-Nov-07 22:37 
AnswerRe: how to ZIP and UNZIP in C# Pin
Martin#25-Nov-07 22:55
Martin#25-Nov-07 22:55 
AnswerRe: how to ZIP and UNZIP in C# Pin
Sandeep Kumar25-Nov-07 23:38
Sandeep Kumar25-Nov-07 23:38 
QuestionUpdating multiple base data Pin
Nitin.raj25-Nov-07 22:13
Nitin.raj25-Nov-07 22:13 
hi,

I have fetched two database tables "MTQABenchMarks" and "Users" in the datagridview. This is a windows application. Now I have to update the "MTQABenchMark" database after making changes to the datatable present in the application. When I run the code it is throwing an exception "Dynamic SQL generation is not supported against multiple base tables." How to solve this. the code is

public Form1()
{
InitializeComponent();
}
static SqlConnection Con = new SqlConnection("Data Source= 192.168.100.234; Initial Catalog=gishyd; User ID=sa; password=gis*2005");

SqlDataAdapter Da = new SqlDataAdapter("SELECT dbo.Users.UserID, dbo.MTQABenchMark.Id as EmpID, dbo.Users.FirstName + ' ' + dbo.Users.LastName AS Name, dbo.MTQABenchMark.NoofMinPerDay,dbo.MTQABenchMark.PerMonth FROM dbo.Users INNER JOIN dbo.MTQABenchMark ON dbo.Users.UserID = dbo.MTQABenchMark.EID ", Con);
DataSet Ds = new DataSet();

private void Form1_Load(object sender, EventArgs e)
{
Da.Fill(Ds, "MTQABenchMark");
dataGridView1.DataSource = Ds.Tables["MTQABenchMark"];
}

private void button2_Click(object sender, EventArgs e)
{
SqlCommandBuilder CmdBld = new SqlCommandBuilder(Da);

Da.InsertCommand = CmdBld.GetInsertCommand();
Da.Update(Ds, "MTQABenchMark");

MessageBox.Show(" Database is Updated");
}

}
}

Please Help.


Nitin Raj Bidkikar


Nitin Raj Bidkikar

AnswerRe: Updating multiple base data Pin
Aftab Sindhi26-Nov-07 5:07
Aftab Sindhi26-Nov-07 5:07 
QuestionWindows service Pin
dan!sh 25-Nov-07 22:03
professional dan!sh 25-Nov-07 22:03 
AnswerRe: Windows service Pin
schoetbi26-Nov-07 10:35
schoetbi26-Nov-07 10:35 
Questionhow i can connect useres to the databas [modified] Pin
yemen_programmer25-Nov-07 21:41
yemen_programmer25-Nov-07 21:41 
AnswerRe: how i can connect useres to the databas Pin
Pete O'Hanlon25-Nov-07 21:49
mvePete O'Hanlon25-Nov-07 21:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.