Hi All, I have been searching everywhere but I am totally stumped. Can anyone PLEASE help. I am using VB.Net 2005 edition and have a DataGridView (DGV)on my form. The DGV is NOT bound to anything as I want the user to input their values. Once they have finished I THEN want to save the valu...more >>

Here is the situation: A DataTable has contains rows with all rowstates in it. A Table Adaptor.Update is performed that is wrapped in a TransactionScope. An error occurs and the complete is not called. All is well on the Server, all rows are backed out. My DataTable is not so well. S...more >>

T thought of that, so for a test I created a Column named "FROM'. This did not cause a column named "_FROM" to be created. And referencing "tablenameRow.From" caused no build errors. Furthermore, Intellisense showed the column "From" in the list of properties/columns for the DataTable Row. ...more >>

IN is a sql keyword.... -- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ "r0bb1e" <r0bb1e@discussions.microsoft.com> wrote in message news:24472FF6-51B5-4B72-A447-3B8ADF...more >>

Hi, Generated classes are partial. Thus you can simply create another partial class with same name living in same namespace and add your property there. -- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rtha...more >>

Thanks for answering! I'll study it... -- Rafael Soteldo "Cor Ligthert[MVP]" wrote: > > Rafael, > > You are using so many techniques over each other that I don't know how to > answer this. However this class manages your positions in a table. > > http://msdn2.microsoft.com/...more >>

oh yes, the error message I'm getting is OleDbException "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."...more >>

I'm trying to insert data into a csv file using System.Data.OleDb but I'm unable to insert rows with character fields bigger that 255 characters. the code: const String INSERT_STATEMENT = "insert into [table#csv] (SmallStr, BigStr) values (@SmallStr, @BigStr)"; OleDbConnection ...more >>

I have a simple DataSet with two tables, ParentTbl and ChildTbl. They each have a ChildId column. They are joined by a relation ParentTbl_ChildId which associates the ChildId column with ParentTbl as the parent and ChildTbl as the child. This DataSet is not based on a database (it is saved to an...more >>

Completely untested, but can't you do something like: for each dgvr as datagridviewrow in dgv.rows table.row.Column = dgvr("<Col name> or <Col index>") next Rick "Bails" <affinity_sales@australiaonline.net.au> wrote in message news:1209034999.930379@kangaroo.ozonline.com.au... > Hi ...more >>

Jonefer, I never use the IIF in VB, but I know that with VB everything will be evaluated, so in this case can that be the reason of your problem. However very good hidden is the isdbnull property on MSDN. http://msdn2.microsoft.com/en-us/library/system.data.idatarecord.isdbnull(VS.71).asp...more >>

Rafael, You are using so many techniques over each other that I don't know how to answer this. However this class manages your positions in a table. http://msdn2.microsoft.com/en-us/library/system.windows.forms.currencymanager.aspx (It has nothing to do with currencies in the way of mon...more >>

Hi I am using this below code to convert rtf templete to Pdf Report using XML data source. Its working fine. But I dont know how to do the same using SQL datasource. Pls help me out in this Thanks, Giri. import net.windward.xmlreport.*; import net.windward.datasource.dom4j.*; import j...more >>

The DataBinding book by Brian Noyes is awesome. You might also want to check out Deborah Kurata's Doing Objects in VB2005. With that book you end up building an entire application using business objects, including setting up the stored procs for updating. RobinS. GoldMail.com "John"...more >>

I manually created a DataTable in a Typed DataSet using the DataSet designer in VS 2008 Pro. One of the Column names is "IN". When referencing this table in VB.Net 2008, the IntelliSense did not show the column "IN" but it did show a column "_IN'. If I tried to reference this column in cod...more >>

Not sure what are you asking for.... Can you provide some more details? What's wrong with your code (except for the fact that you should use new DateTime(2008, 6, 1) instead) -- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com ...more >>

I have a group of records in a set - usually 5-10 rows. For example ProviderPanel would have several elements. I do this so I can handle the formatting of each value on a case by case basis. A typical scenario would be that before writing any records to either labels or a class, I should t...more >>

Hi, I have downloaded and installed beta 3 of Ado.net entity framework and played with this a little bit and it's quite cool - I can query the database and get the objects etc. The only thing I can't dig to is how to actually create custom attributes in the classes that the framework has gene...more >>

Yes, I expect that the lazy write issue is causing these symptoms. Try wrapping the operation in a transaction. -- __________________________________________________________________________ William R. Vaughn President and Founder Beta V Corporation Author, Mentor, Dad, Grandpa Microsoft M...more >>

I accept that rebuke; your assessment may be true, but I have left significant complexity out of this discussion because of its tendency to hide the real problem that I am fighting. (Case in point: the table names and column names are not the same between the files.) Yesterday, we "stum...more >>

John, From your description I was not sure if you had to update datarows or only to insert. As you state it now probably a simple merge can do the job (as long as you use the same tablenames and the same columnnames). Why avoid simple tools for simple jobs. Like you write it, it seems ...more >>

On 17 Apr., 05:32, "Cor Ligthert[MVP]" <notmyfirstn...@planet.nl> wrote: > That Summit brings everybody together. Hi, thanks to you all for your feedback. I'll think about redesigning my process. regards, Achim...more >>

Hi there: I need to get the position of a given Row to navigate directly to it, in a form that has a BindingNavigator and several TextBoxes showing each rows details... I dragged the fields from the Data Sources window to the form in the designer, which created the BindingNavigator attac...more >>

Hi, How can I use a date string to test a date in a LINQ query. Below is a query in Northwind Many thanks for any help Ant NorthwindDataContext db = new NorthwindDataContext(); var resultSet = from o in db.Orders where o.OrderDate >= Convert.ToDateTi...more >>

Johh, Why not simple use a DataAdapter to update as you tells that it is a single non related table than it should be a piece of cake. (You can then probably simple use the commandbuilder) Cor "John W." <JohnW@discussions.microsoft.com> schreef in bericht news:6A447E4E-19FE-403A-A8CE...more >>

I avoided using DataAdapters since (1) the operations I needed were so basic, (2) I don't feel very comfortable with them, and (3) with the exception of two tables, I don't need to have the updated tables in memory--only in the file. (Those two tables are used to reconcile several foreign key...more >>

I've seen other posts with similar problems, but no solutions. I have two hair-pulling dilemmas that have been frustrating me for months now. Is there no solution? (C#.NET, Framework 2.0, Jet OleDb 4.0) The general goal is to read one MDB file and copy relevant info into another MDB file...more >>

"cfps.Christian" <ge0193387@otc.edu> wrote in message news:70918e95-f585-4283-951c-5a23612a7463@a22g2000hsc.googlegroups.com... > So far I have not found a book that truly explains > how to program, the problem I've found is the authors generally treat > you as if you know nothing at all and ...more >>

> I've found is the authors generally treat > you as if you know nothing at all and you don't learn what you need to > know or the author assumes you know too much and you can't do what > they're showing you due to missing steps. I don't know if you are married, but then does your wife alwa...more >>

"John" <info@nospam.infovis.co.uk> wrote in message news:OtPxQ$8oIHA.1952@TK2MSFTNGP05.phx.gbl... > Any additional recommendations would be appreciated too. Basically > anything that will get me off your backs. > MODEL-VIEW-PRESENTER http://www.polymorphicpodcast.com/ click 'Shows' ...more >>