No problem, I'm glad you have joined the list of people who contribute to the site. Have fun :-D I must get a clever new signature for 2011.

:doh: That'll teach me to skim read MSDN. Fixed. OSDev :)

Looking at this I don't think it is possible. I would question what is the purpose of rotating everything through 90 degrees; the only answer I can think of is that the user will be lying down to use this application! Or have I missed something?

Dot Net Jantu wrote: HOW DO I ATTACH THE FILE HERE IN CODE PROJECT? You don't there is no facility to upload files. This should be in the General Database forum as it is a query. What have you tried so far?

hi, if File.Open does not do what you expect, then maybe your expectations are incorrect. Go and check the documentation. That is what it is for. :) Luc Pattyn [Forum Guidelines] [My Articles] - before you ask a question here, search CodeProject, then Google - the quality and detail of your question reflects on the effectiveness of the help you are likely to get - use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

so far for "no need to test for existence"... :) Luc Pattyn [Forum Guidelines] [My Articles] - before you ask a question here, search CodeProject, then Google - the quality and detail of your question reflects on the effectiveness of the help you are likely to get - use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Thank you very much. Thanks and Regards,

in the keydown event of the tab control test for that key combination and if found. e.handled=true

Dot Net Jantu wrote: bnkWith = GetGridTotal(dgtmp, dgtmp.Cols(WITHDRAWLS).Index) Your code is assuming that dgtmp.Cols(WITHDRAWLS) is returning an object. If it doesn't return an object, meaning that it returns Nothing, calling the Index property on it will throw this exception. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Hi, That is solved, another problem now. Eg: I have a flexgrid with two columns(Select as boolean and Name as string) in which in the column of name I already have my name, now if i again upload a excelfile which has my name, in the datagrid my name should come checked. How do I do that. The thing which I have already done is as below: It will take some time for you to read this, but please read as I am stuck in a quick sand. Private Sub btnUpload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpload.Click Dim filename As String Dim od As New OpenFileDialog Dim SheetName() As String Try od.AddExtension = True od.DefaultExt = ".xls" od.Filter = "Microsoft Excel Workbook(*.xls)|*.xls" od.ShowDialog() filename = od.FileName SheetName = dgtmp.LoadExcelSheetNames(filename) dgtmp.LoadExcel(filename, SheetName(0), C1.Win.C1FlexGrid.FileFlags.IncludeFixedCells) Dim dgCol As C1.Win.C1FlexGrid.Column For Each dgCol In dgtmp.Cols dgCol.Name = dgtmp.Rows(0)(dgCol.Index) Next dgtmp.Cols.Add() dgtmp.Cols(dgtmp.Cols.Count - 1).Name = "SEL" dgtmp.Cols(dgtmp.Cols.Count - 1).DataType = System.Type.GetType("System.Boolean") objEms.RetrieveSearchData("FIS104", "BANK_CODE='" & BankCode & "'", "", sCompany, sPlant, dsRet, Nothing) If Not IsNothing(dsRet.Tables(0)) Then If dsRet.Tables(0).Rows.Count > 0 Then CLEARDATE = dsRet.Tables(0).Rows(0)("CLEAR_DATE") WITHDRAWLS = dsRet.Tables(0).Rows(0)("WITHDRAWLS") DEPOSITS = dsRet.Tables(0).Rows(0)("DEPOSITS") CHEQUENO = dsRet.Tables(0).Rows(0)("CHEQUE_NO") DESCRIPTION = dsRet.Tables(0).Rows(0)("DESCRIPTION") Else ShowMessage("Format not Defined", 30) End If End If Dim dgRow As C1.Win.C1FlexGrid.Row For Each dgRow In dgtmp.Rows 'If dgRow.Index > 0 Then If dgtmp.Rows.Count - 1 > 0 Then With dgBankReco **Dim curRow As Integer = .FindRow(dgRow(CHEQUENO), 0, .Cols("CHEQUE_NO").Index, False, True, False)** If Val(.Rows(curRow)("DEBIT").ToString()) = Val(IIf(IsNothing(dgRow(DE

good job please don't forget to vote on the post that helped you.

Dim grid As New GridView Dim b1 As New BoundField b1.HeaderText = "SerialNo" b1.DataField = "SerialNo" grid.Columns.Add(b1) grid.Columns.Add(b2) God is always with you.

Dot Net Jantu wrote: I would like to know that do i need to assign a id for the button also? You probably should do. You will need to if you want to locate instances of the Button control calling FindControl on the container object. Dot Net Jantu wrote: And one more thing will i have to use that find control method in each and every procedure to retrieve the value of the control? Yes, if you don't already have a reference to one of the controls you will need to call the FindControl method on the container object, passing in its ID to find it. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

There's nothing wrong with a visit to the dentist. I can say that now, having finally recovered from a 2 hour ordeal in the hands of my dentist. Deja View - the feeling that you've seen this post before.