Click here to Skip to main content
15,917,793 members
Home / Discussions / C#
   

C#

 
GeneralRe: database(server) access with a c# program Pin
Gareth H5-Jan-08 5:19
Gareth H5-Jan-08 5:19 
GeneralTalking to a TomTom 520 Pin
Gareth H5-Jan-08 3:43
Gareth H5-Jan-08 3:43 
GeneralRe: Talking to a TomTom 520 Pin
Jimmanuel5-Jan-08 10:30
Jimmanuel5-Jan-08 10:30 
GeneralRe: Talking to a TomTom 520 Pin
Gareth H5-Jan-08 11:22
Gareth H5-Jan-08 11:22 
Generalcombobox problems Pin
angels7775-Jan-08 3:36
angels7775-Jan-08 3:36 
GeneralRe: combobox problems Pin
angels7776-Jan-08 4:07
angels7776-Jan-08 4:07 
GeneralRe: combobox problems Pin
mav.northwind6-Jan-08 19:18
mav.northwind6-Jan-08 19:18 
Questionhow to get rid of "Update requires a valid InsertCommand when passed DataRow collection with new rows."? [modified] Pin
Dg!Mortal5-Jan-08 3:24
Dg!Mortal5-Jan-08 3:24 
I get the following exception when I try to update my database It says:"Update requires a valid InsertCommand when passed DataRow collection with new rows."
and I dont know how to add the appropriated insert command.
Please help, thanks.
using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
using System.Data.OleDb;<br />
using System.Data;<br />
<br />
namespace WindowsFormsApplication1<br />
{<br />
    public partial class Form1 : Form<br />
    {<br />
        public Form1()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void button1_Click(object sender, EventArgs e)<br />
        {<br />
            OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=E:\\hp\\Source\\Val-Asr-LastPart\\db1.mdb");<br />
            con.Open();<br />
            string sqlstr = "SELECT * FROM kham";<br />
            OleDbCommand com=new OleDbCommand(sqlstr,con);<br />
            OleDbDataAdapter da =new OleDbDataAdapter(com);<br />
            DataSet ds = new DataSet();<br />
            da.Fill(ds, "kham");<br />
            DataRowCollection drc = ds.Tables["kham"].Rows;<br />
            textBox1.Text = (string)drc[0][1];<br />
<br />
<br />
            string str1 = (string)drc[0][1];<br />
            string st="";<br />
            string stt="";<br />
            char[] ch1 = str1.ToCharArray();<br />
            int k=0;<br />
            int i=0;<br />
<br />
<br />
            sqlstr="SELECT * FROM parsed";<br />
            com.CommandText=sqlstr;<br />
            da=null;<br />
            da=new OleDbDataAdapter(com);<br />
            ds=null;<br />
            ds=new DataSet();<br />
            da.Fill(ds,"parsed");<br />
            for (; i < ch1.Length; i++)<br />
            {<br />
                if ((ch1[i] == '1' || ch1[i] == '2' || ch1[i] == '3' || ch1[i] == '4' || ch1[i] == '5' || ch1[i] == '6' || ch1[i] == '7' || ch1[i] == '8' || ch1[i] == '9' || ch1[i] == '0') && (ch1[i + 1] == '?'))<br />
                {<br />
                    for(i++;i<ch1.length;i++)><br />
                        if ((ch1[i]!='(')||(ch1[i+1]!='['))<br />
                            st += ch1[i];<br />
                        else<br />
                        {<br />
                            //ds.Tables["parsed"].Rows[k][1]= st;<br />
                            //st = "";<br />
                            for (i += 6; i < ch1.Length; i++)<br />
                                if ((ch1[i] == '1' || ch1[i] == '2' || ch1[i] == '3' || ch1[i] == '4' || ch1[i] == '5' || ch1[i] == '6' || ch1[i] == '7' || ch1[i] == '8' || ch1[i] == '9' || ch1[i] == '0') && (ch1[i + 1] == '?'))<br />
                                {<br />
                                    //ds.Tables["parsed"].Rows[k++][2] = stt;<br />
                                    string[] sst = { ""+(k++), st, stt };<br />
                                    ds.Tables["parsed"].Rows.Add(sst);<br />
                                    stt = "";<br />
                                    i--;<br />
                                    break;<br />
                                }<br />
                                else<br />
                                    stt += ch1[i];<br />
                            break;<br />
                        }<br />
                }<br />
                    <br />
            }<br />
            da.Update(ds,"parsed");//error refers to here<br />
            }<br />
    }<br />
}<br />
</ch1.length;i++)>


modified on Saturday, January 05, 2008 9:31:30 AM

GeneralAbout wireless connections Pin
kralece5-Jan-08 2:54
kralece5-Jan-08 2:54 
Generalcombobox events Pin
azza1045-Jan-08 2:36
azza1045-Jan-08 2:36 
AnswerRe: combobox events Pin
Ravi Bhavnani5-Jan-08 5:15
professionalRavi Bhavnani5-Jan-08 5:15 
GeneralRe: combobox events Pin
azza1045-Jan-08 8:29
azza1045-Jan-08 8:29 
GeneralRe: combobox events Pin
azza1045-Jan-08 9:22
azza1045-Jan-08 9:22 
GeneralBook recommendation for learning c# Pin
Member 8844115-Jan-08 0:41
Member 8844115-Jan-08 0:41 
GeneralRe: Book recommendation for learning c# Pin
originSH5-Jan-08 1:38
originSH5-Jan-08 1:38 
GeneralRe: Book recommendation for learning c# Pin
Pete O'Hanlon5-Jan-08 9:18
mvePete O'Hanlon5-Jan-08 9:18 
GeneralRe: Book recommendation for learning c# Pin
Scott Dorman5-Jan-08 3:05
professionalScott Dorman5-Jan-08 3:05 
GeneralRe: Book recommendation for learning c# Pin
Member 8844116-Jan-08 21:14
Member 8844116-Jan-08 21:14 
GeneralRe: Book recommendation for learning c# Pin
ddspliting5-Jan-08 6:27
ddspliting5-Jan-08 6:27 
GeneralRe: Book recommendation for learning c# Pin
Colin Angus Mackay5-Jan-08 7:28
Colin Angus Mackay5-Jan-08 7:28 
General[Message Deleted] Pin
ramyanaidu4-Jan-08 21:36
ramyanaidu4-Jan-08 21:36 
GeneralRe: Beep sound when error occurs using C# Pin
originSH4-Jan-08 23:16
originSH4-Jan-08 23:16 
AnswerRe: Beep sound when error occurs using C# Pin
Ravi Bhavnani5-Jan-08 5:19
professionalRavi Bhavnani5-Jan-08 5:19 
QuestionHow to Find Client Network cable is unplugged or plugged in [modified] Pin
sindhutiwari4-Jan-08 21:01
sindhutiwari4-Jan-08 21:01 
AnswerRe: How to Find Client Network is unplugged Pin
mav.northwind4-Jan-08 21:14
mav.northwind4-Jan-08 21:14 

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.