16,012,025 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Gerhard_Louis (Top 23 by date)
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
Show More