i have a datagridview control called videoplaylisttable it shows data from ideoplaylistdataset.videoplaylistit has two columns.how do i make it so that when the user clicks on a cell, in any column, the entire row gets highlighted and not just the single cell
View 1 RepliesI know that the user can select an entire row if they want to, however if they select just 1 cell, I want the entire row that that cell is in to be selected, so that the user cannot just select 1 cell, they can only select a row, no matter where they click in the table.
View 3 RepliesI wanted to select the entire line/row in the RichTextBox, where currently the cursor is. How should I do it ?The code should be paste in command button 'cmdSelect'
View 1 RepliesI am trying to read an entire database in to a dataset. I have this so far..
[Code]...
This is the only code I could find and it doesnt work:
Private Sub DataGridView1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseUp
Dim pt = New Point(e.X, e.Y)
[Code]....
I need to filter a measurements table that consists of 63 measurement objects that may or may not be tested more then once. The entries are put in a Batch table on a SQL server in the following fashion:
ID: | Serie | Test object | Min Amps | Max Amps | OK?
DateTime| String | Integer | Double | Double | Boolean
So there may be multiple entries in my database with the same series and testobject number but with (slightly) different results.
Currently I just select: SELECT * FROM Measurements WHERE Serie = 'XXXX' and use a datareader object to fill a datatable and then I let loose a routine on it that will either: Get the last result that produced a good measurement, so OK = 1 and max ID. Or the last result that produced a bad measurement if there are no good ones. I then end up with a list of 63 either good or bad measurement objects with the last good result, and if there isn't one then the last bad result.
Now I know that SQL is quite powerfull and I suppose that it must be possible to directly query for these results without a programatical routine re-filtering the results. I suppose it's like Selecting within a select statement..
What iam trying to do is selecting rows on multiple column values. But the statement below doesn't preform like i thought it would...
Code:
Select Distinct Variable From TableName Where (ColumnA Like"%AAA%") And (ColumnA Like"%BBB%")
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
How to extract all URL from entire Web Site using c# or vb.net.I know how to extract URL from Web Page but i want to get all URL from entire web site. .
View 2 RepliesI am writing a program that pulls data from a database.For each table that I pull data from, I write a series of If Than Else Statments to catch any null values and assign Nothing so as not to throw an exception.Is there a way to check against a DBNull value without writing an If THan Else Statment for each column I am pulling from the database?
View 7 RepliesHow do I copy an entire old project to a new project? Can I use the Visual Studio?
I need the old project to stay on my pc and the new project to go into a production environment with
different database connections, subdirectories, etc.
I want to know if it is possible to click in one cell, and the entire row be selected.
View 6 Repliessaving data into another form in my program. so when this code saves data into desireddb table, i would like to delete immediately from this db table once it saves data into the desired db table.
Private
Sub Button1_Click(ByVal sender
As System.Object, ByVal e
As System.EventArgs) Handles Button1.Click
[code]....
I need to disable every control on my Form so that the user can not click or press any key that will change values of listboxes and other controls on the form. I need to be able to lock the whole Form like this because as part of the project I have to print the form 3times with 3 different colors and the only way I've been able to get it to work is with a timer. So for about 3 seconds the form is changing colors and printing itself, so in between that time the user could accidantely click something and change a value on the form when all three prints should be of the same form, only difference is in the color.I can't use disable as that will make all the controls look faded and messed up, I need a clean way to prevent anything from being changed.
View 39 RepliesI'm using the code below to get a screenshot of the entire screen.
VB.NET
Dim b As New Bitmap(Me.Width, _
Me.Height, _
[Code]....
But I need to edit it so that it only takes the a screenshot of my form. I'm not sure how to pass the absolute coordinates of my form's top most left corner and it's bottom most right corner.
how to copy an entire row from one bindingsource to another?
View 1 Replieshow do you delete entire directories?
View 4 RepliesI am trying to make a simple program that generates random musical notes, and for the most part, I'm done, but at the end, I'm left with an array full of notes that I'm not sure what to do with. I want to output the notes to a label, and the array length is variable. I really have no idea what to do. I am trying to display the array OutputNotes:
[Code]...
i am still new to VB, and need a little help. We have an application that runs on what I believe is VB2005. I am able to open the main .dll in VB2010, and can modify the forms, etc, and they will show the changes in the applications, but is there any way to change the current forms to the nicer looking forms in VB 2010? I guess I could just rebuild the entire .dll in the new version, but was hoping not to have to do that.
View 3 Repliesi have a form with textboxes such as First name, surname, phone number in and each row has an auto number assigned to it. that auto number is the customers reference number. basically i want to be able to enter a reference number into a text box and when a button is clicked i want to extract all the name and phone number from the database and put them into the relevant text boxes. how would i go about doing this?
View 7 RepliesI have an application with roughly a dozen forms and I am attempting to change the font property for each form when a button is clicked on the main form.I have found the my.forms namespace and I am able to change the font there. But I need to be able to add more forms later without having to change the code each time Is there a way to iterate through a namespace and manipulate a subclasses properties?
View 3 Repliesget the whole and same content of any file i uploaded, for my editing purposes in my editor w/c retrieves file from the database. i.e of files are ".doc and .txt"and by the way what i meant by same content is the whole same appearance of my .doc or .txt file i.e "if the text is bold, forecolor is red and etc.."
i successfully established a file upload and a function to store it in a database... but what i'm missing is the whole and same content of the file. Another thing is i don't want the file to be saved in a local folder or somewhere..i just want it to be save directly to my database Below is my sample code of trying to retrieve the content.. but it is an error when you run..
Private Sub cmdSave_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If filMyFile.PostedFile IsNot Nothing Then
Dim fs As FileStream
[code]....
Is it possible with LINQ to SQL to search the entire database (obviously only the parts that are mapped in the .dbml file) for a string match? I'm trying to write a function that will take a string of "Search Term" and search all mapped entities and return a List(Of Object) that can contain a mixture of entities i.e. if I have a table "Foo" and table "Bar" and search for "wibble", if there is a row in "Foo" and one in "Bar" that contain "wibble" i would like to return a List(Of Object) that contains a "Foo" object and a "Bar" object.
View 5 RepliesI was wondering if anyone new of a C# to VB.NET convertor that can convert an entire project at once. I found the vbconversions VB.NET to C# convertor [URL].. but they do not have a program that goes the other way (which is what I need).
I would say that there would be something out there that can do it, if anyone knows of anything please let me know asap as I need this for work.
I would like to know if there is any way that I can rename an entire project / solution.I created a project called say WindowsApp1, and then realized that I do not want that name, I'd like to rename it to something else.So I'd like to rename all references to WindowsApp1 throughout the project to another name.
View 9 Repliesthis code get the data from the sql where the name = @word which is the variablecontaining the word to search for my problem is i want to check all the table columns not only one column ? is it doable ?
Public Function Search(ByVal word As String) As DataTable
Dim Dt As New DataTable
Dim Adp As New SqlDataAdapter
[code].....
I'd just like to know how to clear a listbox of its entire contents. I know in VB6 it was something along the line of 'lstBox.Clear', but that doesn't seem to be the case in this new version of VB.
View 3 RepliesI am trying to copy the entire drive contents of a CF card to another location. For example:
Source Location:
e:DCIM
Destination Location:
X:2010-06-01
What I want to do:
- Copy E:*.* to Destination
- The original file structure can stay the same. I want to copy everything from the root of the Source Drive
I can copy the contents if I set source string to e:DCIM.. But I'm concerned that if I get something that doesn't have the first directory (DCIM) it's going to error.
I have a DataGridViewCheckBoxColumn and I am trying not to allow more than one checked boxes in the column. So after one is checked, when user tries to check another one, i want to prevent that and not have more than one checked box in entire column. I used whole bunch of events but nothing is helping me... Some time it seems working but if i double click the checkbox, it puts the checkbox... sometime it puts the check mark on my third click (not on first, not on second but on third...) What i want is only one checked box and if use tries to click another one don't let it happen.
View 5 RepliesGot to say that i was struggling this code for saving data into another form in my program. so when this code saves data into desired db table, i would like to delete immediately from this db table once it saves data into the desired db table.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using conn As New System.Data.SqlClient.SqlConnection("Data Source=MUSTAFAMUSTAFA;Initial Catalog=employment;User ID=sa;Password=123")
[Code]....
So form gets retreived data from another form then save it to another db table then, i want to delete what is appearing in the current form. i mean, the above code once it saves data, it then has to delete immediately.
For example, once i click confirm then saves it, then confirm button has to also delete it from this db table because i already moved the data.