|
It may be urgent to you, but not to everyone else here. Don't be rude.
only two letters away from being an asset
|
|
|
|
|
Indeed, "urgent" and "high importance" generally refer only to the sender, not to the receiver.
|
|
|
|
|
The title of your post makes it sound like you're stuck on a ledge, 12 floors up and the buildings on fire. I rather suspect that your problem isn't as urgent as that.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hi all,
I'm new in c# and sort of confused in offline data handling. I fill my dataset with sql commanmd which is a joined selection (e.g select a.name,b.age,c.deprt_name from table1 a,table2 b,table3 c where ................) and that is how I fill dataset and assign the datasource of datagridview. When I delete,insert and update I only use table2.
How can I manage dataadapter,commandbuilder etc. and let dataadapter automatically do all these database operations.
Thanks in advance
snky
|
|
|
|
|
sureyyan wrote: and let dataadapter automatically do all these database
Theres you first mistake, don't rely on the data adapter to do anything automatically, you are the programmer, understand what your program is doing, take control of your data and its manipulation. The biggest problem I can see here is new programmers relying on the MS wizards to do the work they should be doing with a data access layer (DAL). Do some research into DAL, stored procedures and parameterised queries, you will be a better developer for it!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Keep your advises and assumptions to yourself.
Use your time for something constructive and behave yourself.
|
|
|
|
|
That's a bit of an arsey attitude you've got going on there - a newbie and obnoxious; that's an attractive package you've got going there bubba. You were given good advice, but you wilfully chose to ignore it and attack the person giving it - perhaps you need to step back for a moment, and think about the advice you've been given and consider that those of us who do this professionally might actually have a lot more of a clue than you.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
sureyyan wrote: Keep your advises and assumptions to yourself
Not a problem, YOU sort it out, I did many years ago.
You see had you come back with something along the lines of "What do you suggest" there would have been no end of links to articles to help you learn a more robust way of dealing with data.
As to my assumptions they are based on the quality of the question which indicates a newbie with no depth of knowledge beyond the first brush with the MS wizards. The advice I gave you was valid, you need to get past the built in wizard stuff and gain a deeper understanding of the data.
Now you have proven yourself to be both a newbie and rude, note the votes and the amount of support you received.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
"Never underestimate the power of human stupidity"
"Never underestimate the power of arrogance without a class"
|
|
|
|
|
Hear hear!
The DataAdapter and DataGrid(View) were developed simply to demonstrate how easy data access with ADO.net can be.
They should never be used in a production application.
CommandBuilder, upon which DataAdapter relies, is very limited in its abilities; it can't generate commands to update multiple joined tables.
|
|
|
|
|
Well, this is really interesting.
can you please advice which control to use instead of DataGrid/View in production envoirnment?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
Something designed specifically for the data in question.
|
|
|
|
|
well, If i wanna show collection of data to the user the same as tables, do I need use DataGird/View or there is some other control for that?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
Thank you for your kind reply,
I'have been doing application with so many years, I just wanted to understand why and how one should use commandbuilder under a given circumstances, as a new user of c#. I saw similar issues with joined tables and multiple table updates, which I offcourse did database operations on sql handle basis. My question was actually, to see different views if in complicated applications is there any use for such tools. I'have been using gupta for so many years, there things are much structural and robust.
Thanks for your info
|
|
|
|
|
sureyyan wrote: how one should use commandbuilder
Don't; it's too limited. There's no substitute for hand-rolled data access code.
|
|
|
|
|
I agree with your command builder comment.can you please give a small example of how you populate a table, if not with dataadapter.
|
|
|
|
|
Hello friends,
I am trying to annotate some functions on screen and open documents (like internet explorer, word, or any pdf that is opened on the desktop)using some paint applications like pen, brush and highlighter. In simple words I want to paint directly on the desktop using some draw tools like pencil, brush etc. I saw some programs in code projects and got some idea but I am unable to move further. Also I saw a program that actually does this called screen painter. Unfortunately it is in c++. So can any body help me in doing this in c#.
Thanking you in advance,
Kind regards,
Vijay (vijay_varma86@yahoo.com)
|
|
|
|
|
bumping is rude
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Do not repeat your post because you do not have a reply. All you will do is annoy poeple. It is a Sunday, so Europe, the US and Australia are not at work, generally. You may get a better reponse tomorrow.
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
|
For Win Forms you could use MaskedTextBox.Similar control is available for ASP.NET with Ajax toolkit too.
Life is a stage and we are all actors!
|
|
|
|
|
Yes i use it by windows forms. but how can i make it like the picture?
not with a code with the settings
|
|
|
|
|
Did you ask google how?
Life is a stage and we are all actors!
|
|
|
|
|
Hello friends,
I am trying to annotate some functions on screen and open documents (like internet explorer, word, or any pdf that is opened on the desktop)using some paint applications like pen, brush and highlighter. In simple words I want to paint diretly on the desktop using some draw tools like pencil, brush etc. I saw some programs in code projects and got some idea but I am unable to move further. Also I saw a program that actually does this called screen painter. Unfortunately it is in c++. So can any body help me in doing this in c#.
Thanking you in advance,
Kind regards,
Vijay (vijay_varma86@yahoo.com)
|
|
|
|
|
{<br />
private static int count;<br />
public StaticDataMembersAndMethods()<br />
{<br />
InitializeComponent();<br />
count++;<br />
<br />
}<br />
public void showcount()<br />
{<br />
MessageBox.Show("Value of count is :" + count);<br />
}<br />
<br />
<br />
private void button1_Click(object sender, EventArgs e)<br />
{<br />
StaticDataMembersAndMethods objstatic = new StaticDataMembersAndMethods();<br />
objstatic.showcount();<br />
<br />
<br />
}<br />
how to get additions starting from zero? now it starts with number two.
|
|
|
|