20,285 Topics
 | |
| | I'm working on an app to parse Excel files. I need to remove invalid characters in column 2 and then in column 3 I need to trim and upper that column. Any ideas? [CODE]Dim sql As String Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet ' … |
| | I work as a console technician for an audio company in the north eastern United States. My job is to prep and manage all of our audio console before they go out on tour. I would like to build an application to assist in our testing process. Basically all is … |
| | Hello Everyone, I have what I hope will be a simple VB question: I am building an app with multiple forms. It has a MainForm, which is the main interface, and several sub-forms that are started using buttons on the MainForm. The MainForm Load method has some code that runs … |
| | [code] ListBox2.Items.Clear() Dim myCoolFolder As String = "F:\" Try For Each myCoolFile As String In My.Computer.FileSystem.GetDirectories _ (myCoolFolder, FileIO.SearchOption.SearchAllSubDirectories, "*.*") ListBox2.Items.Add(myCoolFile) Next Catch ex As UnauthorizedAccessException MsgBox(ex.Message) End Try MsgBox("Total Files: " & CInt(ListBox2.Items.Count).ToString("#,###,###")) [/code] This code is for listing all folders including subfolders. but when i run this code … |
| | Hi, I have a done the following steps which can help you understanding my problem: 1. I took a decimal point number, suppose 192.123456 2. Then removed the decimal point 3. Concatenated the L.H.S and R.H.S and stored it in a string 4. The string that I got was 192132456 … |
| | [B]I have 3 textbox. I want to change Background color when cursor go there, other wise there will be no change.[/B] [B]How can i do this?[/B] [B]My mail address [EMAIL="pretom82@hotmail.com"]pretom82@hotmail.com[/EMAIL][/B]  |
| | Variable 'loNode' is used before it has been assigned a value. A null reference exception could result at runtime. does anyone know why I am getting this error? [CODE]Imports System.Xml Module Module1 Sub Main() Dim doc As New XmlDocument Dim loNode As XmlNode Dim nodes As XmlNodeList doc.Load("C:\Desktop\Template.xml") nodes = … |
 | Hello, Im creating a TS3 server admin tool. And Im having a Problem adding items to the DAtagrid View. Ive got like 8 Columns and I want to add this data to the correct Column But IDK What Im Doing Wrong [LIST] [*]# [*]Server ID [*]Server Port [*]Server Status [*]Clients … |
| | Hi, I wants to ask how to convert DBNull to Date type? [CODE] For Each row As DataRow In dt.Rows i = 0 Dim array As Object = row.ItemArray Dim a As String If array(i + 10) IsNot Nothing Then a = CDate(array(i + 10)).ToString("yyyy-MM-dd hh:mm:ss") Else array(i + 10) … |
| | Ive bin looking for some code to export the contents of a DataGridView to CSV so I can view it in Excel. I found this but ive got errors; [CODE]Dim sr As StreamWriter = File.CreateText(strExportFileName) Dim strDelimiter As String = strDelimiterType Dim intColumnCount As Integer = DataGridView.Columns.Count - 1 Dim …  |
| | I'm trying to figure out how to update the <to>,<from>,<heading>,and <body> through textboxes. Any ideas? [CODE] <?xml version="1.0" ?> - <note> <to>Tove</to> <from>Jani</from> <heading>Reminder</heading> <body>Don't forget me this weekend!</body> </note>[/CODE] |
| | hi i have a stored image in my database. i want it to be displayed in picturebox. anyone here know how to that? here is my code [CODE]Private Sub ListView1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ListView1.SelectedIndexChanged Dim index As ListView.SelectedIndexCollection = ListView1.SelectedIndices Dim i As Integer = …  |
| | I'm pretty sure its a false positive. My program does create and delete files when using it. Is there a way to stop showing as a false postive? |
| | Hi i am trying to write dataset into excel using oledb connection. I get an error "The microsoft access database engine could not find the object 'testTable' Make sure that name and path is correct". I understand that dataset is not in the excel thats y i get an error … |
| | My table gets its information from a Mysql database online. I'm not sure which would be quicker to retrieve the row that contains the information specified. EG. table1 Name________Age John_________5 Joe__________20 At this moment i have a while loop that looks for john and gives me the row. But is … |
| | Hi guys, I am creating a window application in vb.net that need to use sql server database. I want to install this application to client machine without installing sql server so that my application can still connect to a database is there any way for this ? |
| | can anyone help me? i have a problem in converting a 1,000,000.00 number to words i always get result 1 MILLION THOUSAND PESOS ONLY which is wrong. it should be 1 MILLION PESOS ONLY here is my code [CODE]Public Function ConvertMoneyToText(ByVal value As String) As String value = value.Replace(",", "").Replace("$", … |
| | Hi I would like to get simple code on reading and writing into excel files using console application in vb.net. |
| | Hi, I've created an application using VB.net windows application, but now i want to invoke it only from command prompt by giving inputs and outputs. How can i give inputs and get outputs to windows application in command-prompt. My windows application takes file as input and it process and makes …  |
| | I'm very new to programming and was wondering why I am receiving a warning. "Function Checkbox doesnt return a value on all code paths. A null reference exception could occur at runtime when the result is used" I then want to execute this function through button.click event: CheckBox.ExecuteNonQuery() [CODE]Function CheckBox() …  |
| | Hi everybody.. was wondering if it is possible for a person to set a specific height value for the detail section in crystal reports.I want the section to have 10 records and maintain a certain height.If the records are for example 2 or any number less than 10, the detailed … |
| | Hi, I am doing a window servise application using VB.net. I have faced problems with sql suery, as below: [CODE] Dim dt As New DataTable() SQLStr = "SELECT FautyScanTbl.Model, FautyScanTbl.Version, FautyScanTbl.WIP, FautyScanTbl.ScanNo, FautyScanTbl.LotSize, FautyScanTbl.SerialNo, FautyScanTbl.PIC," & _ "SerialNoTbl.SetWeight, SerialNoTbl.AccesWeight, SerialNoTbl.pdmid, ScannedPartNoTbl.ScannedTime " & _ "FROM FautyScanTbl LEFT OUTER JOIN " … |
| | I have a list box where the user can add choices depending on what items they want active in the database but I cannot figure out how loop through this listbox to update the items. Any ideas? Visual Studio 2010 [CODE] Dim lstitem As String For i = 1 To … |
 | Hi please help me with this problem i really need it those kind hearted programmers out there please help me :) thanks |
| | Hi Guys, I have little problem to open any url link from my application i have placed a textbox and a button on the screen. what i want is any url which i write in the textbox and when i press the button automatically that url would open in the …  |
| | I was looking for a piece of code to show all users logged on to my system. What I mean by that is: only 1 person is ever truly logged in at my house, but there are sometimes other users "logged in" with programs running under their account. This is … |
| | Hi i am using .net 2.0 & a window application which is connected to sql server there is checkbox in the application. i want to bind the checkbox with database field which is bit type 1 or 0 please tell how to ? thanks in advance |
| | Hi I would like to get the connection string for both 2003 excel (*.xls) and 2007 excel (*.xlsx). I want to read both files depends upon the selection. When I was using this code [CODE] Dim cn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & a_sFilepath & ";Extended Properties= Excel 8.0;HDR=YES;") [/CODE] I … |
| | I am currently using microsoft access 2007 and vb.net 2008. The problem senario is this: I have a database-table that contains two columns, items, and the price of each item. I tried to drag this table to the form as a checkbox tool, but only one checkbox1 was diplayed. The …  |
| | hi, I am from c# field and now are doing a project using VB, I wants to ask about question as below: 1) private static DataSet ds; I wants to convert the C# codes above to VB syntax, but VB seems like don't have equivalent keywords of "static"(Correct me if … |
| | i am writing a vb.net program which gets a c program as an input and checks it for errors,now i want my program to skip the comments in the c program,i have written some code but its not working pls tell me where i have gone wrong,or if u have … |
| | Hi, I am creating a text file using a save file dialog and copying the path to the text box which file is used to write from vb.net. when i try to write i get an error "The process cannot access the file '....fileName.txt' because it is being used by … |
| | can anyone can help how to create a live search in vb.net 2008 using combo box. example when i try to search a name then a press a then there should be a drop-down with a list of suggestions of name. here is my code [CODE] Private Sub ComboBox4_SelectedIndexChanged(ByVal sender … |
| | Hi. I need to fill some field on webpage in my webbrowser . This field has not got ID and I can not use [CODE]WB1.Document.getelementbyid("dsdsfsda").innertext = "dsd"[/CODE] Specyfically I need to fill "E-mail" field like at Google Adword registration : [URL="https://www.google.com/accounts/ServiceLogin?service=adwords&hl=pl-PL<mpl=signup&passive=false&ifr=false&alwf=true&continue=https://adwords.google.com/um/SignupToken&app=Signup&sourceid=awo&subid=emea-pl-ha-bk_awo&medium=ha"]https://www.google.com/accounts/ServiceLogin?service=adwords&hl=pl-PL<mpl=signup&passive=false&ifr=false&alwf=true&continue=https://adwords.google.com/um/SignupToken&app=Signup&sourceid=awo&subid=emea-pl-ha-bk_awo&medium=ha [/URL] Can you help me with this ? I … |
| | Hi All, Can anyone throw idea to make the form as Resolution Independent? Thanks.. |
| | hi guys i know this is just a very simple but i do not know to get started.. im developing a loan mng't system wherein the starting application of the customer say for example today. 06/08/2011, the initial payment will be on 08/08/2011.. how am i going to that do … |
| | is it possible to call form load event on button click Following is the vb code i want same function in vb.net [CODE] Private Sub cmdaddcancel_Click() Form_Load End Sub[/CODE] Private Sub cmdaddcancel_Click() Form_Load End Sub in vb we simply call Form_Load is it possible in vb.net For eg: IN VB.net … |
| | Hope someone can help [B]I am using Visual Studio 10 Languague VB [/B] It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column … |
| | Hello, I am new i vb .I need to . Each asterisk represents $100 in sales by using for next loop. also i have a problem i do not want it to go next store until the data in the first store is correct, and so on the problem say … |
| | Alright, so I got a very unique issue. It combines a little bit of SQL, VB.net Skill, and patience. The program I am trying to make needs to be structured like this. Table 1: Estimates (Details View) Customer ID Employee ID Form Factor Problem Proposed Solution Estimate Acceptance (Boolean) Table … |
| | Can someone please tell me why the results of my query are not appearing in my console application? I have a feeling it is something wrong with the console.writeline or readline [CODE]Imports System.Data Imports System.Data.SqlClient Module Module1 Private Property Sql As String Sub Main() Dim ConnString As String = "Data … |
| | [CODE]Private Sub frmCust_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load dbSource = "Data Source=xx-B4C521B850\SQLEXPRESS;Initial Catalog=TT;Integrated Security=True" con.ConnectionString = dbSource con.Open() da.Dispose() sql = "Select * from Cust" da = New SqlClient.SqlDataAdapter(sql, con) da.Fill(ds, "Cust") da.Update(ds, "Cust") con.Close() MaxRows = ds.Tables("Cust").Rows.Count inc = -1 End Sub [/CODE] if after … |
| | i published my projects but it seems when i install the published setup, the application does not fetch data from the database yet the database is included in the published application. could anyone help me with this exception? |
| | Hi, In windows form in button click event how to export the file in a location select by showdialog & it will be delete permanently at a same time.How can i do this! because in .net it will produces error "IO Exception was unhandled" or "The process can not access … |
 | Hello I m using ComponentOne C1 Flexgrid in my project. Scenario is i have an Order Detail Table and an Order Delivery Table. when form loads grid show three rows with a checkbox in its 1st column. what i want to know is the logic i need to use is … |
| | Hi All I am working on a grid view where I have an acitve column which has radio button, user can select either yes or no for the active column. depending on the selection I am able to update the database. I am using the code below to get the … |
| | Dear Friends, I have a question in security programming. As all of us know, when we have a database with passwords or anything sensitive, we would like to encrypt it so it is not readable by other. Now I want to know, which of the method is secured or less … |
| | how can i crop an image based on the size of my picturebox? my picturebox's size mode is normal, i want to have for example, a 100 x 100 image using a 100 x 100 picture box, also i can drag the the image inside the picturebox so that i … |
| | Hi this is my first post so hello everybody, I've recently been exploring the uses of linq to use for comparisons,but really need a bit of a kickstart. Say for instance i have a listview populated with numbered names and I want to put up a message box if certain … |
| | I am working with existing VB.NET code for a Windows Application that uses StreamWriter and Serializer to output an XML document of transaction data. Code below. [COLOR="Green"] [CODE]Private TransactionFile As ProjectSchema.TransactionFile Dim Serializer As New Xml.Serialization.XmlSerializer(GetType(ProjectSchema.TransactionFile)) Dim Writer As TextWriter Dim FilePath As String Writer = New StreamWriter(FilePath) Serializer.Serialize(Writer, TransactionFile) … |
The End.