Steve Ramacher wrote:
> Personally I avoid the black box, wave a magic wand approach.
Why? With this you can have a lot of fun and a lot of long nights. ;)
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
sasha wrote:
>> For example, binding to the same object created for this is your friend. :)
>
> Not understand you :-/ My english is not good :-(
Create DS with i.e. 3 tables (this is probably new for you, AFAIK in Delphi
was DS only with one table). Then bind first component to it and the secon
>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
> 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 Dat
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 us
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 v
Hello:
> ObjectDataSource is really great !!!
Forgot, I'm using them as well in this asp.net app as the TableAdapters
are not used directly in the Web Forms hehe
They are great.
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
--
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. Inf
> Now, in my daily job, i'm starting to use asp.net and i'm starting to
> use tableadapters ( against sql server 2005 )
> and one think i didn't like of them is how bad transactions play with
> them, in my actual development that is
> not going to be a hard problem but in other cases will be ( th
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.
> My friend, from a logical standpoint what you are trying to accomplish
> is not a drag and drop functional operation. What you are asking the
> adapter to do is look at my table, insert/update any new rows, and get
> the changes. So from that stand point you need to call the update method
> on yo
>> 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
> Hi, as far as i understand RowUpdated is an event of FbDataAdapter, don't
> search for it in DbDataAdapter, or
> IDataAdapter
Yes, FbDataAdapter is on other logical level. My "businnes objects"
don't know about any FbDataAdapter.
> While inserting i usually do so:
> 1) with DataView filter o
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 ne
> 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 f
> 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 St
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 disa
> 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:
>
> 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!!!
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
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.
> 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 ex
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?
>
> 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 SourceFor
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 yo
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 gen_
>>> 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 comman
> 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") VAL
> 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 sinc
> 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 GE
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 refresh
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/ | htt
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 proced
> 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?
> Why it should generate select? You have DataSet with data, so after posting
> data into DB, you ca refresh it and get fresh data. Same with DataReader, if
> you're using it.
But if i have 1 000 000 records in datbase and inserted one record why i
should refresh other 1 000 000 ? Such behavour
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 fr
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 h
> 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 don't you just create before insert trigger to generate
> Use IDataAdapter's RowUpdated event.
And whar next? Fill new dataset and merge it with existing?
> 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 execute mode i see only NonQu
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 h
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 wor
41 matches
Mail list logo
