perviously I convert a byte array to string/text and store into database, like coding below: cmd.Parameters("@LeadFormControls").Value = System.Text.Encoding.UTF8.GetString (bytLeadFormControls) how do I convert back string/text back to a byte arrry when i retrieve it from database. Any idea?:confused: Angela

How do i reset 1st item for combolist VSFlexGrid to blank after load the data from database, eg: If adoRset.RecordCount > 0 Then grdPeriods.ColComboList(grdPeriods.colIndex("VintageID")) = grdPeriods.BuildComboList(adoRset, "VintageCode", "VintageID") End If Thanks Angela

how can i show all record in my ultragrid present in crystal report which has 2 columns n multiple rows.. my coding below always show 1st row of record instead of multiple rows in my ultragrid... ' Add all parameter fields into crystal report objPreview = New CRViewer30.CRViewer For i = 0 To ultraGridTransaction.Rows.Count - 1 With objPreview .AddParameterFields("@TaskCode", ultraGridTransaction.Rows(i).Cells("Task Code").Text.Trim) .AddParameterFields("@Description", ultraGridTransaction.Rows(i).Cells("Description").Text.Trim) .ReportName = strReportName .ReportPath = strReportPath .ServerName = gstrPrimaryServer .ServerDatabaseName = gstrPrimaryDatabaseName .ServerDatabaseUserId = gstrPrimaryDatabaseUserId .ServerDatabasePassword = gstrPrimaryDatabasePassword .ScriptingSyntax = CRViewer30.CRViewer.Syntax.VBSyntax .PaperOrientation = CRViewer30.CRViewer.Orientation.Portrait .GenerateType = CRViewer30.CRViewer.GenType.ShowReport End With Next ' Showing report objPreview.Generate() Thanks for help:) angela

yup, i also go through all VB.NET about barcode in CodeProject. Non of them are using barcode font 128... So i can't apply those sample code in my application. I had try google, but still haven't found any solution for my problem :doh: angela

But the link of sample application that you give me just now only can use for barcode font Code 3 of 9 and can't support Code 128.. I'm searching solution for barcode font Code 128. Thanks angela

I can display my barcode in my crystal report successfully when i run at crystal report v by using code 128 font. Unfurtunately, when i want to hook my crystal report in VB.NET form with CRViewer30.CRViewer. The barcode became a string of characters... Isn't i need to define the code 128 font in my VB.NET form even the barcode can display properly in my crystal report..:confused: Any idea about it? angela

I think the previous 'replace' sql statement is more suitable for me because the data that I wanted to remove those underline have different value, not just for 'HIGH COST' only :) Anyway, thanks again for your suggestion.;) angela

ok, i get it :) Thanks a lot for help, Dinuj Nath ;) angela

how to write update SQL statement in order to remove all underline in my data for each field, example: "HIGH COST___" change to "HIGH COST" which is remove the underline for all data.. Thanks angela

Inside my solution has 4 projects. When I opened the solution and loading those projects in Visual Studion .NET, it pop out a error message.. The application for project 'C:\projects\DRM\Setup\Setup.ism is not installed. Make sure the application for the project type (.ism) is installed. The result was one of my project status call "Setup" is unavaliable and can't opened it... :doh: Angela

ok, i get it. Thanks a lot for your explaination, Dave Kreskowiak :) Angela

I can't rebuilt my project succesfully cause get certain errors, those errors are about name, type of control or form is not defined :| I had include one of the reference which is the version 1.0.0.0, isn't this matter cause I can't run my project properly?? By the way, how do I check the account that I logged is under a member of the Debugger Users group and upgrade log for my project :confused: Thanks for your help, Dave Kreskowiak :) angela

I try to convert my project from version 1.1 to version 2.0 and using VB.NET. When I run my project in VS 2005, I get this error: Visual Studio cannot start debugging because the debug target 'C:\Projects\SCM\bin\SCM.exe' is missing. Please build the project and retry, or set the OutputPath and AssemblyName properties appropriately to point at the correct location for the target assembly. Any ideas for error message above ??:doh: angela

i login as computer administrator but don't know what is the group membership for my user account....;P angela

Did you means the group or user names for my project properties? Administrators, creator owner, system and user... angela

I can't run my project in VS 2005 and the error message look like this... Visual Studio cannot start debugging because the debug target 'C:\Projects\abc\Source\Rich Client\abcMain\bin\Release\abc.exe' is missing. Please build the project and retry, or set the OutputPath and AssemblyName properties appropriately to point at the correct location for the target assembly. thanks angela

how do display the data in flex grid after i extend the child of parent tree view? my coding had error after i extend the child of tree view Private Sub treeMain_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single) ' Dim objNode As Node ' ' Selecting the next node ' objNode = treeMain.HitTest(x, y) ' Selecting the first parent node if not is selected If treeMain.HitTest(x, y).Key = "" Then treeMain.SelectedItem = treeMain.Nodes(1) treeMain.SelectedItem.Selected = True End If While treeMain.SelectedItem Is Nothing Debug.Print "Waiting" DoEvents Wend Debug.Print "treeMain_MouseDown" & CStr(Button) & treeMain.SelectedItem.Key treeMain.SelectedItem.Selected = True treeMain.SelectedItem.Expanded = True If treeMain.SelectedItem.Parent Is Nothing Then treeMain.DragMode = ccOLEDragManual Else treeMain.DragMode = ccOLEDragAutomatic End If End Sub Thanks :) angela

In my options page has 2 button, 'Save' and 'Cancel'. After i doing changes for all particular fields in options page, then i click 'Save' button to save it. It works successfully. But my problem is if user click button 'Cancel', then my program should rollback all transaction and the data will back to previous data before i click the 'Save' button. So, has any coding to do rollback transaction in VB6??:confused: Angela

ok, thanks:) angela

what the return value by using String$()??, example: value = String$(255,32) Thanks angela