i have datasource with stored procedure.Now my stored procedure is changed with new column .In datasource panel i click with refresh button, but i don't see new column how can i ?
View 7 RepliesIn a windows form I do have a datagridview. When a user pushes the button, the underlying datasource of the datagridview (a dataview) changes and the new content with new columns is shown. This works fine, only problem is that the header-height differs and that the datagridview does not properly display the smaller headers until I click into the first datarow of the datagridview. Simply using the .refresh()-method of the datagridview after assigning the new datasource does not seem to work.
Here is a little code-snippet showing how I assign a new datasource to the datagridview.
Dim view As DataView = myDataTable.DefaultView
With Me.MyDataGridView
.Columns.Clear()
.AutoSize = True
.DataSource = view
For Each col As DataGridViewColumn In Me.MyDataGridView.Columns
col.ReadOnly = True
Next ...
Employee emp = new Employee();
comHandledBySQt.DataSource = emp.GetDataFromTable("1");
comHandledBySQt.DisplayMember = "FirstName";
The above code displays drop list of employees first names in a combo box. I want first name and last name to be displayed. How can i do it?I tried to include two columns FirstName and LastName as below but didn't work.
comHandledBySQt.DisplayMember = "FirstName" + " " + "LastName";
I have made several changes to the columns in an Access db, such as additional columns, column type changes, etc. how do I now incorporate those changes into my datasource? Do I need to delete the datasource and create it from scratch?
View 1 RepliesI have a datagridview with its datasource binded to a List(Of T). Now i would like to sort on any of the columns.My code:
'Database access : items = List(BlogPost)
dgBlogPosts.DataSource = items
'My BlogPost Class
Public Class BlogPost
[Code]...
I use vb.net and windows form and sqlserver
I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .
Lets say i label "label1" , and 2 buttons named "button1" and "btnRefresh " [code]So , when user press the button 1 , the text will change. But what should i put inside btnRefresh to reload the forms ? and display the default label.text = "Form Load" ???
View 9 RepliesI'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
Imagine 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've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
[Code]....
Averaging columns in a table - ignoring certain columns
View 2 RepliesWhat should I use and how to use something that functions like a label box but can handle several columns and columns? Something that looks like this. [code] Name | Age | Birthday are headers and the letters are variables
View 5 RepliesI have a datatable property called prpParametersTable in a class called clsBatch. I have a procedure that sets a datatable variable called dtP equal to prpParametersTable at the beginning of the procedure. I then add three new columns to dtP.Here is my problem. When I add the three new columns to dtP my original table prpParametersTable also gets those columns added to it, why? I only want to add the three columns to dtP and not prpParametersTable. How can I do that?
Private Function prvfnc_InsertBatchParameters(ByRef cnn As SqlConnection, ByRef trans As SqlTransaction) As String
' set new columns that have BatchID, Insert DateTime, and UserID for the SQLBulkCopy method below
Dim clm As DataColumn
Dim dtP As DataTable = clsBatch.prpParametersTable
[code]....
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 RepliesCreate a membership database that has fields for title, first name, surname, address, subs renewal date and membership type (active, social, honorary or life). Make an interface that allows a user to display, sort and create records. Consider the use of drop down boxes to aid error free input.
When i add a new datasource i get to "Select database objects" page and then i get an error message. "Could not load "Microsoft.etc"", im using an access database with pre-created fields.
I cannot add data source in my window applciation;...There is no menu for me to add a new datasource.
View 8 RepliesI have a DetailsView that looks just about perfect. The only thing is, there is one field that actually gets its information from another table. It is an ID field that is linked to another table in the database and I was hoping that there was some way to get that one field in the DetailsView to pull the information from the other table.
Is there a way to maybe add a + (plus sign) next to the PicklistID and then have it show the results of the other query? (SELECT TEXT FROM PICKLIST WHERE PicklistID = @PicklistID???)
UPDATE 1/11/12: The PICKLISTID in the table PICKLIST is not unique or a primary key so I cannot reference it from the SURVEY table. Is there a way to give these 2 columns a relationship so that I can just change my SELECT statement in my DetailsView to include the PICKLISTID?
UPDATE 1/23/12: I'm still stuck on this. I am not getting how to make this work at all.
[Code]...
have 3 dropdown list one has pre set values and my post back works the other 2 has the data from the db when i try using post back on them i don't get anything in my grid view.
<asp:DropDownList ID="ddlname" runat="server" DataSourceID="SqlDataSource1" DataTextField="Venue_Name" DataValueField="Venue_Name" AppendDataBoundItems="True" AutoPostBack="True"> <asp:ListItem Text="All" Value="All" Selected="True"></asp:ListItem> </asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
[Code]...
how do you add information from another datasource into a cell in a data grid which has the relevant information i.e order_bindingsource grid which has the information order id, item id, quantity and cost per item.
The item id I have linked to the Productbindingsource but I also need the information to be shown cost per item which is in data source products.The item id is a drop down box with the items displayed what I need is when an item is selected I need the price to show up in the cost per item box.
I am trying to create an arrayList of people. The variables, or arrays are; first name, last name, age, DOB. I am wanting to load all that into one arrayList and dataBind it so it would look like [code] Loading it into an ASP DataList. SO Fname + Lname + age + DOB are loaded on the same line/index. Not sure how to go about this. I'm sure it's an index issue..but not sure the thought process to even begin to load these elements into the "0" element, then the "1" and so on. Not puling the information from a database, just preset arrays/arrayList. ANY suggestions? ( I have it so it is dataBound to one arrayList entry as in [code] This works fine. But if I wanted to add the last name to the first name on the same line...that's were I am not seeing the connection.
View 5 RepliesHow to declare a datasource?
View 1 RepliesIn one of my projects, I have this line of code that works:
Dim newCustomersRow As EyeBaseDataSet.HistoryRow
newCustomersRow = EyeBaseDataSet.History.NewHistoryRow()
In this new project I'm trying to get the same thing going, but I can't use the Row definition. I type the data set name and don't get an option for the tableRow. I don't know how else to word this, but I need to know what I have to add to the project to give me that control. In the working project it says "Class HistoryRow" and I went to the definition and it took me to the designer and showed me a Partial Public Class with System.Data.DataRow.
How can I set the datasource of an ItemTemplate? Right now I have one that is wrapped by a datarepeater and that is how I databind to it.
<asp:Repeater ID="rptTotal" runat="server">
<ItemTemplate>
<tr>
[Code]....
I have a datalist. I have datatable in javascript. I want to set datatable as datasource to datalist in javascript
View 1 RepliesI have a SQL Compact Database that I've added in my Data Sources. I then have a DataGridView which is filled with all the records in a particular Data Set.There's a button on the same form as the DataGridView that opens another form, which allows the user to add a new row (record) to the DataSet. Currently however, the fields on this form are not related to the columns in the Data Source in any way.
View 6 RepliesI have a datagridview and a column which is DataGridViewComboBoxCell
I want to set datasource for that DataGridViewComboBoxCell?
I list folders in my combobox but I'm trying to sort the folders alphabetically and then numerically or vice versa.
My coding to populate my combobox is
With Combobox1.DataSource =
(From folder In New IO.DirectoryInfo("Path").GetDirectories
Select (folder.Name)
).ToArray
End With
Is it possible to sort the combobox?
I have folders that are numbered like 1, 50, 115, 189 etc.
These should display as
1
50
115
189
however they display as
1
115
189
50