I have to create a report that lists tests that a student has taken and how they answered each question...the column header layout (roughly) looks like:
Test #1 1 2 3 4 5 Test #2 1 2 3 4 5
TestA A B C D E TestB C C B C E
The problem is that the Gridview doesn't seem to like repetitive column names and is renaming the second set of Question #s to something else.
I am struggling to show different views of gridview with database values. Here is my requirement. Database Table:I need to show one drop downlist with three values 1,2,3. If user selects 3 i Need to show a grid like belowAge,AnnualSales and Assortment are names which are coming dynamically from database.
View 2 RepliesHow do i edit the column header of the GridView control on a web form? I have added a Table to DataSource as:
Me.gvSearchBrandList.DataSource = ds.Tables(0)
in here "gvSearchBrandList" GridView control But the GridView control display the column headers of the Table in the database. But how do i edit those column name in the GridView?
I have a gridview where I need to have column names within 1 sortable pageable gridview as the same name, but when I set up the sql query as
select x as 'col', y as 'col', z as 'col'
it shows up in the gridview with autogeneratecolumns on (theres a lot of columns in the page I don't feel like not autogenning it)
and it shows up as
col
col1
col2
in the gridview but I want it to just be col, col, and col. I understand that this could cause a sorting problem without turning autogenerate columns off, but I was hoping there was some type of work around.
I have a listview with four columns (category, name, date , amount). More than one items falls in a category and I mark them with a number. ex - different kinds of pens as no.5. So, if I make an entry of five pens, five "5"s shows up in the category column. I want to display only one "5" in the category column and not to make it crowded with same numbers.
View 5 RepliesI have a DataGridView which populates from an SQL query just fine in default mode
using these table names
[firstName] [varchar](20) NOT NULL,
[lastName] [varchar](20) NOT NULL,
[code]....
I have edited the column headers and set the column names to the same values as my table names yet the data is not showing in form load I have set datagridview.AutoGenerateColumns = False I know the data is there if I delete datagridview.AutoGenerateColumns = False then the data is shown with the default headings?
VB GridView control will not allow code in the vb code file to access a data column that has its visible property set to false. When it is set to true, the data column can be accessed with no problem. Any suggestions as to how to correct this? I have looked through the documentation, text books, and I have not found anything that gave me any clue as to what the problem could be. I thought that the property was just applied to the column, not that it would remove the column from being accessible.
[Code]...
i recently posted a code that i had that i needed assistance for and it was solved it was for displaying all tables in a database.but now i have this code for showing all column names in a table i was in the process of turning it from oledb to sqlclient. GetOLedbSchema can be turned to getschema but when it comes to OleDbSchemaGuid
Public Shared Function getAllColumnNames(ByVal tblname As String) As String()
Dim com As New SqlCommand
Dim con As SqlConnection
[Code].....
i have this code for showing all column names in a table i was in the process of turning it from oledb to sqlclient. GetOLedbSchema can be turned to getschema but when it comes to OleDbSchemaGuid
Public Shared Function getAllColumnNames(ByVal tblname As String) As String()
Dim com As New SqlCommand
Dim con As SqlConnection
[Code]......
The name "Debit" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
View 5 RepliesI need to limit the amount of columns being returned from a datatable from 14 to 5 or 6. Date, Hour and 3 to 4 decimal columns. Is it possible to do something like a SQL 'Like' to specify which columns I want?
View 8 RepliesI need to get column names from SqlCommand or SqlDataReader.[code]...
View 1 RepliesSo i create a datatable from a table i can't directly view(i.e. using sql server management). I want to find the column names that are in the datatable, what would be the correct way do this?
View 3 RepliesAfter Filling a DataTable in GridView's DataSource . A column with check box Type appears but it created as read only column and I can't enable it or make it editable... even i tried .readonly = false and still can't be edited
View 1 Repliesi just got it in the internet and edited it..
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet[code]....
what I want to do is have a column name in the excel worksheet which is not included in the code..i'm getting the data from a datagridview but it only shows the data in the excel.. i also want the field name of these data to be shown..another, as you can see in the code given, the directory is fixed.. what do i have to do to choose a directory to save my work? and also, i have many gridviews and whenever i'm exporting my work to the excel worksheet, it always overwrites my work.. i want to choose the directory to save, also show the field names, and make a separate worksheet for every gridview..
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 RepliesI have a table in a Access Database that I'm loading into a VB.NET program and I want a way to get the name of each of the columns into a list of Strings. Googling has shown that this is much easier with a SQL database, but that doing so in Access is much more difficult. I came across this question Is there a query that will return all of the column names in a Microsoft Access table? Which gives a way to do it, but when I try the code it just populates my list with a bunch of "System.Collections.Generic.List'1[System.String]"
This is my adapted code.
Public Function GetColumns(ByRef database As String, ByRef table_name As String, ByRef columns As List(Of String)) As Integer
Dim com As OleDbConnection
Try
com = New OleDbConnection(database)
com.Open()
[Code] .....
My for each loop isn't printing the right string. Should be Console.WriteLine(holding)
I have A database in access2007 I want retrieve column names with sql query in my project I write below code: "select column_name from information_schema.columns where table_name ='table 1' ORDER BY ORDINAL_POSITION" but display error : Could not find file 'D:ProjectsTapco_ECMTapco_ECMTapco_ECMinDebuginformation_schema.mdb'.
View 3 RepliesIs it possible to get the column names from a DataGridViewRow object?
View 4 RepliesMy 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 RepliesI have filled a datagridview with a dataset using the following code.
Code Snippet
I'm just a frustrated noob trying to get past my first DB Program. My goal is to get relational data from different tables all ordered by a certain field..Ive noticed early on that i cannot select a column when its name has a space.[code]Now the statement i want to use is sql = "SELECT [PT.Chart Number],[PT.Last Name],[CA.Case Number] FROM Table1 AS PT INNER JOIN Table2 AS CA ON PT.Chart Number = CA.Chart Number ORDER BY PT.Chart Number"..When i Debug i get the same type of error ("... Can't find column name PT.Chart... ")I'm new to sql so i dont know if my syntax is off.
View 4 RepliesI have a datagridview with column names as dates.[code]....
View 8 RepliesI have a csv file and I import it to datagridview. Now I filter it using 2 datetimepickers. One for start and other for end.When click it must loop through the column names and must display only the columns which matches start date, range of columns between start and end date,enddate. please see the image attached.First image shows the datagridview when loaded from csv.second shows the desired output when filtered using datetimepickers.
View 1 RepliesI have mysql database with one table , and I want to show the columns' names re;taed to the table in combobox in vb 2005
this is my mysql command :
SQL1 = " select column_name from information_schema.columns where table_name='others'; "
this is my code after execute the command and store the data set in variable ( DS ) which its type is "DataSet " :
If DS.Tables(0).Columns.Count > 0 Then
For j As Integer = 0 To DS.Tables(0).Rows.Count - 1
list1.Items.Add(DS.Tables(0).Rows(0).ToString)
Next (j)
End If
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].....
Is it possible to read in an xml string and use the attributes for column naming?
For example using the following xml.
<root>
<CategoryInfo>
[code].....
I am using LINQ to SQL queries to return data in my application. However I find it is now needful for me to return the column Names. Try as I might I have been completely unable to find out how to do this on the internet.
So if my LINQ entity table has the properties (Last_Name, First_name, Middle_Name) I need to return[code]...
how can i show all column names of a table in List view.Like table name is "WO"
Wo_no
T_Date
Emp_id
I have a csv that I need to parse into a gridview in vb.net. If I do SELECT *, I get the data without issue. However, I am in a situation where I need to reference the actual column names. And problem is, I have no control over the app that generates the csv, and they make the column names enclosed in square brackets.
How the heck can I do something like this:
Dim cmdSelect As New OleDbCommand(SELECT "[name], [height] FROM myTable")
so I get a return of data?
So, in an effort to be perfectly clear: I have an app that creates a csv with the column headers [name] and [height] in a table called myTable, and for the life of me I can't figure out how to return [name] and [height] specifically.