Fill Controls Using SQL FOR XML Path?
Dec 7, 2009
I am using .Net 2005 and have a program that accesses over 1 million records in SQL 2005 db. As the program starts it is loading different controls from the db. However, to load the controls it can take an initial 2 minutes or more. What I have found out is that if I query the db using the FOR XML Path that it would load much faster. I have found this to be true when querying directly in SQL.
Since I am new at querying a db of this capacity I am not sure what my approach should be in being able to get information from the XML output. Below is some code that I found, but I cannot get it to work. I keep getting an error when I use the ExecuteXmlReader. If I can get it to work past that point, then I figure that I can load my controls with what is in XML reader.
Dim xr As XmlReader
Dim xd As New XmlDocument
Dim cmd As New SqlXmlCommand(CONNECT_STRING)
[Code]....
View 3 Replies
ADVERTISEMENT
Jul 22, 2010
1- Read an Excel Worksheet into DataTable (dt);2- Check 'dt' to know if some columns titles exists;3- Query 'dt' and discard rows where some itens are null or empty;4- After query 'dt', fill some ComboBox.I wrote the code below. It works nice, but I don't know if I'm using best practices when I use Linq to query the data table like I did.
View 1 Replies
Nov 9, 2009
I'm having a bit of a problem with the web application I'm currently working on. In it there are a few Web User Controls that we use to display information on a bunch of different pages. They seem to compile alright and arent showing up any errors. The problem is trying to register them on other pages to access them is returning a 'file not found' error in visual studio (2005). I have them defined like this:
<%@ Register TagPrefix="cc2" TagName="ControlSelector" Src="~/components/controls/ControlSelector.ascx" %>
The strange thing is that when I remove the '~' from the front no error is shown but the path beomes ~//components/controls/ControlSelector.ascx when looking at the designer and obviously it cant find the control anyway.
View 1 Replies
Aug 10, 2009
I would like to create a filepath and assign it to a string (so that it can have yet more added to it later on in my program) the code takes (well i want it to but it doesn't) the name of a drive selected previously and then adds this to a string to create a string variable that refers to a file. and then (as usual) i want to use thes files and display them in a combobox but i want to only select files that have a pre selected 2characters at the front. I have got this code so far:
' search for filer drive NETAPP-1
For i = 0 To frmDatabase.drvDB.Items.Count - 1
If InStr(frmDatabase.drvDB.SelectedText(), "\Netapp-1malika", CompareMethod.Text) Then
[code].....
View 6 Replies
Sep 8, 2011
I am wondering if anyone has any idea how to make the controls stack and fill up the available space left by a control if the control is hidden or removed from the UltraGridBagLayoutPanel.
Example:
[Textbox 1]
[Textbox 2]
[Textbox 3]
[Textbox 4]
[Textbox 5]
If I hide [Textbox 3] as of now, it will disperse the space left equally and pad the remaining text boxes with the space. However, I would like it to do this...
[Textbox 1]
[Textbox 2]
[Textbox 4]
[Textbox 5]
Where all the text boxes will move up and [Textbox 4] will completely consume the space left by [Textbox 3].
View 1 Replies
Aug 22, 2006
I have a Access program and I'm using VBA code in the background to run Winunzip using shell command. Well, the path of the .zip file has spaces in it and it's not recongizing the path as a valid path. Is there a another way to tackle this problem besides the shell?I can't us pkzip either. Has you can see I had to use progra~1 instead of Program Files.[code]
View 2 Replies
Sep 23, 2009
I just want to display data of a single column from an oracle table into a datagridview or a listbox for readonly with no requirements to make changes to it. Simply display the information.What is the best way forward... To used DATAADAPTER or DATAREADER.s DATAGRIDVIEW SLOWER TO FILL THAN a LISTBOX.i am using the following code to fill datatgridview but for some odd reasons at time it is slow to display the data. I want to use listbox instead
Dim ds As New DataSet
Dim adp As OracleDataAdapter
adp = New OracleDataAdapter("select customer_name from customers")
[code].....
View 7 Replies
Apr 13, 2012
Problem drawing dotted path lines, with even dots along the path line.I want to draw a path line that can be any shape (square, round, outline etc), and along this path line I want even dots to appear.
I also want to be able to resize the shape (as in the example attached)This is very easy to do using "DrawPath" and defining points for the path and using a pen defined as dots.The problem I have is I want the dots to be evenly placed along the path, on any shape or size I draw.In the example I have created, I create a square with 4 points and draw a dotted path.There are 2 buttons that allows me to resize the square (larger or smaller) this helps show the problem more clearly.
The path starts at the top left corner and finishes back at the top left corner, the dots are evenly placed along the path, except the final dots at the end of the path. (Sometimes the dots are even and other times they are not even).The shapes I want to draw can be any size and any shape, but I have used a square in this example to show the problem I have. point me in the direction I need to go that allows me to draw the dots and give the impression that they are even all along the path, for all shapes and sizes.
In the pictures below if you change the size of the shape, one will have even looking dots, the other will not.
[Code]...
View 2 Replies
Dec 7, 2010
i used the following codes:
private mediapath as string = "C:movie.avi"
private form1_loads blah blah blah
[code].....
View 7 Replies
Apr 7, 2009
I am trying to create a function to convert a mapped drive path to a UNC path. I did some googling and found several different pages on the matter. I am most interested in the first one, but I cannot seem to get the code to cooperate. Since the original post was in C#, here is my VB.NET conversion:
[Code]...
View 1 Replies
May 22, 2012
I am trying to read and display a file using MapPath as follows :
Response.ContentType = "Application/pdf"
Dim FilePath As String = MapPath("../Document/123.pdf")
Response.WriteFile(FilePath)
Response.End()
This procedure will work fine and display in the browser. However, if I save the file to C:Document123.pdf, how can I access this file using relative path in MapPath function. Is there an option to access the file which is saved out of IIS server? I am using vb.net 2003.
View 1 Replies
Jun 14, 2012
I'm using acrobat that returns unix paths instead of windows path's. So im wondering if there is a way in vb.net to convert the path to windows path.
i tried using:
docs(i) = javaScriptObj.path().ToString.Replace("/", "").Substring(1)
position = docs(i).IndexOf("")
docs(i) = docs(i).Substring(0, position) + ":" + docs(i).Substring(position + 1)
this only works on local files, but fails when im starting to use network drives.
View 1 Replies
Apr 12, 2012
I want to draw a path line that can be any shape (square, round, outline etc), and along this path line I want even dots to appear. I also want to be able to resize the shape (as in the example attached) This is very easy to do using "DrawPath" and defining points for the path and using a pen defined as dots. The problem I have is I want the dots to be evenly placed along the path, on any shape or size I draw.
In the example I have created, I create a square with 4 points and draw a dotted path. There are 2 buttons that allows me to resize the square (larger or smaller) this helps show the problem more clearly. The path starts at the top left corner and finishes back at the top left corner, the dots are evenly placed along the path, except the final dots at the end of the path. (Sometimes the dots are even and other times they are not even).
The shapes I want to draw can be any size and any shape, but I have used a square in this example to show the problem I have. I need to to draw the dots and give the impression that they are even all along the path, for all shapes and sizes. [Code]
View 2 Replies
Jul 16, 2011
i get this error "Illegal character in path" when checking for a folder to see if it exists.
the folder is D:PlanificatorPlanificatorPlanificatorServerinDebugData1 and it exists.
Function IDExists(ByVal User As String)
User = User.Trim
Scrie("Se verifica existenta ID-ului " & User)
[code]....
View 1 Replies
Nov 29, 2010
Well now i have an issue which is pointing in the use of "path's" physical and network.I have a SQL server on a Server machine and i have a desktop machine used as client.I'm runing from my client machine a stored procedure in order to add a streaming data base.But also before i run this procedure i run another one which prepare the desired "path", this procedure takes:
myPath="\ServerSharedFolderSQL
in order to run the first procedure i have to turn myPath in each physical name:
myPath="DriveLetter:PublicWorkFilesSQL"
Now my Issue is how i will have the physical path, which is build it on the server and which it's from very difficult (to imposible) to know it? Basically i need a function which will return me the physical path, which the implementation it's not knowing to me. My developing environment is vb.net 2010?
View 2 Replies
May 15, 2009
I am using this code below:
[Code]...
I thought the %AppData% should find the relative path. When I go 'Start|Run|%AppData% windows explorer takes me to that directory. I can not put the full path in, as the user is different on each client machine.
View 2 Replies
Dec 23, 2010
Private Function UploadPic() As String
Const bmpw As Integer = 300
Const bmph As Integer = 300
[code].....
View 14 Replies
Jun 1, 2010
I have an .exe application written in vb.net. When I make shortcuts to the application, say on desktop (or anywhere else) and then click on them I want to programatically get the path to that shortcut, ie. C:/Users/xxx/Desktop/shortcut.lnk.
I want this so I can store the pairs shortcuts : (program + different cmd args).
View 2 Replies
May 1, 2012
I'm just trying to move my folder from one path to another path.The coding seems like it has moved it but the folder is not appearing in my destination path?
View 7 Replies
Mar 7, 2011
Say URL1: http:[url].....
RelativePath: ../../hello.htm
Hence absolute path is http:[url].....
Is there a function that do that?
View 3 Replies
Aug 14, 2009
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 Replies
Dec 3, 2010
can i know what code that enable me to list all currently running process and get their path and list all the path in listbox1.
View 2 Replies
Jul 25, 2008
when i try to write to a file I get the error:
Quote:
Access to the path "PATH HERE" is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path "PATH HERE" is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.But when I add: <identity impersonate="true"/ to web.config I get the following error when my application trys to open a DB to read it:
Quote:
Unspecified error
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Unspecified errorLine 55: objConnection.Open()
View 1 Replies
May 22, 2009
I wanted to know if anyone could tell me how to access the Click_event.I have a boarderles form with a panel control which has the Dock property set to fill and on the panel I have placed a Label also with the Dock property set to fill. I also have a timer running.How can I get code to execute in the Label1 click event.I've tried doing it by using the generic Click_event and also with two variations of the Click_event Handles parameters
'Alternativ 1:
Private Sub Form1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
[code].....
View 16 Replies
Aug 23, 2011
There is newer code in a follow up post. I suggest using the code in the later post rather than the code in this one. You can still read this post though. When designing a user interface, one should be conscious of how many individual controls are required to implement the functionality. In some cases an initial design may begin with many buttons or textboxes (for example) but then further review of
the actual required functionality allows for a reduction in the number of unique controls.
But other times, there isn't a better way (which will still make sense to the user of the application) then to have a series of many repeated controls. So in the cases where one can be certain that the best UI implementation for an application will require the use of multiple copies of a given control, then it often becomes necessary to maintain some method of managing all of those controls at various points
throughout the application. Doing so typically requires that one build up some collection of controls which can then be accessed by index in order to work with any given control; but this can lead to a lot of clutter in the code file which handles these control's events. For instance there will be some kind of collection declaration, some recursive routine to find all of the controls of interest, and then any number of event handler methods with long lists of Handles clauses, or additional code loops to wire up the event handling for each control.
Purpose Since most of this functionality could be considered a requirement regardless of the type of control being managed, or its required functionality, it may make sense to wrap all of the control management functionality into a single class. And since our first requirement is a collection of controls, then a base collection class could be the perfect starting point for our control manager. There are a number of existing thread around this topic, with some recent (at the time of this writing) ones being:[URL]..In this, and related, threads I have posted examples of a simple TextBoxManager and ButtonManager control. But again, with so much similar functionality required regardless of the control being managed, it would be technically possible to create a generic ControlManager(Of T As Control) class which can manage any type of control.
[Code]...
So in summary, one can facilitate managing a large number of user interface controls by building a "control manager" class which both encapsulates the list of control instances, and deals with adding and removing defined event handlers for every control it manages. The generic control manager class itself can be inherited and extended into a more specific class on a per-application basis in order to provide more application-specific functionality. Reed Kimble - "When you do things right, people won't be sure you've done anything at all"
View 9 Replies
Nov 8, 2011
If I have the following ListView, how can I attach a SelectedIndexChanged event listener to the DropDownList so I can perform a command on the respective object? Imagine I have a list of new users and I want to add them to a usergroup by selecting the group from the DropDownList.
<asp:ListView ID="NewUsers" runat="server" DataSourceID="NewUsersSDS" DataKeyNames="ID">
<LayoutTemplate>
[Code].....
View 1 Replies
Nov 10, 2011
I have a maximized form that has controls at the top of it and a large DataGridView that is docked below all the controls. Its kind of like the Ribbon in MS Office. The controls cover about 1/4 of the screen at the top. I would like a way for the user to click a button to hide all the controls then automatically expand into the place the controls were so the user can view more data in the DataGridView and visa versa. For example, in MS Office Excel you can hide the ribbon by clicking a tiny button that has "^" on it.
I'm not very familiar with all the controls in Visual Studio so I would like to hear some recommendations. Is this situation ideal for a SplitContainer or ToolStripContainer or am I way off base here?
View 8 Replies
Nov 20, 2011
I've got a couple of these NumericUpDown controls I put on a form. Without describing too much about the form I basically want to update some variables each time one of these NumUD controls changes value. So for each NumUD I have a call to a Recalculate subroutine within their "changedValue" event.
There are actually two problems. First, if I initialize the "Value" property to something other than zero in VB2010 at DESIGN TIME it won't even open the form when I hit RUN. It gives me a "No Source Available. No symbols loaded for any call stack frame" error. The error box says "InvalidOperationException" was not handled. So if I try to set the initial value of the Value property to anything but zero of either I get this error.
[Code]...
View 7 Replies
Jun 11, 2011
i want save image in directory path and also save path in database...sqlserver 2005 and retrieve in in same folder and path?
View 1 Replies
Nov 25, 2009
I have one project and in this project I want to save picture to application path and save the path to database as string and retrieve the image from the application path.Can u give me some idea about it..i am using vb.net as frontend and ms access database
View 1 Replies
