i want prevent user order column.i have a datagridview , it has allowuserordercolumns properties and it is set to false. But i didnt see so. i still order column.how can i prevent user ordering column.
View 6 RepliesIn my datagridview I have 3 columns, lets say Column1, 2, 3.
Column1 is Column2 / Column3.
Problem I have is I'm trying to prevent an error if the user types "0" into Column 2 or 3. I can prevent against it dividing by null or a letter by the following codes:
[Code].....
I have a databound Datagridview. The DGV is bound to a datatable of a strongly typed DataSet created using the wizard. Is there any way to re order the columns before displaying them eg: the Columns are displayed in the DGV in this other Col4, Col6, Col3, Col1,Col5, Col2
But I want to it to show as Col1, Col2, col3, Col4, Col5, Col6?
I realise that the display order followed the Column order in the database table and by extension, the datatable. I have re-arranged the columns in the Database but the Datatable still retains the old order.
My question is how best to avoid SQL Injection with the method I am currently using.EDIT (Reasoning): There are many of columns in a number of tables (a number which grows (only) and is maintained elsewhere). I need a method of allowing the user to decide which (predefined) column they want to query (and if necessary apply string functions to). The query itself is far too complex for the user to write themselves, nor do they have access to the db. There are 1000's of users with varying requirements and I need to remain as flexible as possible - I shouldn't have to revisit the code unless the main query needs to change - Also, there is no way of knowing what conditions the user will need to use
View 2 RepliesHere is the code:
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
[Code]...
I have this strange phenomena in which I load an Excel file. The Excel file consists of data arrange in columns having a column header. Once some computation is performed and another file is loaded into the datagrid, the column order of the new file changes .i.e the column header is changes its position from its original Excel file.
View 2 RepliesHow do i change the column order of a datagridview in code.
View 1 RepliesI have a DataGridView bound to a list of business objects:
Dim template As New IncidentTemplate
Dim temps As List(Of IncidentTemplate) = template.LoadAll
Dim bs As New BindingSource
[code].....
I have the following code to get the column names from my Microsoft Access database.THE PROBLEM is that the stupid thing orders it alphabetically for me. How do I get it to put the columns in order the way they are in the database?[code]I've also tried a different approach with a string array and for loop to "make it" go to the beginning, but proves my point that its stupid enough to order it for me.
View 3 RepliesSame thing I am trying to do in the linq order by. It's not working.I have column that is defined in the data base as string (Varchar) and I need to cast/convert it to integer before I need to sort it.What should be my linq statement?
View 1 RepliesI have a listview1 with two columns Name and Age. This code when I click on a listview item it is higlited and then i click on textbox1 it will remove the row and place the text in textbox1 and textbox2. Then when I double click on textbox1, it will add the text back into listview1 at the bottom of the list. I want to place the two columns at the same place it came out of. EXAMPLE: click on Tom - textbox1 has Tom in it and textbox2 has 2 in it. When I double click on Tom then it adds both Tom and 2 in the listview at the bottom
[Code]...
Sometimes I select a value in my Combobox by hand, and sometimes the value to show is chosen elsewhere in my program logic. I want to carry out a certain action only when I have chosen a value by hand, and not when the value is changed by the program. For this reason I use the DropDownClosed event (and not, for example, SelectedValueChanged or SelectedIndexChanged). This works fine, but if I set AutoCompleteMode of my Combobox to Suggest, selecting a value from the suggested list doesn't fire the DropDownClosed event (perhaps logical, as the actual drop down list doesn't actually open).
View 2 RepliesI am using a modal form with a datagridview in order to populate textboxes on a parent form. The datagridview is bound to an anonymous type resulting from a linq query, which varies depending on the textbox control whose keypress event is called. I always want to display a key value in column 0 of the datagridview (along with a variable number of additional columns), and then use that key value once the user selects a row.
However, when setting an anonymous type from a linq query as the datasource for a datagridview control, the columns are indexed alphabetically rather than in the sequence selected in the query. This requires setting the displayindex as a workaround, and then keeping track of which column contains my key value. I read elsewhere that this was something fixed in VS2008 SP1, but I still encounter the behavior.
It is not so hard to get the field names from a database via GetOleDbSchemaTable and OleDbSchemaGuid.Columns. It works fine. The field names come i alphabetical order though. I really need them in the correct field no order.
Used code:
connection.Open()
Dim schemaTable As DataTable = _
connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, tblname, Nothing})
[Code].....
I'm retooling an app, and condensing my queries down to one, but to do so, I would like to move the columns for better presentation. I am reporting on errors for particlular equipment, and the user may want to get equipment by errors or errors by equipment. Is there any way to change column order?
View 5 RepliesI have an unbound datagridview that has 2 columns. Both columns contain numeric data only and will only go to 55 in count. How do you sort a Datagridview Column in collating sequence? I basically want to sort from 55 down to 1 and 1 to 55 in their respective numerical order.
View 3 RepliesI'm writing a program on CD Collection. My problem is write a code that prevents a user to enter a CD collection name that is already stored in the filename.txt.
The rest of my program is okay, but the only problem is something do with btnAdd control.
Here's my whole program:
Option Explicit On
Option Strict On
Option Infer Off
[Code].....
i have a form that needs to be maximized in vb.net. i dont want the user to be able to change its size or move it around.
View 5 RepliesI am writing an application that needs to be running all the time and I don't want the user to be able to close it. I don't want to hide the process from Task Manager. All I need is that when the user tries to terminate the process, he has to enter a password.
View 9 RepliesI have the following settings:
ControlBox : False
WindowState: Maximized
Because I want the user to have a full screen application that they cannot close without using my Exit menu. The problem is, they can simply grab the title bar of the form and drag it, exposing the desktop!
I have a Textbox in which the user types in a name for a folder to be created. However, Windows does not allow the followin chars:
[Code]...
can FileSystemWatcher prevent the user to delete a file ?
View 3 RepliesI have several forms that have a DataGridView object in them. I recently discovered the AllowUserToOrderColumns attribute. I set it to true and I can reorder the columns at will. The problem is that the order for these columns is lost once the form is closed. Ok, how do you save the order for these columns and then restore them to the form once it has been reopened?
View 4 RepliesI have a DGV.It has some columns.The columns are in the correct order e.g. 1,2,3,4 at design time.When I start debugging and then come back to VS, the order of the columns have changed and I have to put them back in the correct order everytime.After some testing I have realised it only occurs if
1) I make a change on the form that holds the DGV
2)Leave the form open in VS while I play the application ie. debug.
i have a datagridview with three columns. i set the first column to visible=false, so the user can only see two columns.when the user presses the tab key in the first visible column -- column(1), i want to ignore column(2) so that the user only tabs through the rows in column(1)i can't get it to work. it will always tabs through the rows in column(2) even if i use the column name.
[code]...
How can I prevent a single user from logging in to my asp.net website from more than one computer at the same time?I have tried using the application server side state managenment but it is not work properly.
View 1 Replieswhat is code that prevent user to given number less than 8 in the text box. If the user give less then 8 number then message box box will appear which show Minimum Number is 8. Here is my code
Private Sub btnregister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnregister.Click
If TELEPHONETextBox.Text.Trim.Length = 0 Then
MsgBox("Please Enter Phone Number", MsgBoxStyle.Question)
Me.TELEPHONETextBox.Focus()
[code].....
How do I prevent the user from resizing my program during run-time? I know how to disable the max and min buttons at the top, but I can still click the edge and drag it to resize my program. I want to be able to disable this feature so my program stays the same size the whole time.
View 2 RepliesPreferably without turning the "Enabled" property to false, because I still need to output text from it.
I made a custom control in which there is a textbox but I want it used only as an output control, for showing text and stuff. Problem is that as soon as my form opens up the focus is turned to the textbox and I cannot catch my keyboard events on the form anymore(since the other controls are pictureboxes). I need a way to make this box "unclickable" or any way in which it is impossible to attribute the focus.[url]...
I have developed an application in VB.NET. It has 20 forms. All 20 can be opened from a menu strip control. The user should be able to open only one form at a time. How might
View 3 Replies