DB/Reporting :: Make SQL Default Back To Filling In Gaps And Only Count Higher If There Are No Gaps?
Oct 5, 2009
when setting a column to identity it will auto increment 1,2,3,4..however if you delete 4 & 5 and then insert another record it will go in as 6.If you do this a lot you end up with huge gaps in the numbers,is there any way to make SQL default back to filling in the gaps and only count higher if there are no gaps?I know I can do it in the application, or even a UDF, I just want to make sure I am not reinventing the wheel?
View 9 Replies
ADVERTISEMENT
Aug 23, 2010
How to find the correct DashOffset and DashPattern to fill in the gaps with another color within a dashed line if the 1st DashPattern has an array of mixed values?
If the 1st array for a DashPattern is like this though?
myPen.DashPattern = New Single() {20, 15, 30, 45}
View 6 Replies
Nov 1, 2011
I am upgrading a system that has a Product Table with a Product No Field.This is a string field but most of the existing product Nos are numeric but all over the place.I want to provide a default numeric Product No when the Users are creating a new product record.All I can think of is to use the Identity Field [ProductID] and test to see if it has been used and if so keep incrementing to find the next free numerical, available No.A better solution would be to start at 1 and increment to find the first available but it looks to be several hundred records into the Table. how to find the first available number?
View 9 Replies
Jul 16, 2010
I have some reports that I use with the MS ReportViewer and I need to get a count of the physical pages (as opposed to logical page count) to use with a print dialog. I've implemented a workaround so the ReportViewer control displays the correct number of physical pages, but is there a way to get that value from the ReportViewer control? The only publicly accessible property gives the logical page count.
[Code]...
View 1 Replies
Sep 27, 2010
We have a .net win forms application, using .net 3.5. Application runs from a terminal server, users access it with Citrix client. when users run this app memory usage goes higher and hiher and it never comes back. even tough we put objects with dispose and set to nothing also the memory usage is not comming down. it starts wuth 75 mb and goes up to 500 mb. it is a 32 bit application.
how can we find the exact problem with the application. the bahaviour is almost same when we run our development box locally.
View 5 Replies
Apr 15, 2008
What I am trying to do basically is open an access query in a datagrid view and then be able to make changes to the datagrid and then save it back to the database.When I try to save:
Me.BindingSource.EndEdit()
Me.TableAdapter.Update(DataSet)
It says that update is not a member of the tableadapter... Why is that?
View 1 Replies
Jun 22, 2010
I am new to programming with vb2008 and I am trying to fill out a form on line. The form looks for keystrokes and keeps track of the number of characters typed. There are two elements on the form that use this method. The first area will allow me to fill in the data using the usual method of setting the attribute "value" of the field as the data I wish to insert. But the characters are not counted. The second area does not fill at all.The code for the fields are as follows.
<div id="fck_editor">
<input type="hidden" id="body" name="body" value="" style="display:none" /><input type="hidden" id="body___Config" value="" style="display:none" /><iframe id="body___Frame" src="/includes/js/fckeditor2.6.4/editor/fckeditor.html?InstanceName=body&Toolbar=Default" width="649" height="410" frameborder="0" scrolling="no"></iframe>
[code]....
View 3 Replies
Sep 3, 2009
if i define a table like this:
Dim datatable As PdfPTable = New PdfPTable(4)
and i dont have 4 cells to add in it, how can i make it so that it automatically fills the cell if there are not enough cells?i am finding that unless i have at least 4 cells in there, it wont display it?how do i figure out which cells are blank?
View 2 Replies
Aug 3, 2010
m using backgroundworker to fill my data grid.Here is code:
Public Sub New()
InitializeComponent()
AddHandler DsData.Proba.DataRowChanged, AddressOf table_RowChanged
[code].....
View 1 Replies
Mar 19, 2009
Trying to fill a crystal report we want to fill in calculated information. Can someone tell us how to put information in a text field in the report?
Or is there an other possibillity to place static information on the report?
View 2 Replies
Oct 1, 2009
Ok, so I have a small program I am building for my boss to keep track of workers at certain job sites. With the way the economy is going my boss wants to track who is showing up at specific sites (jobs) and try to even it out among all the employees - some are not working full time.
Anyway, I have two Access tables linked together with the main table being Employee Data. The second Table is Employee Jobs. Basically I have three forms. The main form on startup will show all of the employees in the company - this is basically a list of all added employees into the database (this is the second form - adding employee info). At a quick glance I would like to have the initial startup form, with grid - show employee info, show the number of jobs each employee has been assigned to. Would this be an SQL statement? How to I get a row count and post that back to the grid so it shows up on startup?
View 2 Replies
Nov 26, 2011
In design mode - how do I change the default back color of buttons? I am using a white font and can not see the writing with the back color. The backcolor is transparent so in runtime it is fine (back color goes to blue and white shows).
View 2 Replies
Aug 13, 2009
I am am having some problems with using My.Settings. I have saved some strings with My.Settings.Save() and am trying to set the strings back to its default value. I have tried using My.Settings.Reload() but it does not do anything. What is the best way to set the strings back to its default value that I have set it to? I have looked around for this question but could not understand what to do to fix the problem. I have gone to msdn.microsoft.com but could not find any good information, only this[URL]..
View 7 Replies
Feb 22, 2011
Right now I am adding language GUI packages into my gaming application for users of other countries to enjoy the application.
View 5 Replies
Nov 11, 2010
I use the following line of code within a single method to explicitly check and trust an SSL cert from the following host: MyTrustedCompany.com:
ServicePointManager.ServerCertificateValidationCallback = Function(obj As [Object], certificate As X509Certificate, chain As X509Chain, errors As SslPolicyErrors) (certificate.Subject.Contains("CN=MyTrustedCompany.com"))
No problem with the code -> works perfectly 100%.
The problem is, it is too far reaching. I thought its scope would only be within the method I decalred it, but apparently it is a Shared property on the 'ServicePointManager' object, and must then persist for the entire application, which I do not want.
The problem is later I am calling web services of mine, etc and getting the "Could not establish a trust relationship..." exception. This is because in the line of code above I check for the host name of an SSL cert specefic to that method. I quickly tested Returning 'True' from the callback so all certs would be trusted instead of checking for a specefic name (i.e. MyTrustedCompany) and subsiquent requests worked. This is how I know this callback assignment reaches father than that single method. Sure I could extend the callback to include all other certitificate names, but what I would rather do is set the 'ServerCertificateValidationCallback' back to its default behavior. Like the pseudo code below:
ServicePointManager.ServerCertificateValidationCallback = Nothing 'Default checking behavior
How do I remove the custom validation and set it back to its default behavior?
View 3 Replies
Jun 14, 2008
I know how to display or manipulate (add,delete,update,search) records using the OleDbDataReader and OleDbCommand class. But I'm clueless in getting the total record on a query.
View 1 Replies
Apr 25, 2010
I am using VB.net 2003. I am working on a stand alone windows program that stores data in an Access database via ADO.net via MS jet 4.0 OLEDb. I have progressed to the point that I would now like to provide the end user the oportunity to back-up the data they have stored and re-install if they choose. I am envisioning a menu item for "maintenance" with sub-items for "back-up" and "restore"
View 1 Replies
Mar 27, 2012
how to connect a visual basic front end with a MySQL back end. I am not proficient in VB or MySQL and was not able to find anything on google as a result.
View 1 Replies
Apr 28, 2009
I am having trouble Counting the number of rows in a specific column in a datatable.
View 2 Replies
Feb 18, 2009
I have an app written in vb2005 that allows users to search a sql database for a store name. Once a store is selected, it then presents the user with 12 different tabs, each with a DataGridView showing various bits of info about the store. It's a large and convoluted database, so I'm using stored proceedures to pull the data for each tab. Here's a sample of one of the subs that populates the tabs.[code...]
Now, this works just fine to populate the grids on the tabs, and the same code is copied into each of the subs that fill the grids (changing the stored proc, parameter and grid names, of course). The problem I'm having is how to move changes made to the data in the grid back into the database.
I have stored procs that do this (and the procs do work), I just can't seem to figure out how to trigger the stored proc when the user makes a change.
If it matters, there is only a grid on each tab, I did not use a binding source as I am trying to keep an abstraction layer between the data and the app. I did create a dataset, which is how I gain access to the stored procs, but I left the grids unbound and (as seen in my code) bind them at run time.
View 2 Replies
May 24, 2008
I wrote some code to update the count of a field in a table, but it is very slow. So I'm trying to do it in a subquery to speed things up, but I'm not very good with subqueries. I'm getting the error "Subquery returned more than 1 value".
[Code]...
View 1 Replies
May 6, 2008
I am working on a very simple application in Visual Basic 2008 Express.
The program has a Listview where I display the "DisplayName" field, the user clicks on a name and this should fill 3 text boxes. The code is:
strSQL = "SELECT FName, LName, DisplayName FROM tStaff WHERE DisplayName=@DisplayName;"
Dim conn As New OleDbConnection(strConnString)
[Code]....
This produces the error "Parameter @DisplayName" has no defaul value"
The value of the variable "strDisplayName" is correctly captured.
View 7 Replies
Mar 7, 2008
I need my program to connect to a database within my application i.e.What I have:
m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = C:Documents and SettingsmeroneyfMy DocumentsVisual Studio 2008ProjectsAsset Manager 2008inDebugDatabaseAssetManager.mdb"
What I need is: m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = DatabaseAssetManager.mdb"
I have used:System.Windows.Forms.Application.StartupPath & "ImagesSystemDefaultImage.bmp"
for loading of images within the default directory. but this returns the app path but also includes "System.Windows.Forms.Application.StartupPath" in the string?
View 3 Replies
Apr 24, 2008
What is the best way to set the default value for 'bit' or boolean data types in SQL express? I am using the data base explorer in VB Express 2008 and the only way I seem to be able to do it is by using ((0)) for false and ((1)) for true.
View 1 Replies
Mar 17, 2009
I'm working on a multi user VB.Net windows application with back end as SQL Server 2008 Express. The SQL Server is installed on the intranet network drive. This is the connection string I will be using. Is this correct?
Data Source=.SQLEXPRESS;AttachDbFilename=Q:DatabasePrintDB.mdf;Integrate d Security=True;Connect Timeout=30;User Instance=True
View 3 Replies
Oct 12, 2010
Can I make a certian function that will fade out [make a black screen that fades out for 2 seconds], then come back? Is that possible? ON A FORM.
View 3 Replies
Aug 25, 2009
I have a table inside my database, and i wish to insert/update/delete entries in a FormView Manner (I mean no datagrid) but a set of textbox/combobox/listbox/checkbox for one record. Before modifying/adding data i have to perform some extra checks to enter correct values to my database. How will i be best off doing it? I am currently using a datatableadapter to perform datatableadpter.insert, and also datatableadpater.update. How can i make use of datasets here and what is the best way for it?
View 2 Replies
Feb 20, 2011
The SaveFileDialog that opens up while clicking the export button of the CrystalReportViewer by default filters the predefined file types. Is it possible to custom define which files to be filtered?
View 5 Replies
Dec 6, 2011
Here is my case:I have a richtextbox called Rtb1 I have the text property for this control set to "ThreadAmountEdit=[Thread Amount]" This was set through the RichTextBox Tasks function, by clicking the control and selecting the little arrow in the top right corner. In working on my form, I edit the text "[Thread Amount]" of the rich text box to "45". What I need is to be able to reset Rtb1 back to default ("ThreadAmountEdit=[Thread Amount]")on button click.
I've tried: Rtb1.Refresh() which doesn't appear to do anything I've also tried Rtb1.ResetText() which completely clears the textbox.
View 2 Replies
Sep 16, 2010
I need to set a select back to it's default value after it's been changed based on certain conditions.
View 2 Replies
