I am linking a report within asp reportviewer to a drop down list, but keep on getting an error 'A data source instance has not been supplied for the data source 'DataSet11_NewSelectCommand'. I cannot see anything wrong in the code though,
Imports System.IO
Imports System.Web
Imports System
[Code].....
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI am currently working on a custom data type, and wanted to implement a = operator.
I data type is a nullable date that returns a string value if date was supplied.
I want to allow the variable to be set like this
Dim nd as New NullableDate nd = Today Does anyone know how this can be done, or can anyone point me in the right direction?
I have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
I have no problem doing a select statement from a database and displaying it.An I have no problem inserting data into a sql database table. However with this issue I have to grab the data an insert it into a totally different SQL 2005 instance.
View 8 RepliesI keep getting this error :
The parameterized query '(@AdminEmail nvarchar(4000),@AdminPassword
nvarchar(4000))SELECT' expects the parameter '@AdminEmail', which was
not supplied.
[code].....
Modifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 RepliesI'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
how to use the VS 2010 IDE tools in a way the Microsofties didn't specifically intend. But since this is something I immediately tried without success.
I have defined a .NET 4.0 WPF Application project with a simple class that looks like this:
Public Class Class1
Public Property One As String = "OneString"
Public Property Two As String = "TwoString"
[Code]....
The expected result was that "OneString" would appear next to "One" and "TwoString" next to "Two" in the running window.
The question is: Why didn't this work? What will work instead? If I put bindings in a DataTemplate, it works. Blend, with its sample data stuff, implied that this should work, but it doesn't.
I have an xbap application that calls a webmethod from a web service that executes a stored procedure and I'm getting the error that my stored procedure expects a parameter which was not supplied. Error and code are as follows
[Code]...
I have 5 combo boxes that need to show the same list of items that come from a single dataset table. I have managed to bind the datatable to the combo boxes no problem at all.. but when I run the application and select an item from one of the combo boxes all the others change to the item I selected. After some research I believe that this problem is something to do with using the one datasource so I have tried assigning the dataset datatable to 2 different variables and used them as datasources for 2 of the comboboxes but the same still happens.
A work around to this I can see is to call the same methods and SQL select statements 5 times over to get individual datasources for each combo box but this doing that sounds crazy to me. how I can get around this easily? Code snippet below shows 2 combox boxes and their datasources. I'm using VS2005, .Net 2
ComboBox1.DropDownStyle = ComboBoxStyle.DropDownList
ComboBox1.DataSource = AllergyListDataSet.Tables("ListOfAllergies")
ComboBox1.DisplayMember = "Condition"
[Code]....
can data reader be used as a data source for a grid control?
View 5 RepliesI have a combo box with a data source. This box shows one column of a table and allows me to select one item.Next, I have an ordinary text LABEL that I need to put text from another column of the item selected above.I tried to set the data binding field of the label, but this grabs only the first row or data and shows the selected column. That is nice, but I can not figure out how to update the selected selected ROW when the combo box item is changed.In this case the combo box lists a bunch of inventory parts. When I select a specific part, I need the change the text in a label to show the manufacturer. (like a sub-form). This same behavior will be used in several other places, but the relationships can cascade.
View 4 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
How to I reflect back the name of a type that is supplied as a generic parameter? I would really like to know how this is done in both C# and VB.NET. See the following example code and expected response.
In C#:
public void Test<T>()
{
Console.WriteLine("The supplied type is {0}",???)
}
[code]....
Executing Test<String>() or Test(Of String)() should produce:
The supplied type is String
I am trying to execute a procedure from vb 2005 .The procedure has a return status that is returned to another procedure that writes an error log. The @status parameter has nothing to do with the app. Since @status is an output parameter what do I need to do?
View 1 Repliesim having a problem with my code Private Sub TextBox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox2.TextChanged
[Code]...
once i typed in the string in the textbox to search for an item i get this error The parameterized query '(@Parameter1 nvarchar(4000))SELECT * FROM borrow where (Departme' expects the parameter '@Parameter1', which was not supplied.""
I'm getting the error: The parameterized query(@CustomerID, @ProductCode, @DateOpened) expects the parameter @ProductCode, which was not supplied.For one thing, my INSERT query has five parameters, not just the three listed in the error notice.
Another thing, I supplied @ProductCode in the AddWithValue statement.
Another thing is that I don't get the error when I change:
InsertCommand.Parameters.AddWithValue("@DateOpened", Date.Today.Date)
[code].....
I was working on this thread in regard to DataRelations on multiple tables. If I use CommandType = CommandType.Text, the code does as expected. However, I decided to take the SQL query and throw it into a stored proc. I then changed my code to use the stored procedure and I get the error as per the title of this thread.
[Code]...
When I use the SQL Profiler, I see that NULL is being passed to the stored procedure. I have looked online and haven't been able to find an answer.
I have a bit of code that reaches out and grabs a series of rows from SQL Server DB. I perform an inner join to get some related table data. In the process I get returned the user id of the creator of the data. I then want to pass this into a query to get back a full name. I am having no luck figuring out how to do just that. If I use the data visualizer I can see the name I am after, I cannot figure out the call to extract it
Bindingsource1.DataSource = GetData("Select * From PURCHASE_ORDERS WHERE PURCHASE_ORDER_NUMBER =" & REQ_NUM.Text)
.DataSource = Bindingsource1
[code].....
While running the code I've included below I receive the error "EntityCommandExecutionException was unhandled by user code.I'm then told to look at the inner exception for details...and there I see under Data:"In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user."And under Inner Exception --> Message:"A transport-level error has occurred when receiving results from the server.[code]
View 2 RepliesI have a form in an application that I'm building that shows a datagridview with the last field being a checkbox. What I'm attempting to do is if the user clicks on the checkbox and then clicking on "Save Changes" all of the fields on that datagridview row (except the first field) is then saved to a database. I have the following [Code] The error I keep getting is "Insert Error: Column name or number of supplied values does not match table definition.".
View 5 RepliesWrite a program that will output the sum of the powers from 1 to the supplied number. For example an input of 4 will produce 288 ( 1 exponent 1 + 2 exponent 2 + 3 exponent 3 + 4 exponent 4 = 288)how can i work with this?
View 37 RepliesI have a form in an application that I'm building that shows a datagridview with the last field being a checkbox. What I'm attempting to do is if the user clicks on the checkbox and then clicking on "Save Changes" all of the fields on that datagridview row (except the first field) is then saved to a database. I have the following
Private Sub holidaysaveButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles holidaysaveButton.Click
For Each dr As DataGridViewRow In DataGridView1.Rows
[Code].....
I have a vb.net 2008 application that is supposed to run at startup. After meeting certain conditions, the PC is supposed to restart. Below is the code that is failing:
System.Diagnostics.Process.Start("shutdown", "-r -t 00 -f", myUsername, myPassword, myDomain)
myUsername and myDomain are both strings while myPassword is a SecureString. The application works properly when execute manually, but give the following error when executed from startup (either by placing in the startup folder or by adding to the registry):
The directory name is invalid
Also, the program executes properly when the last 3 arguments are left out and the user has the necessary rights.
How do I force a restart using an specific, alternate user credentials on startup?
I have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesI have been asked by a code snippet to add the instance of class that contains data i want to add to an XML file, the only trouble is i am not sure what an instance of class is. Is it something that looks like this: [Code]
View 2 RepliesI am creating a database for Employees. In that I have some issues. I am trying to bind my data using data source. In the list box properties I set
lstemp.Datasource = Employeedatabase
lstemp.Displaymember = "EmplyeeName"
lstemp.Valuemember = "EmplyeeId"
I want to get my employee Id for displaying data in text boxes. How can get the data of the highlighted employee name in the list box to text boxes
I am creating a database for Employees. In that I have some issues.I am trying to bind my data using data source. In the list box properties I set
lstemp.Datasource = Employeedatabase
lstemp.Displaymember = "EmplyeeName"
lstemp.Valuemember = "EmplyeeId"
I want to get my employee Id for displaying data in text boxes. How can get the data of the highlighted employee name in the list box to text boxes
I am doing project in 2010...I am trying to add new data source.
[code]...
