|
I'm a beginner. I want to insert, update a record into a MS Access database. I tryed to do it using using OleDb Managed Provider, but don't seccess. If you have a sample project is written Visual C#.NET 2005, pleased share with me.
Thank you!
|
|
|
|
|
This is oledb and its works for me:
<br />
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseURL);<br />
Reading:
OleDbDataAdapter resAdapter = new OleDbDataAdapter("SELECT * FROM <table>", con);<br />
OleDbCommandBuilder resCmdBuilder = new OleDbCommandBuilder(resAdapter);<br />
DataSet myDataSet = new DataSet();<br />
resAdapter.Fill(myDataSet, <any name ,need not correspond with <table>);
Inserting
con.Open();<br />
OleDbCommand cmd = con.CreateCommand();<br />
cmd.CommandText = "INSERT INTO <Table> (colname1,colname2....) VALUES(coresponding values)<br />
cmd.ExecuteNonQuery();<br />
con.Close();
Deleting and updating is the same thing , use an UPDATE or DELETE query in CommandText;
CommandText = "UPDATE table_name SET column_name = new_value WHERE column_name = some_value"<br />
CommandText = "DELETE FROM table_name WHERE column_name = some_value";
This should help you with the SQL statements:
http://www.w3schools.com/sql/default.asp[^]
Gideon
|
|
|
|
|
hi every one,
well I'm havig a strange bug here.. I made a form in C# 2.0 Windows application. Its a simple form based on one table named
Manufacturer (manID PK, ManName, logo, Discription)
I made it by binding the data with the binding source and apprantly its working fine but when I try to save changes by clicking on save Button on the binding Navigator it gives an error as
System.Data.SqlCLient.Sqlexception: length of text, ntext or image data (129712) to be replicated exceeds configured maximum 65536
thanks in advance
Rocky
|
|
|
|
|
Are you using replication?
If yes, check this[^].
|
|
|
|
|
yes i'm using replication. I think u might have solved my problem...
|
|
|
|
|
yes it worked, thanks alot man, ur brilliant
|
|
|
|
|
I googled it. I have never encountered such problem before. But thanks, anyway. 
|
|
|
|
|
Please i need this answer asap..
if i want to do a function that accepts INTEGERS number... then i wanna the sum of these integers.. for example
if i entered 123.. the answer should be 6.
Thanks in advance
Regards
Estarta
|
|
|
|
|
Sounds like homework. Why don't you make an attempt and then we'll help you with that?
|
|
|
|
|
Thanks for ur reply, And its not a homework, and i tried so many time i couldn't do it  ~
i just wanted to know
thanks
Estarta
|
|
|
|
|
Almost certainly no one here will write the whole thing for you. Show us what you got so far, say concretely where you got stuck and we'll help you.
By the way, the specification of your function is quite lousy. It is not really clear what the input is; integers, an array of integers or maybe a string with integers? From your example it seams to be the latter. If so, do you want to sum up the digits or how should the function know where to break up the string into integers?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Well its only INTEGERS not array any intergers.
and yesterday i had this work interview and they asked me this question and it bothers me 
Estarta
|
|
|
|
|
i've tried, but i can't get it done! there is must be an array but how can i know how many digits are there without convert the input to string!
Estarta
|
|
|
|
|
Estarta wrote: and yesterday i had this work interview and they asked me this question and it bothers me
I'd say that the job isn't the right one for you. This question is a variation (at least on the same level) as FizzBuzz
For more information listen to this podcast[^] or read the transcript[^]
Anyone with a software development job should be able to do that in a couple of minutes
|
|
|
|
|
Well thanks 
Estarta
|
|
|
|
|
btw wat makes u think that this JOB is not right.. u don't even know me 
Estarta
|
|
|
|
|
Estarta wrote: btw wat makes u think that this JOB is not right.. u don't even know me
He knows that you're not able to programmatically solve this quite simple problem on your own. Since the interview question implies the job has something to do with programming, your obviously not the right/best choice for the job and the other way round.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Anyone who passed CS101 should be able to do this in 5 minutes with one hand tied behind their back. If you can't, you should give up your software aspirations and take up a new career as a burger flipper.
--
CleaKO The sad part about this instance is that none of the users ever said anything [about the problem].
Pete O`Hanlon Doesn't that just tell you everything you need to know about users?
|
|
|
|
|
We may not know you, but we've certainly cleaned up enough messes left by people just like you. The question was basic stuff - it shouldn't have bothered you. Even if you didn't know the ins and outs of the language, you should have been able to come up with the algorithm for it without needing to think about it.
You should also have been able to explain the problem properly, without using txtspk.
Overall, I'll take one Colin over 100 of you any day.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Well thanks again for the reply. but you know you don't have to say such things if you can erase my account so do it!! but don't act like the YOU ARE THE BEST or i dont know wats the matter with u!!! i asked a question AND I DON'T KNOW THE ANSWER nth to be shamed of!!! and btw i`m a software engineer we didn't took PROGRAMMING LANGUAGES as u did !! we only took the software engineering syuff and rational rose!!
You dont even deserve my reply!!!
Good bye MR
Estarta
|
|
|
|
|
By definition, a software engineer has to be able to break algorithms down. You couldn't. You're right, there's nothing to be ashamed of when you don't know the answer to a problem - unless that problem is basic. I would be interested to know how you think you are a software engineer if you didn't do any programming languages.
Colin pointed out to you that you may not be pursuing the right career. I pointed out to you why I thought he'd done so because you couldn't seem to grasp this. Your answer has compounded the issue. As a professional developer, I have spent a large amount of time mentoring and helping newbie developers but I would advise anybody who couldn't get a grasp on such a basic problem to steer clear of a career in developing. More importantly, as I stated earlier, I have spent a large amount of time clearing up after people who shouldn't have been developers in the first place. If you want to prove me wrong, brush up on your algorithms, learn the basics and then move onto more advanced things.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I Know the basics.. !!
int x= int.Parse(Input.Text);
int t =0;
string i = x.ToString();
for(int y=0;y<i.length;y++)
{
="" int="" sub="int.Parse(i.Substring(y,1));
" t="t+sub;
" }
="" output.text="t.ToString();
"
this="" is="" wat="" i="" did!!and="" its="" working,="" but="" im="" asking="" there="" anyway="" can="" do="" it="" without="" parse="" the="" to="" string?!="" so="" get="" length="" and="" substring="" functions.=""
<div="" class="ForumSig">Estarta
|
|
|
|
|
that's quite a different question from the one you asked at the start 
Can i suggest not using the letter i to denote a string, even if it does contain the string representation of an integer.
You should use Parse or TryParse on the input to make sure that the number can be represented as a number.
Russell
|
|
|
|
|
Estarta wrote: This is wat i did!!and its working, but wat im asking is there is anyway i can do it without Parse the int to String?
So why didn't you show us the code and asked exactly that question in the first place? Why did you told us "i've tried, but i can't get it done!"?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
bcuz i've tried and maybe my question wasn't so clear.. i was trying to tell u guys i want the answer without parsing the input into integers..
anyway i got the answer thanks for ur time
Estarta
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
