c# - Use OleDbDataAdapter to insert into an Access db -

-

मैं कुछ डाटा को एक्सेस डाटाबेस में डालना चाहूंगा। 

  DataTable dt = new विवरण सारणी(); स्ट्रिंग sql = string.Format ("SELECT * FROM {0} जहां 1 = 0;", tmap.SqlTableName); स्ट्रिंग con = string.Format (conn, accesspath); OleDbDataAdapter da = नया OleDbDataAdapter (sql, con); OleDbCommandBuilder cmdBuilder = नया OleDbCommandBuilder (da); Da.InsertCommand = cmdbuilder.GetInsertCommand (सच); // रिटर्न "INSERT परीक्षा (int, bdate, amt, text, bit) VALUES (?,?,?,?,?)" Da.Fill (dt); // DateTable के लिए डेटा जोड़ें (int i = 0; i & lt; rowCount; i ++) {DataRow dr = dt.NewRow (); // .... dt.Rows.Add (dr); } Da.Update (dt); // यह वह जगह है जहां चीजें दक्षिण चलती है

System.Data.OleDb.OleDbException
संदेश: निषेध बयान में सिंटैक्स त्रुटि। स्रोत: माइक्रोसॉफ्ट जेट डाटाबेस इंजिन।

अगर मैं बदल जाता हूं Insert command: 

  da.InsertCommand = new OleDbCommand ("INSERT परीक्षण ([पाठ]) मूल्यों (?)");

और इनकमिंग डेटा को केवल एक टेक्स्ट वैल्यू में बदलने के लिए जो मुझे मिलता है:

एक या अधिक आवश्यक पैरामीटरों के लिए कोई मान नहीं दिया गया है।

क्या मैं कुछ भूल रहा हूं?

समस्या डेटा प्रकारों में थी प्रश्न का कोड काम करता है यदि डेटा प्रकार संगत हैं।


Comments

Post a Comment

Popular posts from this blog

Is there an open source WebSockets (JavaScript) XMPP library? -

-
Has anyone written the open source XMPP library that uses the websacet and is being run by a browser? We do not yet have a standard XMPP that can enforce the server, Must be adequately faced before it may be necessary The first step is to eliminate WebSAT standardization. It seems that it can be in an IETF Haib working group, which has not been approved by the IESG so far in the writing time (see) a few weeks ago (Hiroshima), a hybrid bird-of-a-feather in IETF ( BOF), which went very well. WebSketches have a constant reference, and it seems to be systematically organized, one will make XMPP binding for webmasters, possibly with a bar for every webset frame. Edit: Jack Moffitt has written an IETF can be used with the first pass on a protocol. Warning . It is still likely to change fast enough, only apply it if you are ready to wrap it completely later. Warning
Read more

java - Is there an object like a "Set" that can contain only unique string values, but also contain a count on the number of occurrences of the string value? -

-
There is an object like "set" in Java that can contain only unique string values, but it also includes a count Is the number of string value in number? This idea is simple. A data set, ALA ... ABBCCC I will set the text of each line set- I want to add to the object every time a non-unique text is added to the set, I also want to show a numeric value associated with the set to show how often it was added. So if I run it on the above data then set output will be something like this: A: 1B: 2C: 3 Any ideas? Maps & lt; String, integer & gt; add public null (strings) {if (map.containsKey (s)) {map.put (s, map.get (s) + 1); } And {map.put (S, 1); }}
Read more

mysql - Can mysql_pconnect be called multiple times in one php page? -

-
I was wondering if it is valid for calling mysql_pconnect several times in a php page? Also, if possible, should I either close my last ISSL handle or something? Actually the following code is okay? Or is there a lack of some other steps? mysql_pconnect ("ip: 3306", "user", "pass") or die (mysql_error ()); Mysql_select_db ("test") or die (mysql_error ()); // Some SQL queries mysql_pconnect ("ip2: 3306", "user", "pass") or die (mysql_error ()); Mysql_select_db ("test") or die (mysql_error ()); // Another SQL query Yes but this is probably a better practice, both the headset To store both in the database and make the correct DB explicit use. dbServer1 = mysql_pconnect ("ip: 3306", "user", "pass") or die (mysql_error ()); Mysql_select_db ("test", dbServer1) or die (mysql_error ()); DbServer2 = mysql_pconnect ("ip: 3306", "user", "...
Read more