Hi All, I am back for eating everybodies head. Attached is the excel file in which there are 3 formats of a same table in a report. So based upon these 3 formats I have created 3 different rpt files. Now the client is saying that he can anytime add any number of columns in any place and report should be generated. This means right now if you have look at the excel file, Format 2 has the highest number of column. But he can introduce fields in between or in the beginning or in the end. Right now "Reading Before Adjustment" or "Reading After Adjustment" has 3 columns, but number of columns can either increase or decrease also. So is it possible to dynamically create text object, assign them locations on the report and so on? I did not find the facility of attachment. You can see the attachment here : Here[^]

Thanks and Regards,

Thanks for that hint.. solved. problem solved... 1 Sec = 1000 1 hour = 3600000

Thanks and Regards,

Hi Guys, I have dragged and droped a timer control "tmrGetMappingXML" from the Common Controls Tab in Tool Box. The issue that I am mentioning also appears for the Timer Control present in the Components Tab in tool box. In the form Load i have written: tmrGetMappingXML.Interval = 3600; //1 Hour = 3600 Seconds tmrGetMappingXML.Enabled = True; tmrGetMappingXML.Start(); The timer interval is also set in the design time to 3600 seconds. But the Tick event of the timer fires continuously every second. Fed up. Please suggest. Regards, Sourabh

Thanks and Regards,

I think I have tought of a better option.. for each form I will create a user control.. and then call that user control on their main forms... suppose for Menu i will create frmMenu and this form will have one user control as uMenu.. each and every control will be placed in this uMenu.. and this uMenu will be draged on frmMenu... sorry.. can we rotate a single control by 90 degrees counter clock wise and adjusts its height and width as per its main form, I mean to say can we Anchor it?

Thanks and Regards,

Hi All Gurus and Learners and Fools Like Me, Yesterday I had a client chat. This requirement is funny but a challenge for we developers. He wants a application from me. The functionality of the application is not that difficult. The challenge is in the displaying of the forms. I have not started coding yet. When I run the application, the screen should be in the land scape format irrelevant of which computer or laptop you are using and how costly it is smile :laugh: . The form should be displayed 90 degrees rotated in counter clock wise direction. How is that possible? Regards, Sourabh.

Thanks and Regards,

Hello EveryBody, After a long long time. Dear Moderator Sorry for posting it here. Could not find a proper place for posting Query related post and also it was urgent. I have a database in MSAccess. I have a table as tbl_Menu. This table has a parent child relation ship. Parent Node is : MenuItemId and its Child Node is : MenuItemPopUpHeaderID The table structure is attached in Excel File with data.(HOW DO I ATTACH THE FILE HERE IN CODE PROJECT?) I want a query to pick up the last child Item of each Parent Item. I am using VS 2008 (c#) as front end. Regards, Sourabh.

Thanks and Regards,

Hi All, I have a text box in which a file path is displayed. A button to click and open the file. Code executes properly but the file dosent open. Here is the Code:

Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click
Try
strIOPath = ucFile.TxtCode.Text
If strIOPath = "" Then
ShowMessage("No File For This Transaction")
Exit Sub
End If
If IO.File.Exists(strIOPath) Then
File.Open(strIOPath, FileMode.Create)
Else
ShowMessage("File Not Found")
End If
Catch ex As Exception
ShowMessage(ex.Message)
End Try
End Sub

Thanks and Regards,

Hi All, After A long time.. Hope u all are good.. I am having btnUpload and btnTransfer. On btnUpload I open a openFileDialogue select any type of file and at transfer i want to transfer it to another location suppose D:\TransferTest\. But its giving this error Could not find a part of the path 'D:\TransferTest\'. The code is as below :

Dim filename As String
Dim ofd As OpenFileDialog

Private Sub btnUpload\_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpload.Click
    ofd = New OpenFileDialog()
    ofd.Filter = "All Files|\*.\*"
    ofd.ShowDialog()
    If ofd.ShowDialog() = Windows.Forms.DialogResult.OK Then
        filename = ofd.FileName()
        txtFile.Text = filename
    End If
End Sub

Private Sub btnTransfer\_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTransfer.Click
    File.Copy(filename, "D:\\TransferTest\\")
End Sub

Help with a code tip... its a urgent.. Regards, Sourabh

Thanks and Regards,

Dear All, I have a GridView: -----------

 ;

------------ Protected Sub btnSel_Click(ByVal sender As Object, ByVal e As EventArgs) "This code is in CodeBehind file. Here i want to write the code of assigning the selected rows 2nd column data in the textbox txtast." End Sub ----------- There will be other columns with this column in begining for each row in the grid. On click of the the button, I want to assign the 2nd column data of that row in a text box(txtast). How do i do that? Regards.

Thanks and Regards,

Hi All, In database I have two columns ParentCust and ChildCust. I have a tree view. Now I want to convert the tree view data in the dataset. I have a dataset in which I have these two columns as ParentCust and ChildCust. How do i do that. A code snipet will be helpfull to me. Regards, Sourabh.

Thanks and Regards,

Thank you very much.

Thanks and Regards,

Hi All, I am using a Component One Flex Grid. I have data populated in it, with one fixed row in the begining. That grid basically shows the present godown stock of the plant (dgMatStockDn). My Requirement: When I right click on the first fixed column of the grid, it should give me a menu having menus "Insert", "Delete", "Copy", "Paste". Suppose if my any of the previous stocks are same. I would like to copy the whole line again. I will right click on the grid. Click "Insert". A new row will be inserted. I will right click on that particular row. Select "Copy". Then I will right click on the new row, select "Paste" and the same row should get copied here also. Tell me the logic and also on which event of the datagrid should I right this. I hope the requirement is clear.

Thanks and Regards,

Hi, I Have form in which I have 3 tabs. The tabs should tougle based on the button click. But if I press Ctrl+Tab or Ctrl+Shift+Tab, it still toggles. How do I stop this using coding in Dot Net. Regards, Jantu.

Thanks and Regards,

Hi, Kindly see the codes below: On the next button I call ShowReconcileStatement. In ShowReconcileStatement I call GetGridTotal. When I call the GetGridTotal, Before it enters the procedure, I get an exception as : Object reference not set to an instance of an object. The code where the exception occurs I have underlined. Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNext.Click Try tcBankReco.SelectedIndex = 1 ShowReconcileStatement() Catch ex As Exception End Try End Sub Private Sub ShowReconcileStatement() Try Dim i As Integer Dim bnkDep As Double = 0 Dim bnkWith As Double = 0 bnkWith = GetGridTotal(dgtmp, dgtmp.Cols(WITHDRAWLS).Index) bnkDep = GetGridTotal(dgtmp, dgtmp.Cols(DEPOSITS).Index) Catch ex As Exception End Try End Sub Private Function GetGridTotal(ByVal dg As C1.Win.C1FlexGrid.C1FlexGrid, ByVal col As Int16) As Double Try With dg Dim rg As CellRange = .GetCellRange(1, col, dg.Rows.Count - 1, col) Dim agg As String = .Aggregate(AggregateEnum.Sum, rg) Return CDbl(agg) End With Catch ex As Exception Return 0 ShowMessage(ex.Message, 30) Finally End Try End Function Please suggest..

Thanks and Regards,

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

Hi, I have a excel sheet, in that the fields are: Name,EmployeeID,Address,Email. Sourabh,757,New Bombay,something@something.com I have a C1.Win.FlexGrid in which I have put the same columns in this grid with one more colum in the starting as Select(Boolean). This is the code that I have written..... Dim ofd As New OpenFileDialog Dim dgtemp As C1.Win.C1FlexGrid.C1FlexGrid Dim fn As String = "" Dim sheetname() As String ofd.AddExtension = True ofd.DefaultExt = ".xls" ofd.Filter = "Microsoft Excel Workbook(*.xls)|*.xls" ofd.ShowDialog() fn = ofd.FileName txtFile.Text = fn dgtemp = New C1.Win.C1FlexGrid.C1FlexGrid **sheetname = dgtemp.LoadExcelSheetNames(fn)** dgtemp.LoadExcel(fn, sheetname(0), C1.Win.C1FlexGrid.FileFlags.IncludeFixedCells) Thje bold part of the code is giving error as: "Failed to open storage file." Help...

Thanks and Regards,

Hi, This is also a good way if you dont want to change your column name while retrieving. dsSave.Tables["FA_ASSET_DEP"].Columns["BASE_AMT"].ColumnName = "DEP_AMT" I have got this with intense research and development...:laugh:

Thanks and Regards,

Hi All, I have a Dataset, in which there is a table and in that table i want to rename a column.. how? dsSave.Tables["FA_ASSET_DEP"].Columns["BASE_AMT"]; dsSave is Dataset. FA_ASSET_DEP is table BASE_AMT is the column to be converted to DEP_AMT ?????? HELP

Thanks and Regards,

I have created a gridView at run time like this: Dim dgUserGrid As GridView dgUserGrid = New GridView dgUserGrid.ID = 5 dgUserGrid.AutoGenerateColumns = False dgUserGrid.BackColor = Drawing.Color.Brown dgUserGrid.ForeColor = Drawing.Color.White dgUserGrid.AllowSorting = True dgUserGrid.AlternatingRowStyle.BackColor = Drawing.Color.BurlyWood also added this: Protected WithEvents dgUserGrid As System.Web.UI.WebControls.GridView dssave.Tables("dtUsers").Rows.Add() dssave.Tables("dtUsers").Rows(0)("UserName") = name.Text.Trim dssave.Tables("dtUsers").Rows(0)("cPassword") = password.Text.Trim dssave.Tables("dtUsers").Rows(0)("Role") = Role.SelectedItem.Text.Trim dssave.Tables("dtUsers").Rows(0)("PasswordChanged") = 0 Dim userdetgrid As GridView = GridHolder.FindControl(5) userdetgrid.DataSource = dssave.Tables("dtUsers") userdetgrid.DataBind() this code is working fine but not appropriate. I want to create boundcolumns at runtime.??????

Thanks and Regards,

hey thanks it worked. I would like to know that do i need to assign a id for the button also? And one more thing will i have to use that find control method in each and every procedure to retrieve the vbalue of the control?

Thanks and Regards,