datasource

How do I handle updating a DataGridView when the bound DataSource goes to empty?

I have a DataGridView to which I've set a list of objects to the DataSource. (I'm in VS 2005 using VB.) I created the DataGridView by creating a Data Source of type AssetIdentifier and dragging that Data Source onto my form. I want to update the DataGridView when the selection in either a combo box or another DataGridView changes. (B...

WPF Databinding based on conditions

Goal Develop a custom control which displays summary data for a specified week. The data passed in would be as follows: 3rd May 2009 Customer A $2000 4th May 2009 Customer A $3900 6th May 2009 Customer B $1900 The expected display would be 3rd May 4th May 5th May 6th May Cu...

how to set datasource to dropdownlist

hi all i want to add a datasource to dropdownlist this dropdownlist is one of the column of gridview here i want to add a datasource to dropdownlist at dynamically without using the sqldatasource (vs2008 and c#) ...

Externalizing Grails Datasource configuration

Grails 1.x allows using external configuration files by setting the grails.config.locations directive. Is there a similar approach available for externalizing the database configuration in Datasource.groovy (without setting up JNDI)? It would prove helpful to be able to configure DB credentials in a simple configuration file outside the...

ASP.NET AcessDataSource and dropdownlist

Hi I'm using visual studio 2008 with .net 3.5. I have an AccessDataSource that is linked to a access database. I have a dropdownlist that use the AccessDataSource. Everything was done with the wizard and everything was working just fine. At the page load I decided to call the SelectedIndexChanged of my dropdownlist to update someth...

Delphi & shared datasources

In my app I have different forms that use the same datasource (so the queries are the same too), defined in a common datamodule. Question is, is there a way to know how many times did I open a specific query? By being able to do this, I could avoid close that query without closing it "every where else". Edit: It's important to mention t...

Replace DataSource for Reporting Services RDLC Reports

I am making some changes and need to change the DataSource for my report. How can I do that without losing all of the work I have done? Assume the field names are the same. Update: The reports are still in Visual Studio and I need to change from a TableAdapter to a DataTable which I will fill through a class. Update 2: Currently it is ...

Weird two controls / same datasource problem

This is using winforms and the problem is that I have a listbox and a combo box, both tied to the same datasource, same display members, same value members. All is bound just fine and the items show up in both the controls. But when I change a selection in one control, it moves to the same index in the other control. I don't have any ...

How can I configure JBoss JDBC data source connections outside the XML config file?

I would like to override the portion of JBoss that loads JDBC connection information from the XML config file. I would like to continue using the rest of JBoss's connection pooling/caching features. I just want to load the connection data from another source. Which MBean should I be implementing and how do I configure the override in J...

Binding to interface and displaying properties in base interface

This question (along with its answer) explains why you can't easily bind a DataGridView to an interface type and get columns for properties inherited from a base interface. The suggested solution is to implement a custom TypeConverter. My attempt is below. However, creating a DataSource and DataGridView bound to ICamel still only resul...

C# Repeater.DataSource from 2 StringCollections

I have 2 StringCollections: StringCollection ParameterIDs StringCollection ParameterValues Is it able to map these both StringCollections as DataSource, something like: repeater.DataSource = ParameterIDs (as row1) + ParameterValues (as row2); repeater.DataBind(); and use them in repeater like: <asp:Repeater ID="rep...

Weblogic error

I am getting an error when I try to establish connection through a DataSource created in weblogic server.Has anyone faced this error in past.I am getting exception in getConnection method of the DataSource. java.lang.IllegalArgumentException: interface weblogic.jdbc.rmi.internal.ConnectionImpl_weblogic_jdbc_wrapper_PoolConnection_com_i...

Windows ODBC Datasources and .Net System.Data.Odbc: Which driver is used?

Hi all, I am confused on how to connect to Oracle via ODBC. I have created an ODBC datasource named "oracle" in my Control Panel > Administrative Tools, and used the driver "Microsoft ODBC for Oracle". In my app.config , I have the following connection strings <?xml version="1.0"?> <configuration> <configSections> </configSection...

How do you configure a DataSource in Java to connect to MS SQL Server?

I'm trying to follow Java's JDBC tutorials to write a Java program that can connect to SQL Server 2008. I'm getting lost at the point of making a connection. The following snippet is from the tutorial: InitialContext ic = new InitialContext(); DataSource ds = ic.lookup("java:comp/env/jdbc/myDB"); Connection con = ds.getConnection(); D...

Ignore errors on Data Source in SSIS

I have 3 million rows customers.csv file. When I import it in SQL 2008, I am getting a data source step in a data flow. "[Source - Customers_csv [1]] Error: The column delimiter for column "CCode" was not found." CCode is the last column in the file. The error is on data row 82824. I can't open this 2GB file to look what is going on. ...

How to make UI Image Picker Controller read a custom source type in iPhone

I have to create a photo gallery app in iPhone. It should function same as the Photos app which is shipped with iPhone. But it should show the images which I package with the app. UIImagePickerController reads only the following source types. UIImagePickerControllerSourceTypePhotoLibrary, UIImagePickerControllerSourceTypeCamera, ...

Copy SQL Stored Procedures between DataSources/Schemas?

Hi Friends, I've created SQL stored procedures in our development schema and its working fine. Now we are in the task of moving our development codes to production one. How do I copy those stored procedures from one schema to another schema? Do I need to re-compile whole procedures on targeted schema? Or Is there any way register those p...

Is CollectionViewSource in WPF optimal?

Many WPF examples use CollectionViewSource as DataSource for DataBinding. It provides sorting and other useful functions. My question is, shouldn't this be done in Database? I mean in SQL? I bet it's 10times quicker. Isn't CollectionViewSource too slow? Thanks ...

It's not refreshing/databinding the page. How to refresh linq datasource?

protected void DetailsView1_ItemInserted(object sender, EventArgs e) { using (SqlCommand cmd2 = new SqlCommand("uspUpdateDisplayHours", cn)) { cn.Open(); cmd2.CommandType = CommandType.StoredProcedure; cmd2.ExecuteNonQuery(); cn.Close(); } DetailsView1.DataBind()...

Reporting Services, how to use a connection string from a query result

A report needs to be run on multiple sites, each with its own connection string. These site names and connection strings are stored centrally. I want to make a report that Accepts the site name as a parameter Queries for the sites connection string Uses the sites connection string to get the report's data I've tried using two data ...