Comments by Gerhard_Louis

Gerhard_Louis 6-Jun-15 15:46pm View

from which site did you copy and paste the code

Gerhard_Louis 23-May-15 14:57pm View

Sorry my mistake.I was going to be defensive about your comment but i got to explain what happened.For some strange reason my question kept being added to the discussion section

Gerhard_Louis 17-May-15 1:01am View

edit this.da.Update(ds, "tarih");

Gerhard_Louis 17-May-15 0:56am View

Your update should be something like this

OleDbCommand guncelle = new OleDbCommand("UPDATE tarih SET 1sorupuan1 = @3, 1sorupuan2 =@4 , 1sorupuan3 =@5, 1sorupuan4 = @6, 1sorupuan5 = @7, 1sorupuan6 = @8, 1sorupuan7 = @9, 1sorupuan8 = @10, 1sorupuan9 = @11, 1sorupuan10 = @12, 1sorupuan11 = @13, 1sorupuan12 = @14, toplampuan1 = @15 where ogrno = '" + ogr + "'", baglan);
guncelle.Parameters.AddWithValue("@3", a1);
guncelle.Parameters.AddWithValue("@4", a2);
guncelle.Parameters.AddWithValue("@5", a3);
guncelle.Parameters.AddWithValue("@6", a4);
guncelle.Parameters.AddWithValue("@7", a5);
guncelle.Parameters.AddWithValue("@8", a6);
guncelle.Parameters.AddWithValue("@9", a7);
guncelle.Parameters.AddWithValue("@10", a8);
guncelle.Parameters.AddWithValue("@11", a9);
guncelle.Parameters.AddWithValue("@12", a10);
guncelle.Parameters.AddWithValue("@13", a11);
guncelle.Parameters.AddWithValue("@14", a12);
guncelle.Parameters.AddWithValue("@15", atoplam);

this.da.UpdateCommand = guncelle;
this.da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
this.da.Update(ds, ""tarih");
this.ds.AcceptChanges();
baglan.close();

Gerhard_Louis 16-May-15 3:42am View

[toplampuan1], [derece1] are joint tables?

Gerhard_Louis 16-May-15 3:05am View

When using OledbDataAdapter it opens the connection to the database when you pass the connection string :,baglan so baglan.Open() is not needed.

Why do you clear the Tables?
Create a new DataTable eg: DataTable dt;

in your private void verilerigoster_butun_ogrenciler()
dt = ds.Tables["tarih"]
this.da.Fill(ds,"tarih");
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "tarih";

I just think you have to re look the way you want interact databases through Oledb

Gerhard_Louis 19-Apr-15 10:30am View

Hi OriginalGriff.I did try without setting the values but once I close Visual Studio and reopen the test project I am unable to update the datagridview.It gives the same error

Gerhard_Louis 21-Mar-15 9:37am View

Its just for one client.Unfortunately we are stuck with using a paradox database until we move over to Sql

Gerhard_Louis 21-Mar-15 9:09am View

Hi thank you.It works.I added a manual timestamp in the paradox database and noted the unique id it generated and then I made sure there was no record with that unique id in my access table and updated it.And re updated it again and I was not getting the same primary key violation.Although updating 700 employees records takes forever

Gerhard_Louis 6-Mar-15 11:05am View

Hi Richard.I used Chill60's suggestion and I can now extract just the fields I need.Thanks for replying in any case

Gerhard_Louis 6-Mar-15 11:01am View

Thank you.Works perfectly.Really appreciate it

Gerhard_Louis 28-Feb-15 23:35pm View

Thanks George.Your solution works perfectly

Gerhard_Louis 18-Jan-15 8:31am View

I downloaded FileHelpers and it took 15 lines of code to do what it previously took more than a hundred lines.Thanks again

Gerhard_Louis 17-Jan-15 12:28pm View

lol I also gave you a +5 for not loosing it completely

Gerhard_Louis 17-Jan-15 10:52am View

Much appreciated.I had a look at both your and George's suggestions.Both works nicely.I should have posted earlier for a solution but I always prefer to see if I can solve problems before asking

Gerhard_Louis 17-Jan-15 10:23am View

You are right.Moving from Delphi to C# and WPF is one giant leap and its difficult to get out a set mindset.I will have a look.Thank you

Gerhard_Louis 17-Jan-15 10:20am View

Thanks Kenneth

Gerhard_Louis 3-Jan-15 8:46am View

I relooked at the way I was accessing the data and posted new code for the bntDelete eventhandler and it is working.Thanks again

Gerhard_Louis 3-Jan-15 5:47am View

Thanks.The holidays were tough on the gray matter.When I saw your answer I realised what I was trying to do which will never work

Gerhard_Louis 30-Sep-14 12:31pm View

Deleted

Hi Rahul.Does the datetime picker not show up or can you try this and let me know if it works?
<div class="input-control text" data-role="datepicker" data-week-start="1">
<input type="text">
<button class="btn-date"></button>
</div>
</div>

Gerhard_Louis 28-Sep-14 5:19am View

lol agree with you.the missing 10% are either people don't read the developer guidelines or are too lazy to sit and work through problems

Gerhard_Louis 29-Jul-12 6:27am View

Thanks OriginalGriff.English Is not my first language so sometimes its difficult to explain exactly my problem..I like your answers.Concise and clear to the point

Gerhard_Louis 24-Jun-12 12:26pm View

Thnx OriginalGriff.Much appreciated.I saw a different solution which the poster presumed would work.Got really frustrated as he "presumed" it work without actually trying it himself

Comments by Gerhard_Louis (Top 23 by date)