I have a grid view that will display columns from multiple data sources (3)The data sources are stored procedures that contains a variety of columns not identical,How can i select the columns from these datasources and bind them to the Grid programtically (from code behind)?
View 1 RepliesIm designing a report with reporting services (not crystal) I add a table drag some fields to that table and that works great, now I need to add another table component and drag fields from another query (in the same dataset).When I try to test it it says:A data source instance has not been spplied for the data source Dataset1_SP1 (this is the second query).i need to list first elements from one query and then from another.
View 7 RepliesIs it better to add just one datasource to your project that holds all your database tables and queries that you use as typed datasets. Or, create a datasource for each individual form or situation where your using the database tables as typed datasets. It seems simplier to have just one datasource but is there a down side. We're talking about @25 database tables/queries.
View 8 Repliesi've trin' to setup in my server, a connection to my Microsoft sql server, in order to develop an web application using this type of tech. Of course, VB.Net. after tryin to research an aspx.net here in msdn, i havent found yet anything.
I have my connection string "on", pointed to Windows Authentication. I've changed to A new login created in Microsoft SQL Management Studio (sql Server 2008), such as a user guest.testing locally, the asp.net develop server is up and running because it uses my domain credentials.If testing by access in my website, like a guest, it throws an execption pointing to a Login Failed. I've tried so, with my own credentials, and not succeded.
I have two comboboxes. Depending on what is selected in the first combobox, I want the second combobox to display a different field from a different table within the same database (.mdb).Is this possible?I have the following code, but I get a "Complex DataBinding accepts as a data source either an IList or an IListSource." Error when running the code.
[Code]...
I'm having some trouble setting up binding sources to these types of files, not sure if I'm selecting the correct driver in the wizard. Tried the generic ODBC and .NET drivers but it doesn't work, the dataset is created and adds a table but there's no data retrieved. The design object being used to display the table is a datagridview. Can't find documentation on dealing with files, only databases.
View 1 RepliesI have a form that has three comboboxes in it, cbxStudy, cbxMethod, & cbxAnalyte. When I call the form I load a data table and use that table to fill the comboboxes. I want to assign a value to cbxStudy, then fill cbxMethod by filtering the data table using the value in cbxStudy, then fill cbxAnalyte by filtering the data table using the values in cbxStudy and cbxMethod.
This code keeps failing when the forms New constructor is called, but once the form is loaded the code works great. I indicated below where the code is failing. It's failing because Me.cbxStudy.SelectedValue is = {System.Data.DataRowView} when the constructor is called even though I set the SelectedValue myself.
Public Class frmSelectMethod
Private cv_dt As New DataTable
Private cv_strPrevValue As String
[Code]....
Is it possible to combine the data of 2 or more datasources in 1 windows form in a project solution?
i'm using sqlserver 2008 and visual studio 2008
I have a stored procedure that retrieves employee information - I don't want to edit this stored proc because it is globally use with in the website. Here is now my dilemma, how can I put multiple row records in a column in the grid view. Is Gridview powerful enough to my scenario below or I really need to edit the store proc or my copy of it.
Record Retrieve by stored proc
Employe_ID Purchase ID Amount
1 0123456 100
1 012356 560
1 012446 560
[Code].....
I am trying to delete multiple rows from a GridView but I am struggling to find out if a check box was checked.At the moment my code isn't attempting to delete anything just check which checkboxes were checked and which weren't. My attempt isn't showing any checkboxes as being checked and also seems to loop though the GridView rows twice!
.ASPX
<asp:GridView ID="gvImages" DataKeyNames="id" runat="server" AutoGenerateColumns="False" BorderWidth="0px" GridLines="None">
[code].....
I am creating a web application in ASP.net/VB.NET and I have an issue with the gridview.Currently, I have the gridview populated with data from the DB and I've also coded the update button to allow the user edit any necessary information through a form that pops up.[URL]...
What I'd like to do, if possible, is add a button to the two right columns(I already put one in the Dock Out Time column) which will be invisible if the column is set or will set the current time to the column. Setting the time for those two columns is already handled through the update form, but my supervisor asked me to try and see if this was possible.
Those two Time columns are Templatefields(since I format the display time from what is actually in the DB) and I added an asp button in the ItemTemplate for that Set Button in the picture.Is this even possible to do and if so, how would I access this button in the code behind so I can add functionality(setting the time and hiding it if the column is not null)If it's not really possible to have two items like this in a templatefield I can just make 2 extra columns for these buttons but I think this would look much cleaner.
How do I filter my DataGridView with multiple checkboxes names? I want to filter in which region the suppliers are located. ex. RegionTable.Regionrow. And I have 4 different regions(checkboxes text name) I want to filter with. Compatible to use multiple choices in filtering.
So. Checking 2 of the 4 regions and pushing the filter button should filter the gridview after checked checkboxes. I have tried different methods for 4 hours and search the net but can't find any good method.
[Code]...
I have the following code to add a new row into a datatable and then bind it to a gridview.I need to add a new row anytime i click the Button2.What do i need to change in the code so i can have multiple rows before i submit them to a database?
Private Sub BindGrid()
Dim DT As New DataTable
Dim Row As DataRow
[code]....
In grid there r checkboxes for selecting the records to be updated as soon as checkbox is checked textboxes changes to edit mode. when data is modified and update button is clicked updation should be done to the database.But when update button is clicked its not working.when i checked through breakpoints i m not getting the value for the variable strID.
Protected Sub btnupdate_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles btnupdate.Click
Dim strSql As New StringBuilder( String .Empty)
Dim cmdup As New SqlCommand
For i As Integer = 0 To GridView1.Rows.Count - 1
[code].....
I have the following function that returns only the 1st row of data and puts it in a nice table. My knowledge in this area is limited in that I don't know how to create the table to return multiple rows. Can you show me how to change this to return all rows, no matter how many there are? my sql select statement may return 0 rows or many rows.
<System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()> _
Public Shared Function GetDynamicContent(contextKey As String) As String
[Code]....
I have an ASP.net web page with VB code behind linking to an MS SQL DB. On the web page I have 4 DropDownLists and 1 GridView. Each DDL is populated with a SELECT DISTINCT query on 4 corresponding columns from 1 table in the DB. What I would like to be able to do is: when any of the DDLs have their selected item changed the other DDLs are updated. Crude example:
[Code]...
I have a Devexpress Gridview that is linked to a delete, fetch and update stored procedure. The problem I am having is that when I run my program, select a row in the grid and press delete it fires the event multiple times. Specifically it deletes the selected row and then I re-fetch the data so the focus returns to the first row. Which is what I want.
Unfortunately it starts at the beginning of my list and goes down it row by row deleting each row it comes to. It then continues several more times after the rows are deleted. I know this because for each deleted row it asks me if I want to delete it. If I say no then the rows appear to disappear until I manually refresh it after the deleting is done. To make this even more random the second row always reappears after I manually refresh the grid.
[Code]...
I have an app where I need to dynamically choose an SQLDataSource for a GridView so I can use 1 of 2 stored procedures, depending on who is logged into the system. My problem is that I am using logic like this, in the button click...
If Session("SiteType") = "Type1" Then
GridView1.DataSourceID = "SqlDataSource2"
Else
[code]....
This happens when you click the button that reveals the panel with the gridview in it. The user then makes changes (basically adjusting a text box on one or more liens of the grid) and then clicks "save". However, the gridview no longer knows its DataSourceID once this happens, so when I try to go through the gridview's rows - there are none.
If, in the save button's click, I put the same code, it (of course) blanks out any of the data changes I made in the form. So, simply put - how do I dynamically choose the SqlDataSource, but only one time, so that the program then keeps that SqlDataSourceID associated with the gridview until the end of the cycle? Is this a ViewState thing? I don't totally understand ViewState...
How to show pop up menu from database in gridview on each gridview row items ?Example of this is : http:[url].....Move your cursor to Departure time and arrival time...a want this type of popup in gridview items....which fetch entries from database..
View 2 RepliesIn my application,i have a gridview in which columns are created at runtime.Actually these columns are created when i am entering data in a database table.[code]where Column1,Column2,column3 may vary during runtime.i need to enter values to these columns during runtime.But i cant bind these columns because these are created during runtime.The first column "Description" will not change.It will remain constant.For each description, there will be values for each column.At last these data will be saved to the database.How to add columns in the gridview during runtime?
View 2 RepliesI am able to export a gridview to excel, my problem is that I cannot figure out how to remove the formatting from coming over from the girdview. Here is the code I am using to export the gridview: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
I have a modal popup that contains a gridview. On the click of a button inside of a grid i reload the gridview with the data that depends on the id of the row clicked in the gridview. I would have like to reload the gridview onclientclick but I couldn't find a way to do that. Is it possible to reload a gridview client-side without the user even knowing the page partially loaded?
View 2 RepliesI am using VB.net.
I need to fill a gridview(1) with data that cames from another gridview(2), ie:
(2) - All articles in the database.
(1) - Selected articles from (2)
What is the best way to do that?
I have a question regarding the dataset usage in Reporting Services. I have a stored procedure which returns multiple select statements (result tables), and I created a Dataset in Reporting Services 2005 with this stored procedure. The problem is that I can not reference the second or third result table, and I can only use the first select statement fields. Is this the limitation on Reporting Services Dataset or is there a way to use multiple table results in one dataset?
View 1 RepliesI have a website that has highly granulised access and hence requires many web.config files. The problem is I would like to trim the menu so that only certain users will have access to certain folders. I have enabled trimming and setup roles in the sitemap, however when I access the page the menu is not show, as I am authorized to view the default page which is not in a subfolder. When I type the url of a page in sub folder's I have access.
How should I handle this:
A site map for each web.config file - don't know how this will work Removing the sub web.config file to only use a single one
I have been struggling to find a solution for this problem. What I need to do is build a server application that accepts tcp client requests from different clients running on same port say:1003. I experimented by using asynchronous mode call backs etc. but it disconnects once connection is established and does not respond for further requests from the same client.
View 1 RepliesIam wanting touse sendinput in a dos or background type app (can be a regular app thats hidden) that emulates mouse clicks and sends mouse moves to another multimouse application. an project that im working on for my school i work at and i need to send the input to it. The overview of the project is i need to have this code be in a service that runs in the background that when a person does a gesture with my kinect code then it clicks the left mouse or sythesis it with sendinput (need mouse up and down sent for this to work). The end programs that receive input are: a program written in the multipoint sdk and mouse mischief. I though about using the default usb mouse driver as an emulated mouse driver to handle the part about creating a usb mouse device that works
since most newer computers are using usb.
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 Repliesvisual basic 2008 express
access 2007 db
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
I am trying to list all printers (PrintersConnections) under all users (HKEY_USERS)
problem is I dont know the user name keys in advance and need to exclude .DEFAULT and *_CLASSES so first I need to list all key names (%usernamekey%) directly under HKEY_USERS then for all keys that lists lsit all keys under HKEY_USERS\%usernamekey%PrintersConnections
Here is the code I have so far but I get errors about object variable not set, I suspect because of the way I doing the for each and listing the key names and then doing it again
Code:
Private Sub DetectPrntrs()
Try
Dim RemReg As Microsoft.Win32.RegistryKey
[Code].....