[datasource] Forum Topics

having a problem with my databinding.I created a table adapter for a table from my database, it has 3 columns and when i preview the data it is all ok. I want to get a datagridview with the columns by dragging the datasource table on to the form but no …

I am desperately trying to add a DataGridViewComboBoxColumn to my DataGridView programatically. Here is the Code I've got so far. DataTable dt = new DataTable(); dt = _userBL.getUsersTable().DefaultView.ToTable(false, "Person_ID", "FirstName", "LastName", "Title", "Username"); dataGridView1.DataSource = dt; DataGridViewComboBoxColumn ComboBoxCell = new DataGridViewComboBoxColumn(); ComboBoxCell.Name = "State"; ComboBoxCell.ValueMember = "State";//ComboBoxCell.DisplayMember = "State"; ComboBoxCell.DisplayMember …

how to configure oracle datasource in jboss 5.0 ?? and then how can I use this datasource in hibernate.cfg.xml file to make connection to the database ?

HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable …

Imports System.Data.SqlClient Imports System Imports System.Data Imports System.Collections Imports System.Windows.Forms Imports System.Resources Imports System.Data.OleDb Imports System.Drawing Imports System.Net.Mail Imports System.Configuration Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports System.Web.UI.HtmlControls Public Class Form1 Inherits System.Windows.Forms.Form Dim counter As Int32 = 0 Private Sub Form1_Load(ByVal sender As System.Object, ByVal …

I have a datasource on my page, the select query of which creates a pivot table. The complexity is that the columns in the pivot are determined by records in another table (the users table). So I have to use a prepared statement to build and execute the pivot query, …

I asked this basic question a couple of days ago but I probably didn't include enough information in my question. Sorry for reposting, but I am really lost here. This is a web application in VB.net connecting to an Access database on a 2003 server. The problem: I have a …

Okay, So I have an application which uses MSSQL server as datasource. Is there anyways I can avoid using any database server and use a local file as datasource ? If yes , what are options. AND HOW ? PS: this is very important guys. please help. THANK YOU.

I was just about to post asking how to do this when I stumbled across the solution. All my research on the web suggests that the only way is to use stored procedures with an output parameter. Unfortunately, my queries are necessarily dynamically generated, and output parameters do not work …

Keep getting this error. Using ASP datagrid [CODE] Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim connectionString As String = WebConfigurationManager.ConnectionStrings("connectionstring").ConnectionString Dim selectSQL As String = "SELECT * FROM checkInOut" Dim con As New SqlConnection(connectionString) Dim cmd As New SqlCommand(selectSQL, con) Dim adapter As New …

Hi, I'm new to ASP.NET. I began learning as I had to make a website for a college project using a language I didn't already know (I know PHP pretty well so I'm not a total noob :P). Basically what I'm trying to do is get a list of products, …

Hi guys, I'm new here and in dire need of help for a problem that I've worked on hours. I created a table 'tblProductCat' in the webform and wanted to populate the table with the code below: [CODE]Imports System.Data Imports System.Data.SqlClient Partial Class ProductCategories Inherits System.Web.UI.Page 'Define DA and DS …

Hi, Im using a datagridview with a object as its datasource.. Im willing to provide sorting functionality for the same but as the datasource is object it is not allowing me to sort the columns in the gridview. is ther any way to achieve the same? i have visited the …

I'm currently using a combo box to select one of many alternatives. From 5 alternatives only 1 works, when i click on any other it gives me the following error: "Cannot bind to the property or column 'xyz' on the DataSource.Parameter name: dataMember" Why is this error caused? What are …