Hello, You can use: If not isnull(datagridview(0,3).index.value) then mytext = datagridview(0,3).index.value End if

Hi, The context of which you are using to try and get the customerId is incorrect, the reason is because the current item that you are trying to get data from is an anonymous type. This type doesn't have any default members like the exception states. Unfortunately, I don't have any exact support for this sample code you put, but if you were using a real type (even if you made the type yourself using a custom class) you could typecast the item contained in MyBindingSource.Current to retrieve the data from it correctly. hope this helps

If you are using PhpMyAdmin, it will show all primary and secondary index related with table.

Replication is a bit of a black art. There is plenty out there on google. Really the only way to go about it is to start and experiment. The reason I say this is that the type of replication you use is dependent on lots of factors and experimentation is the best way IMHO. My position is that I have never used it myself, but have worked for companies that use it and have seen how complex it can get. I am considering using it and with the dearth of practical information out there it has become apparent to me that bar having a DBA with experience in replication at your side - experimentation is the best way. You always pass failure on the way to success.

Cursor = Cursors.HourGlass Something like that Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

thanks guy i really appreaciate your help..

I'm not sure why you replied to my message instead of the original poster. Anyway, it's pretty obvious from the query syntax that the database being used is SQL Server not Access. Paul Marfleet

hi Widget its time for you to buy a book. here is your Code http://www.programmersheaven.com/download/35539/download.aspx[^] hope it helps Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

Hi, The datagrid by default does not offer checkbox as a value for any of its cells. However I have created a work-around to get around this problem. I have placed a checkbox on the form and when the grid loads the checkbox is moved to the cell. Code attached:). ************ Private Sub Form_Load() 'on the form: 'one flexgrid (named= flex1) 'one checkbox (named= tb) Dim intX As Integer tb.Visible = False With flex1 .Columns(0).Width = 2000 .RowHeight = 300 tb.Caption = "Box" tb.Width = 500 tb.Move flex1.Left + 350, flex1.Top + 250, flex1.Width / 15, flex1.Height / 199 tb.BackColor = .BackColor tb.Visible = True End With End Sub ************ Gary Bigman. Software Engineer ComponentOne LLC www.componentone.com

i want to retreive float data and display in currency? but with this format #,###,##0.00... can it be?

What you're doing shouldn't corrupt the .resx file. But, then again, if you don't have the latest service pack installed, there's no telling. You might be forced to recreate the form from scratch. Do not copy the controls from the old form, but drag and drop new ones. You can copy and paste the code form the old form though. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Or you can use the Windows Scripting Host to get it. Dim WshNetwork As Object Set WshNetwork = CreateObject("WScript.WshNetwork") MsgBox WshNetwork.ComputerName A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

basically there is no advantages of having sub queries...

Yap, thanks dave...

Yeah....ok. :~ And why are you replying to a 4 year old message?? A guide to posting questions on CodeProject[^] Dave Kreskowiak

Create a new Group based on the formula. Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia