I have problem with OracleCommandBuilder !!!! Help me
-
This is my code: this.oracleConnection1.ConnectionString = "user id=HMS;data source=HMS2005;password=HMS"; da = new System.Data.OracleClient.OracleDataAdapter(); cmd = new System.Data.OracleClient.OracleCommand("select A1,A2 from TEST",oracleConnection1); da.SelectCommand = cmd; cb = new System.Data.OracleClient.OracleCommandBuilder(da); daset =new DataSet(); da.Fill(daset); daset.Tables[0].Rows[0][0]= "123"; da.Update(daset); So When My program was run . it throw one error and error message is "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." Help me!!!!!!!!!!:doh:
-
This is my code: this.oracleConnection1.ConnectionString = "user id=HMS;data source=HMS2005;password=HMS"; da = new System.Data.OracleClient.OracleDataAdapter(); cmd = new System.Data.OracleClient.OracleCommand("select A1,A2 from TEST",oracleConnection1); da.SelectCommand = cmd; cb = new System.Data.OracleClient.OracleCommandBuilder(da); daset =new DataSet(); da.Fill(daset); daset.Tables[0].Rows[0][0]= "123"; da.Update(daset); So When My program was run . it throw one error and error message is "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." Help me!!!!!!!!!!:doh:
WHAT, I ask you WHAT makes you think this is not a programming question?? :confused: try programming forums[^]... David Never forget: "Stay kul and happy" (I.A.)
David's thoughts / dnhsoftware.org / MyHTMLTidy -
This is my code: this.oracleConnection1.ConnectionString = "user id=HMS;data source=HMS2005;password=HMS"; da = new System.Data.OracleClient.OracleDataAdapter(); cmd = new System.Data.OracleClient.OracleCommand("select A1,A2 from TEST",oracleConnection1); da.SelectCommand = cmd; cb = new System.Data.OracleClient.OracleCommandBuilder(da); daset =new DataSet(); da.Fill(daset); daset.Tables[0].Rows[0][0]= "123"; da.Update(daset); So When My program was run . it throw one error and error message is "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." Help me!!!!!!!!!!:doh:
Firstly. When you posted this message there will have been a big red notice that said: Please do NOT post programming questions or ads to this forum. For programming help please try the Forums. Secondly. The error message given, "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." actually gives you the answer. [SARCASTIC]So it would seem that forum ettiquete notes are not all you have trouble reading.[/SARCASTIC] (Hmmmm.... I'm obviously having a worse morning that I thought.)
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
Firstly. When you posted this message there will have been a big red notice that said: Please do NOT post programming questions or ads to this forum. For programming help please try the Forums. Secondly. The error message given, "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." actually gives you the answer. [SARCASTIC]So it would seem that forum ettiquete notes are not all you have trouble reading.[/SARCASTIC] (Hmmmm.... I'm obviously having a worse morning that I thought.)
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
Advantage readers :)
Pandoras Gift #44: Hope. The one that keeps you on suffering.
aber.. "Wie gesagt, der Scheiss is' Therapie"
boost your code || Fold With Us! || sighist | doxygen -
This is my code: this.oracleConnection1.ConnectionString = "user id=HMS;data source=HMS2005;password=HMS"; da = new System.Data.OracleClient.OracleDataAdapter(); cmd = new System.Data.OracleClient.OracleCommand("select A1,A2 from TEST",oracleConnection1); da.SelectCommand = cmd; cb = new System.Data.OracleClient.OracleCommandBuilder(da); daset =new DataSet(); da.Fill(daset); daset.Tables[0].Rows[0][0]= "123"; da.Update(daset); So When My program was run . it throw one error and error message is "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." Help me!!!!!!!!!!:doh:
SEAGames22 wrote: This is my code: this.oracleConnection1.ConnectionString = "user id=HMS;data source=HMS2005;password=HMS"; da = new System.Data.OracleClient.OracleDataAdapter(); cmd = new System.Data.OracleClient.OracleCommand("select A1,A2 from TEST",oracleConnection1); da.SelectCommand = cmd; cb = new System.Data.OracleClient.OracleCommandBuilder(da); daset =new DataSet(); da.Fill(daset); daset.Tables[0].Rows[0][0]= "123"; da.Update(daset); and this is my code:
namespace _315C05 { /// /// Summary description for Redirect. /// public class Redirect : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if(PostingForum==Lounge) { Response.Redirect("[http://www.codeproject.com/script/comments/forums.asp](http://www.codeproject.com/script/comments/forums.asp)[[^](http://www.codeproject.com/script/comments/forums.asp "New Window")]"); } }Hope that helps. Jerry Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons Toasty0.com Ladder League (beta) -
SEAGames22 wrote: This is my code: this.oracleConnection1.ConnectionString = "user id=HMS;data source=HMS2005;password=HMS"; da = new System.Data.OracleClient.OracleDataAdapter(); cmd = new System.Data.OracleClient.OracleCommand("select A1,A2 from TEST",oracleConnection1); da.SelectCommand = cmd; cb = new System.Data.OracleClient.OracleCommandBuilder(da); daset =new DataSet(); da.Fill(daset); daset.Tables[0].Rows[0][0]= "123"; da.Update(daset); and this is my code:
namespace _315C05 { /// /// Summary description for Redirect. /// public class Redirect : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if(PostingForum==Lounge) { Response.Redirect("[http://www.codeproject.com/script/comments/forums.asp](http://www.codeproject.com/script/comments/forums.asp)[[^](http://www.codeproject.com/script/comments/forums.asp "New Window")]"); } }Hope that helps. Jerry Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons Toasty0.com Ladder League (beta):laugh: "If it's Snowbird season, why can't we shoot them?" - Overheard in a bar in Bullhead City
-
SEAGames22 wrote: This is my code: this.oracleConnection1.ConnectionString = "user id=HMS;data source=HMS2005;password=HMS"; da = new System.Data.OracleClient.OracleDataAdapter(); cmd = new System.Data.OracleClient.OracleCommand("select A1,A2 from TEST",oracleConnection1); da.SelectCommand = cmd; cb = new System.Data.OracleClient.OracleCommandBuilder(da); daset =new DataSet(); da.Fill(daset); daset.Tables[0].Rows[0][0]= "123"; da.Update(daset); and this is my code:
namespace _315C05 { /// /// Summary description for Redirect. /// public class Redirect : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if(PostingForum==Lounge) { Response.Redirect("[http://www.codeproject.com/script/comments/forums.asp](http://www.codeproject.com/script/comments/forums.asp)[[^](http://www.codeproject.com/script/comments/forums.asp "New Window")]"); } }Hope that helps. Jerry Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons Toasty0.com Ladder League (beta)Toasty0 wrote: if(PostingForum==Lounge) Got My 5 :laugh:;P It is Illogical to define an inventor by his invention