I am using this method to create a csv file using vb.net.
protected void btnExportCSV_Click(object sender, EventArgs e)
{
Response.Clear();
[Code]...
This code is creating csv file. But i dont want any extra column in csv.
I am stucked at the situation where I need to disable few columns of a each row ,except newly added row.That is I have 10 columns in grid and I want first three columns that are binded from the rows coming from db as disabled or read-only, rest are editable. if I add new row then all columns of new row must be enabled until and unless it is saved.I dont have any DataKey or Primary key for my existing row or new row. I have to check for some boolean values like IsNewRow. [code] but the problem is that if i click on disabled/readonly rows then newly added rows also gets disabled., which i dont want
View 1 RepliesHow to use built-in classes in VB.net for sorting the following number in the desired order?
Number: 5,10,24,9
Desired order: 5, 9, 10, 24
i would like to ask if how do i create a column of picturebox.. something like a thumbnail, with a specified number of columns inside a form.. the number of picturebox depends on a variable.. has anyone done this?something likeimage1 image2 image3image4 image5 image6
View 2 RepliesI am trying to make a application that will bind User Desired Keys to User Desired Text. This is what I have done so far, it is not very much but it keeps crashing and visual basic is not telling me anything is wrong with it. I basically just want the user to be able to select a hotkey from a combobox. [code]
View 3 RepliesImagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?
I designed a advanced music player, everything is ok, I create the setup, install my computer. Here is my problem, there is a mp3 file at my desktop, right click, Open with, Select my program. But, I realise that I didn't write any code for that. Shortly, I want to when double click on mp3 file. And it should be opened with my program..
View 4 RepliesI have a class that add extra information about a column for linq2sql (see code below) right now, I have to explicitly tell what column I want that info on, how would you put that code with a loop on every column in every table from a dbml file? I was doing my test on a very very small DB, now I have to implement it on a much more bigger database and I really don't want to do it manually for every tables/columns it will take hours.
how it's being used:
Partial Class Contact ''contact is a table inside a dbml file.
Private _ContactIDColumn As ExtraColumnInfo
Private _ContactNameColumn As ExtraColumnInfo
Private _ContactEmailColumn As ExtraColumnInfo
[Code]....
Using the ListBox1 properties I tried to set the number of columns to 2 but could not do it.
View 2 RepliesHow to create an error log system, which will log all errors(caused in my app) to a text file with line number, sub/function in which the error occurred, error details, etc. ?
View 11 RepliesHow do I specify that I want two columns on a checkboxlist?Below is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim di As New IO.DirectoryInfo("\bk00app0001Images")
Dim imageArray As IO.FileInfo() = di.GetFiles()
[code]....
How do i get the number of columns in a sqlDataReader after executing sql statement ?
View 4 RepliesHow can i get the number of columns in A DataRow type?
View 9 RepliesI've got a question about Listboxes in Visual Basic 2008 Express. I have a fair bit of experience with Office (both 2003 and 2007) and use the listbox in office all the time. The thing I like most about it is the ability to set the number of columns so I can have a string for the user to see and a second column of 0 width that holds my ref number.
So when I needed to do the same thing in VB 2008 Express I grabed the Listbox control and.....hit a brick wall. As far as I can find out from the help files and searching the web the Listbox control only shows one column really. Ok so it might wrap to a second column to save the user having to scroll but its still basically one column. There seems to be no way of having something like in Office.
I know I have no code, but I don't have any code for this. I'm just asking in case I'm missing a control or something obvious. Hell at this point I'm almost tempted to create my own Listbox control that acts the way I need but thought I'd ask before heading down that route.
I'm working with Microsoft Word and trying to generate a table with headings that may span one to three columns. I'm having trouble figuring out how to do this. The table should look something like the following:Counters
Times (hrs)
Flows (gals)
Day
Regens
Well Starts
[Code]...
To get it to look this way, I'm not exactly sure what to do from VB.
i wanted to create a random number generator that iterates through a series of number between an upper and lower bound. say between 1 and 100. Basically I want the number generator to pick the numbers randomly and then display them until all 100 numbers are picked without any duplicates. so thats easy I can code that. But what I don't know is how to show those numbers in the order they are generated on a windows form. So i have basically a variable that I will let be changed 100 times (or however many times I want, I don't want their to be a size constraint just using 100 as an example) and each time the number is generated I want it displayed on screen (in a list or something not sure what. Hopefully some type of scrollable list) and each successive number also to be displayed in same format beneath it so that I can see the list in its entirety. What type of form control do i use for that? I could do messagebox.show for each iteration but then user is required to hit ok after each iteration and that would obviously be a bad idea if user selected a large number to work through. Anyways, code isn't exactly necessary just point me in the right direction, i.e.what control (if any) to use.how to format the change in data?
View 7 RepliesI need to have multiple lines in a cell, so I use DataGridViewTextBoxColumn.DefaultCellStyle.WrapMode =DataGridViewTriState.True. I add columns (datagridviewtextboxcolumn) in designer. Then bound datagridview to a table which has exact the same columns as datagridview. Then I find that datagridview has duplicate columns: the first column is empty (which I guess is added through designer), the second column is filled with data from table. My question is how to correctly allow multi-lines and bound to a table at the same time?
In Designer
Friend WithEvents DGV As New System.Windows.Forms.DataGridView
Friend WithEvents columnClient As System.Windows.Forms.DataGridViewTextBoxColumn
Friend WithEvents columnAccount As System.Windows.Forms.DataGridViewTextBoxColumn
Me.DGV.Columns.AddRange(New System.Windows.Forms.DataGridViewColumn()
[Code].....
I have a datagirdview which I need to process.. I have more than 50000 rows and 200 columns in it. DataGridView accepts columnindex and rowindex only in the form of integer. Is there any way in which I can use long instead of integer.
View 2 RepliesI've got a number of columns the user can sort by (Name, County, Active) and that's easy but messy. Looks something like this...
Select Case e.SortExpression
Case "Name"
If (isDescending) Then
[CODE]...
What I would LIKE to do, is something more ... like this
Private Function SortThatList(ByVal listOfStuff As List(Of Stuff), ByVal isDescending As Boolean, ByVal expression As Func(Of Stuff)) As List(Of Stuff)
If (isDescending) Then
[CODE]...
But it doesn't like the datatype (Of TKey) ... I've tired Func(Of stuff, boolean) (got something in c# that works nicely like that) but can't seem to get this one to do what I want.What's the magic syntax?
I am trying to program a noise reduction algorithm that works with a set of datapoints in a VB.NET DataTable after being helped with my other question. Basically, I want to take two integers, a coordinate value (yCoord for example) and a threshold smoothing value (NoiseThresh), and take the average of the values in the range of (yCoord - NoiseThresh, yCoord + NoiseThresh) and store that number into an array. I'd repeat that process for each column (in this example) and end up with a one-dimensional array of average values. My questions are:
1) Did anything I just say make any sense ;), and
2) Can anyone help me with the code? I've got very little experience working with databases.
[Code]...
I know how to create an array and loop through it normally - but what if I need a multi-column array. e.g. usually I might do something like:
For Each row in NameofArray
Dim name as String = row
Response.Write("Hello " & name & "!")
Next
But what if I want to do something like:
For Each row in NameofArray
Dim name as String = row.name
Dim age as Integer = row.age
Response.Write("Hello " & name & "! You are " & age & " years old!"
Next
If this isn't possible with an array?
Im trying to add data into a new column I have created in my gridview.[code]...
Now I need to go in and add data for the rows below the column. I have seen ppl saying I need to set it equal to a datafield but how do I create a datafield from scratch then?
I'm completely new to Visual Basic, so please be 'gentle' with me.I came up with an idea of a simple app (apps), which is almost done. I'm using Visual Basic Studio Express 2010.What I want to do is (well partially done already):One app (Windows Forms Application) launches another app. I'm using Shell command to start the other one.The other one is located on a network drive, but opens fine. The problem is that the another one (the second one) supposed to start a BATCH file (*.bat) in the same folder where the app is located, but it seems to be running in the same folder where the first app is located.In other words. App1 is C:my appmyprogram1.exe it starts App2 which is on a network drive, i.e.\mynetworkmynetwork foldermy program2.exe. Then 'myprogram2.exe' starts (suppose to) a batch file in the same folder \mynetworkmynetworkfolder, but instead it is trying to look for it in C:myapp . How do I tell the program2.exe to search for the batch file in the same folder where its located?
View 3 RepliesI'm automating a download,and I know the URL to the download page. Well, not exactly. This URL is indeed what I need to use, but the website redirects it to the REAL download page. Unfortunately the redirect only happens if I do an exit sub. That is to say, if I do a loop sleeping one second per iteration, the loop goes on forever waiting for the redirect. But if I branch out of the loop by inserting an Exit Sub in break mode, I can see the redirect occur onscreen. (I can watch the current page in the web browser transition to the desired download page). The trouble of course is that I don't WANT to do an Exit Sub at that point, so what's the solution? Do I need to call Browser.Navigate on a background thread?
View 4 Repliesi've create a datagridview with two columns, one textbox and the other checkboxes. The chekcbox column has a check box in column header aswell.
When i resize each column the checkbox column speciallly the checkbox in the column header, does not align with the checkbox column, it even goes in the textbox column as well. How do i fix this column resize issue?
I am using data grid view in Windows Form standalone application to display items as excel spread sheet in VB.NET. I got a table named CostTypes with column names [CostTypeID, CostType] and values [1,External] and [2,Internal] (These are constant but more values can be added to table).
I want to create columns with names of the values[External , Internal] in DataGridView. If I use databiding directly I get columns [CostTypeID,CostType] which is not what I am looking for.
I have text file that is saved as comma delimited. There are 3 columns with x number of rows. I cannot seem to figure out how to create an array that will store all three columns with the variable intProductArray as the length of the array. I have been opening the file with only one column and putting it into a textbox and using the lines of the textbox as the variable for length. I cannot figure out the array for all 3 columns.
Private Sub btnChoose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnChoose.Click
Dim myFileDlog As New OpenFileDialog()
myFileDlog.InitialDirectory = "c:"
myFileDlog.Filter = "All Files (*.*)|*.*" & _
[Code] .....
On runtime about the number of columns to show (mainly remove columns that are available and then shift the remaining columns).. I can view the reports in a report viewer normally all I need is to be able to edit the columns in run time.
View 1 RepliesI have a Datatable consisting of columns with Latitude and longitude I want to be able to pass through each of those values in each row into an array that can then be passed through a function which gets the distance between each row and a static. In short I am trying to get distance between one location and various others that reside in a datatable that will vary in size. Right now with this existing code I am getting 6 different locations into an array:
HTML
Public Function GetCoords() As Coord()
Dim myCoords() As Coord
myCoords(0).Lat1 = CDbl(list1_Lat.Text)
myCoords(0).Lon1 = CDbl(List1_Lon.Text)
[Code] .....
If I am on the right track I think I need to create a new array that will accept Lat and Lon from each row in my Datatable? My end goal is to be able to find properties within a certain distance of a property. In other words "return all properties that are within .25 miles of 12 Maple Street". I thought if I had Lat and Lon of a certain property there would be a formula that would give me the max and min Lat and Lon to be within a .25 mile radius. I have searched for how to get a radius, but didnt come up with anything I could comprehend. So instead I thought I would just get each properties (row) return the distance in a new column then loop through the table to return properties within the desired distance .25 miles etc...
I want to use webbrowser to go to a web site. This web site has three possible screens that I can get when I try to visit:
(1) A fresh login page, where it does not seem to know me and asks my name and password
(2) The main page of the site, with me logged in from my last visit
(3) A screen that says something like: "Thanks for visiting and logging out. click here to log back in."
I want to make it so that the webbrowser 1 ALWAYS is able to get to the first kind of page. When I have webbrowser1 navigate to the specified URL I want it to *not* be redirected to already being logged in from last time and to *not* be redirected to the third kind of page.
I am trying to make a program so that it goes to the site, enters my username and password, and clicks the "login" button. This is getting messed up because it does not always go to the first kind of page, and, actually, most often redirects to the second or third screens, to my aggravation!
Is there some command I can use with webbrowser and my visual basic 10 program to make it so the webbrowser is NOT redirected without me wanting it to be, so that it always goes into the "fresh" login page?