- Strength to Increase Rep
- +5
- Strength to Decrease Rep
- -1
- Upvotes Received
- 10
- Posts with Upvotes
- 10
- Upvoting Members
- 7
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
- Interests
- Books, coffee, family
- PC Specs
- Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
64 Posted Topics
Re: Try: .refresh(), then .items.clear(), then invalidate() | |
![]() | |
Re: We don't do print to form in VB.Net, but I can suggest some objects like ReportViewer. In my case, I prefer using CrystalReport so I'm using CrystalReportViewer quite often, it show a copy of what you are going to print and even let you save your printing to .doc,.pdf or … | |
Re: "multiple definitions with identical signatures" error means you have 2 (or more) subs with one same name. I suggest u might post those lines twice so better re-check, just delete all unwanted lines. cgeier's "ModuleCustomer" was to: Seperate sub for timer with others, so you can use it on others … | |
I'm unable to add IIS Apppool\<pool_name> into Permission for both Components and Folders. When using Check Name: seems like there was no matching Apppool name. My system: IBM server - Windows Server 2003. Beside, I have no experience for Win 03, but have always success with Win 08 - Really … | |
How could I change the column header of the Data Grid to center or right but not left as default? [Pls pay attention, We are talking 'bout Data Grid here, recently I always receive answers for Data Grid View instead :( ] I just want to re-align the header only, … | |
Re: Not being able able to fully understand your question, it was, quite, complicated. If just some tables, why don't you add your tables into a dataset then use: ds.WriteXml("C:\BackUp\New.xml") | |
Re: Oh friend, that was a simple one. Here's a help: CloseButton.Anchor = AnchorStyles.Top + AnchorStyles.Right | |
Re: Creat a .dll file which you added to your projects, or a class which contains a public shared sub doing changing your language. Create a public datatable contains languages you needed and their code, then inherit them in your forms. Anw, writing all those was long and I'm being lazy … | |
Re: Hey guys, that was quite a tricky question! If you had a new table which was the inner join of multiple other tables, you could easily delete a row on the new table, right? Or if you want to delete a row from the new table and then, together, deleting … | |
Re: From "Kevin" (That project creator): If you are interested in the source, you can try http://www.liveswitch.com you can buy the component there for *$50* or contact support and ask to buy the source. there is a demo component you can try which has a splash screen. Support *will get it … | |
Recently I've used zedgraph barchart to create a chart with 12 bars. I did want to put each bar on an x-axis scale and change the label name of that scale, but I did not success. Could you please show me the way the put my bars inside the scales? | |
Re: If you're wanting a startup process, you could go to : Run > Type "msconfig" > Choose "Startup" tab > Check your process > Ok > Restart computer. If you're wanting to create a project which run on startup of windows after install, I suggest using Microsoft.Win32 (or 64, I … | |
Re: Here's how I'm handling things: AddHandler Button1.Click, AddressOf NetworkConnectionChanged Button1.Click could be remove with your event. And btw, AddHandler sometime doesn't work with Private Sub, use Sub instead might be safer. | |
Re: Did you Dim mydatarow As DataRow() but not DataRow? Ok, normally people do that. But, you cannot add a whole array instead of an item into ListViewItem. Please use For loop to add each ListViewItem. For i As Integer = 0 To mydatarow.Length - 1 ListView1.Items.Add(New ListViewItem(mydatarow(i)("FirstName").ToString, mydatarow(i)("LastName").ToString)) Next | |
Re: There's no option for .txt in CR, but, you can still get a bad version of .txt if you want. Try Dim CrExportOptions As ExportOptions Dim CrDiskFileDestinationOptions As New DiskFileDestinationOptions() Dim CrFormatTypeOptions As New PdfRtfWordFormatOptions CrDiskFileDestinationOptions.DiskFileName = "YourDestination" CrExportOptions = myReportDocument.ExportOptions With CrExportOptions .ExportDestinationType = ExportDestinationType.DiskFile .ExportFormatType = ExportFormatType.RichText .DestinationOptions … | |
Re: Get you Accinfo table into a datatable (dt). You should have a TextBox to insert accname (TextBox1). Private Sub TextBox1_Validated(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.Validated For i As Integer = 0 To Dt.Rows.Count - 1 If TextBox1.Text = Dt.Rows(i).Item("Text").ToString Then MsgBox("Acc has ...") Exit For End … | |
Re: First, I should say that CR is not going to filter table out, so you should filter them first in VB.Net. You should create 2 tables: Table 1 contains: Sr.No, Sr Name,etc. and a final GrandTotal (which was calculated in VB.Net). Only have 1 row and works as the main … | |
Re: I notice you didn't have @farmer when adding value, the query wasn't complete. Try add @farmer value and see what's going to happen. | |
Re: The login detail may be change due to the change of database path in crystal report. I supposed you used local path when creating data connection in your report, and then when you move to another computer, your report couldn't find the old path. That's just my first idea, there … | |
Re: I'm using Unicode and Vietnamese with MS Access 2007 and till now no problem rasing. My default encode was UTF-8, I installed Vietnamese language pack and set reagion to +7 in control panel. Well, I wish my information could help you, those problem with regional language were the worst. | |
Re: I checked briefly through your code and the problem seemed to be that diskDestination. I'm not sure since I'm not a pro. In my point of view, HTML is not only a file, it contains many objects and they're in a folder. Then when you creating a file but not … | |
Re: I fixed it, but replaced the For Each with For: For i As Integer = 0 To ds.Tables("data").Rows.Count - 1 If ComboBox1.SelectedItem.ToString = ds.Tables("data").Rows(i).Item("YourColName").ToString() Then TextBox1.Text = ds.Tables("data").Rows(i+1).Item("YourColName").ToString() TextBox2.Text = ds.Tables("data").RowsRows(i+2).Item("YourColName").ToString() '.... add more textbox End If Next | |
Re: You're not conneting with the database, or your query is wrong, or value is NULL, etc. Say, why did you give out a no-information question? Please show more information, sample code, or image, or description so we could provide better helps. | |
Re: I tested your code and it was right. But, somehow, your ds did not change during run time and it makes your combobox couldn't change, too. My recommendation: Place your combobox loading sub on some where it continually checking SQL and update a new dataset when your SQL table change. … | |
Re: It's quite hard to understand what you're wanting. The problem could lie where you're setting datatable property. But if it's not, I suggest to dim a string first, insert later: Dim Prdt as String Prdt = TextBox1.Text.Trim YourDataTable.Rows.Add(Prdt,Col1Value,Col12Value...) | |
Is there a way to set a window to the top on screen and set focus on it? I'm having a menu in VB.Net calling a bunch of .exe. Everytime a window apears, it runs itself to the top on screen. But there was a window, problem-able one, with some … | |
Hmm, normally, I just cut all those controls out and delete the GroupBox. But, it's not easy all the time, so me just wondering if there was a way to do it without touching the child controls. Remove the relationship? Or other otions? | |
Re: I think the problem here is: You're using selecteditem.value, which is - the value return after combobox clicked. To fill a combobox, I'll use .DataSource and .ValueMember: Dim Dt as New DataTable objDataReader.Fill(Dt) cmbExecutor.DataSource = Dt cmbExecutor.ValueMember = "Executor" | |
Re: I'll help change your button2 then: Dim f As String() = Directory.GetFiles("YourTextFilesPath", "*.txt") For Each dir In dirs ... 'Do anything you want with f.FileName ... Next | |
Re: Came up with a bad idea, you might try this out: Private Sub DataGridView1_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellEndEdit MsgBox(DataGridView1.Rows(DataGridView1.SelectedCells.Item(0).RowIndex).Cells("Text").Value.ToString()) End Sub | |
Re: Hey Shan, bdev's trying to tell you to fill the Try-Catch with "What you want", for example: Try Dim a as String = "" a = txtadd1.Name MsgBox(a.ToString) '... then do something you want here Catch ex As Exception MsgBox(ex.ToString) End Try | |
Re: Add your questions table into an datatable, then: Dim i, j, n as Integer n = 3 'Anything is okay i = CInt(Math.Ceiling(Rnd() * n)) j = CInt(Math.Ceiling(Rnd() * n)) If Dt.Rows.Count >= 3*j + i Then TextBox1.Text = Dt.Rows(j + i).Items("Question").ToString.Trim TextBox2.Text = Dt.Rows(2*j + i).Items("Question").ToString.Trim TextBox3.Text = Dt.Rows(3*j … | |
| |
Re: I discribe brief idea and you'll finished it. This solution lack a Database to store the data, so you might need to create one: 'The public value Public Dt As DataTable = GetTable() Function GetTable() As DataTable Dim table As New DataTable table.Columns.Add("Text", GetType(String)) table.Columns.Add("Date", GetType(DateTime)) Return table End Function … | |
Re: Here's a code of mine, almost solving the same problem as yours: If TextBox1.Text <> "" Then Ftxt = TextBox1.Text For i As Integer = 0 To Me.CheckedListBox1.Items.Count - 1 If CheckedListBox1.Items(i).ToString.Trim = Ftxt.Trim Then CheckedListBox1.SetItemChecked(i, True) End If Next End If | |
Re: Not an expert (yes, a newbie!), but, are you using Access database? Then 'LIKE @' was wrong, use 'LIKE *yourString*' instead will do the trick (or not?). | |
Re: gusano79 solution is right for all objects. But I suspect you are tagging picturebox here, so how about using RotateFlip() to Flip the image inside the picturebox but not a whole picturebox itself? | |
Re: For every types of file or for excel, use: Process.Start(FilePath.Trim"\"+Filename.Trim+".xls") | |
Re: It's hard to tell, it bases on the type of file you are using. The common way was to fill a dataset with your data from your file, then fill data from dataset to your array. | |
Re: Try this: yDTable.Columns("IndexChangeColName").SetOrdinal(IndexYouWantingToChangeTo) I'm not sure about this, but this will change the position of your column and is there're multiple columns to change - like n columns, etc... - you must use this line n times to change all the columns' position. yDTable.Columns("IndexChangeColName(1)").SetOrdinal(IndexYouWantingToChangeTo(1)) .... yDTable.Columns("IndexChangeColName(n)").SetOrdinal(IndexYouWantingToChangeTo(n)) | |
Re: Then you could add your project first then create a subfolder in your installation project to add your crytal reports later? I'm using VS.2005 and everythings was fine till now. | |
Re: My solution is: Creating an array of buttons with your buttons then loop through it together with your SQL columns. | |
Re: Here's your code: Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged TextBox1.Text = TextBox1.Text.ToUpper() End Sub | |
Re: I'm not an expert in SQL but I'll give it a try: 1. Creating a procedure to update 'materialsdetails' table, but update both 'materialsdetails' and 'Products' together. That proc might contain query such as (my suggestion only): UPDATE Products SET TotalCost = 'OldTotalCostValue' + 'NewMaterialsValue' - 'NewMaterialsValue' WHERE ProductsId IN … | |
Re: Tried this once, actually, my button did go like an old motorbike :D My solution was Using .top and .left property and a timer. Clicking the destination start the timer, every tick myBtn move ((myDestination.top-myBtn.top)+(myDestination.left-myBtn.left))/1000n (using n makes sure you can handle the time your object move). First I increase … | |
Re: Just use ToDecimal(). Works everytime. | |
Re: Yes, yes and another yes. There're even some full samples for AD in VB.Net if you try google-ing around. Good luck! | |
Re: First, fill those data into a dataset: Dim ds As DataSet = DirectCast(DirectCast(Dgv, DataGridView).DataSource, DataSet) To XML: ds.WriteXml("Your path" + "\your xmlname".xml) To Mdf? I'm not sure, but, did you want to insert those data into a database? You should have a database, a table, a connection, an adapter, a … | |
Re: May you try: dt.AcceptChanges() dt.Rows.Remove(row) With 'row' is the row which you want to remove. |
The End.