Alexander, don't make too fast conclusions, it doesn't support visual
inheritance only for Strip-Elements so far, at least DataGridView you can
inherit for sure
Generally you can inhetit strip elemets, but you can't change them in
inherited form, so for me this equal to feature absence.
And
Trofimich wrote:
Generally you can inhetit strip elemets, but you can't change them in
inherited form, so for me this equal to feature absence.
And you CAN'T CHANGE BindindNavigator and DataGridView too.
So at list:
MonuStrip disabled
PopupMenuStrip disabled
ToolStrip disabled
Have you problems with English? I can write in russian.
It would be nice.
I didn't said, that i see a lot of sense in not being able to edit Strip
Controls in inherited form. But i said so far, that means, that microsoft
is aware of this problem, and it might be solved in next Visual Studio.
Use IDataAdapter's RowUpdated event.
Did you use ADO.NET 2.0? Maby i'm stupid but i can't find even something
similar there...
I want to make form for editing table. I connected to database and
generated DataSet, BindingSource and TableAdapter.
Now i need to make inserting.
Table consists
Trofimich wrote:
Use IDataAdapter's RowUpdated event.
Did you use ADO.NET 2.0? Maby i'm stupid but i can't find even something
similar there...
I want to make form for editing table. I connected to database and
generated DataSet, BindingSource and TableAdapter.
Now i need to make
IMHO It sounds like you are doing something that the table adaptor
might
not be the best fit for. I have never been a big fan of loading a
million records (or anything close to that in a data set) on a client
machine. No matter what solution you use to refresh you data it's
going
to be
Hello:
ORM library is other question. I want to understand microsoft's ideas
about DataSets. As i said, i don't need DataSets on my real work but who
knows what will be over few months. Maby i'll change my job and will
work with datasets.
That will depend a lot on your needs and feels.
Hello:
In ASP.NET i use ObjectDataSources + my ORM lib - very powerfull thing :-)
ObjectDataSource is really great !!!
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-
Take Surveys. Earn Cash.
I have yet two questions:
1) DataModules. In delphi there is some kind of units, similar to forms,
which i can use for placing non visual components such as connections,
transactions, datasets and datasources. So i can place all my datasets
inside this datamodule and use it where i need. It's
sasha wrote:
I have yet two questions:
1) DataModules. In delphi there is some kind of units, similar to forms,
which i can use for placing non visual components such as connections,
transactions, datasets and datasources. So i can place all my datasets
inside this datamodule and use it
For example, binding to the same object created for this is your friend. :)
Not understand you :-/ My english is not good :-(
Cause DS in ADO.NET is complete offline image of data, it's filled always
with all data from select.
But you can create/download layers with work i.e. with
In past i programmed with Delphi, so i don't understand some conceptions
of ADO.NET.
1) For example i posted UPDATE command for record. Some fields of record
was changed in triggers inside databse, so i need refresh record from
database right after update. In delphi i has RefresSQL command for
Hello,
sasha said the following on 08.01.2007 15:26:
1) For example i posted UPDATE command for record. Some fields of record
was changed in triggers inside databse, so i need refresh record from
database right after update. In delphi i has RefresSQL command for this.
How does it work in
sasha wrote:
In past i programmed with Delphi, so i don't understand some conceptions
of ADO.NET.
1) For example i posted UPDATE command for record. Some fields of record
was changed in triggers inside databse, so i need refresh record from
database right after update. In delphi i has
sasha wrote:
You you're using DataSet, just refresh it. Your TableAdapter will do the
work.
Hmm... I dont understand how does it work. Does table adapter
automatically generate SELECT command for refreshing of each updated and
inserted record?
Why it should generate select? You have
Hello,
sasha said the following on 08.01.2007 15:57:
Use IDataAdapter's RowUpdated event.
And whar next? Fill new dataset and merge it with existing?
It's up to you ;-)
Why would you need this when you could use INSERT ... RETURNING?
It's not clear for me how to return values from this
How do you generate insert commands? I doubt that you could generate
INSERT ... RETURNING command, as .NET provider should support firebird
versions older than 2.0, so you should use INSERT ... RETURNING manually.
And make refreshing of dataset after this command?
sasha wrote:
But if i have 1 000 000 records in datbase and inserted one record why i
should refresh other 1 000 000 ? Such behavour have no sence as for me.
I want refresh only inserted or updated records. Is it possible?
And where are you storing these rows?
BTW how the RefreshSQL
BTW from my POV seems to be that your application isn't well designed...
I.e. if you have 1M records in table, why are you all showing to the user?
Shouldn't be there some filter? If sou, then the refresh of dataset isn't
problem at all.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ |
Hello,
sasha said the following on 08.01.2007 16:58:
How do you generate insert commands? I doubt that you could generate
INSERT ... RETURNING command, as .NET provider should support firebird
versions older than 2.0, so you should use INSERT ... RETURNING manually.
And make refreshing of
And where are you storing these rows?
I haven't million records yet. That was just a sample.
BTW how the RefreshSQL procedure in Delphi loads only the changed row? AFAIK
Firebird doesn't return the new row after updating/inserting.
1) For inserting component knows ID because it calls GEN_ID
BTW from my POV seems to be that your application isn't well designed...
I haven't application yet. Now i only try to understand how does it works.
PS Do you know that Visual Studio 2005 does not support visual
inherirtance for .NET 2.0 controls such as DataGridView? This future
worked
Change just record you have updated.
Again.
1) I've generated DataSet and TableAdapter.
2) Called DataSet designer
3) Right click on table adapter and choose Add query
4) Choose Use SQL statement
5) Choose INSERT
6) Generate command like this
INSERT INTO Tab (Name, Description) VALUES (@Name,
Use IDataAdapter's RowUpdated event.
And whar next? Fill new dataset and merge it with existing?
It's up to you ;-)
Why would you need this when you could use INSERT ... RETURNING?
It's not clear for me how to return values from this command. I've
generated INSERT command, but in
sasha wrote:
1) For inserting component knows ID because it calls GEN_ID before
inserting and than inserts record with alredy known id
2) For updating it use something like @ID variable
So i don't see any problems...
You can do this in ADO.NET. First you get the ID, i.e. select
Jiri Cincura wrote:
sasha wrote:
1) For inserting component knows ID because it calls GEN_ID before
inserting and than inserts record with alredy known id
2) For updating it use something like @ID variable
So i don't see any problems...
You can do this in ADO.NET. First you get the ID,
Don't worry. ;) ADO.NET is easy.
Still don't understand why it's not possible to open a few datareaders
in same connection... Same with transactions...
-
Take Surveys. Earn Cash. Influence the Future of IT
Join
sasha wrote:
All this was built into FIBPlus components and worked automatically. I
should only select generator from drop down list and key field value and
that's all. That was a common practice :-)
You can do this by hand in ADO.NET in 5 minutes. Why to build this into .NET
Provider?
As
IMHO It sounds like you are doing something that the table adaptor might
not be the best fit for. I have never been a big fan of loading a
million records (or anything close to that in a data set) on a client
machine. No matter what solution you use to refresh you data it's going
to be
sasha wrote:
Don't worry. ;) ADO.NET is easy.
Still don't understand why it's not possible to open a few datareaders
in same connection... Same with transactions...
Because DataReader uses connection exclusively. You have to open DataReader
fetch all data, close it, open another, etc.
For
Hello,
sasha said the following on 08.01.2007 20:31:
Change just record you have updated.
Again.
3) Right click on table adapter and choose Add query
Oops. You didn't mention any right clicks before. I don't use right
clicks when coding, so, sorry, I can't advice here ;-)
--
Oleg
Trofimich wrote:
PS Do you know that Visual Studio 2005 does not support visual
inherirtance for .NET 2.0 controls such as DataGridView? This future
worked since Delphi 2 and VS 2003 and i thought it works in VS 2005 but
no, microsoft decide that we can make all changes manually!!! Yet
32 matches
Mail list logo
