I am developing an application that runs on a network. It needs to contact to database (access database) very very often, which is stored in server. Around 30 Client computers contact the database almost every 2-3 seconds. I need to know could there be potential manifest problem in with the application? Could there will be a problem if database is being updated by one client, at the same time other client contacts it?
View 3 RepliesI have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
View 1 RepliesI have got a MySQL database stored on a remote server. I can user PHPMyAdmin to access the database and make changes to the table, i can also use a third party piece of software to do the same however when i try and access the database through my program it says that "Access denied for user 'lukefrost'@'%' to database 'PHCAdminSystem'". However it will allow me with the same logon credentials the other ways explained above. Can anyone help me with what the problem might be?
View 1 RepliesI am using stored procedures in my application using vb.net, while executing stored procedures on mysql database server thru application, the response time from the server is more. Is there any settings that i need to set on mysql db server or any changes in connection string or in code.
View 14 RepliesThe store procedure which give me the information I need is:
USE [UCSMIS]
GO
SET ANSI_NULLS ON
[Code].....
When I try to add it to my report it gives an error, is it because of the temp table and how should I go about it?
I need to do this in the MDI: Generate Form1 to maximize the potential in MDI. And mdi form to generate second Form2 order has always been above Form1. When clicking on the form 1 form2 disappear under it. Normally, when you click on the form1 Form2 hides under it. All must appear in the MDI.
View 2 RepliesI've been having difficulties with a Win32Exception related to the Drawing.dll. After many man-hours of research and a couple creative attempts to work around it, I'm left with the likelihood that the cause of my angst rests with a .dll file provided by the vendor of the database against which I'm querying and through which I'm attempting to post updates. The vendor stated that the .dll wasn't designed with VB 2008 in mind. Though the .dll still posts the data, it's possible that something in its function is causing hiccups with the redrawing of my form and its associated treeview.
View 2 RepliesUntil now, I have not create any massive applications using ASP.Net. However, I am looking to create an application that has the potential to be very performance intensive. So I am looking for some tools or best practices when it comes to performance. I would like to be able to know how to:
See my current performance (good or bad) View items that need fixing And being able to compare two performance variable items would be great as well.
I have that code running into a windows service and the service seem to have a memory leak, something is wrong for sure. After looking at the whole code, I think it might be inside one of these function but I cannot seem to find where it could be.
[Code]...
Some question about Ado.net and SQL Server stored procedures. We have a stored procedure in SQL Server as described below
Procedure dob.PendingCalls
@UsID As Char(10), @Sts As Integer OUTPUT , @Msg As VarChar(100) OUTPUT
AS
Begin
[code]....
we are using vb.net in visual studio 2003. Now if ExecuteNonQuery is used then we do not get rows. If ExecuteReader is used then we get rows [ with forward-only access which is of no use to us] but we cannot get output parameters values returned by stored procedure?
I am using the following stored procedure to call period numbers to match them to teachers.We are writing an attendance taking application where upon selecting the teacher's name from a dropdown menu, the "period" dropdown menu populates. For some reason we are not getting the period data to populate.
Stored Procedure:
ALTER PROCEDURE spGetPeriod @Period varchar(10)
AS
SELECT Period
FROM tmTeacher
[Code]...
So I want to erase the guid @value from the database and retrieve the return value from my stored procedure [code]object name 'value' not valid..Net SqlClient Data Provider0.
View 4 RepliesI'm trying to figure out a way to save all the stored procedures on a SQL Server 2005instance to text files. One of our developers has made a huge amount of StoredProcedures,and theseneed to be managed somehow between our test / integration and production environments. I know how to retrieve / run / create stored procedures, it's just the "save-to-file" i need.
View 2 RepliesSTORED PROCEDURE
ALTER Procedure [dbo].[usp_validatecard](
@CLUBCARD1 nvarchar(50),
@STATUS nvarchar(50))[code]....
What I am trying to do is if the clubcard parameter is found and status is active I would like the label to read 'card is good' also if the clubcard parameter is found however is inactive then the label should read 'card is good but not active' last if all those fail just have the label read 'card not in system'As of right now this code does not work I thought I could just call the stored procedure and exec it and it would print the statements depending on what passes however it is erroring out. When I debug it the error I get is under the cmd.parameters.add is
Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
I want to execute a sql server stored procedure in vb using a button. The stored procedure as one variable that is read from a text file.I got it to read the variable from the text file but don't know how to execute the stored procedure.
View 1 RepliesThis is my Stored Procedure Code to get the customer mobile value:[code]I was try to get this value into lblGetCustMobile (Label Control) using this [code]but nothing happened, can any one make this code get the mobile NO. into lblGetCustMobile?
View 3 RepliesI am using vs 2008 doing a winforms app in vb.net. I have a database with a single table, that has two columns, in it and a stored procedure. The stored procedure is supposed to take an input value, match that value against one column in the table and then return the corresponding value from the other column; except it doesnt.It returns 1 or 0
ALTER PROCEDURE dbo.getgamenumber(@outputnumber bigint OUTPUT,
@inputnumber bigint)
AS
SELECT @outputnumber = ggnumber[code]......
but I still dont get the value I expect.
This is a bit old-contents to be discussed but I need someone who can explain me how to create stored procedure in SQL Server for returning a value from procedure, example:[code]Then I need the name of its customer and the address instead.I need to make it as a stored procedure and show me how to execute it on VB.NET. Perhaps we assume that the name will be prompted to LABEL1.TEXT and the address will be prompted to LABEL2.TEXT. I've improved this SQL-Server Stored Procedure Using return but I have nothing to return after I execute it.[code]
View 1 RepliesI've read that making a class sealed in C# is advisable in high-performance scenarios because it frees the compiler to make certain optimizations (e.g., inlining property getters) that it wouldn't be able to make otherwise. Is the same true for NotInheritable in VB.NET?
View 1 RepliesCreated an XSD file that represents my table structure from my database. Created a class file to hold my functions such as the one below.
Code sample:
Public Function GetUser(ByVal UserID As String) As xsdUser.UserDataTable
Dim SqlConn As New SqlConnection(ConfigurationManager.ConnectionStrings("MyDatabase").ConnectionString)
[Code]....
Now it seems odd to me to have two files doing what should be contained within just one file. I feel like I should have one class file called "User" and have member variables in there along with the class functions like the one above. But all the tutorials I see are using these data tables. On top of that I'm not sure how to handle the if statement at the end of the function. I don't think I would want to return a whole DataTable since I should only have one row, and I also don't know how I would handle an error if my function is supposed to return a data table. I suppose I could return an empty one and then if the table is empty in my code then I would handle it there, but this also seems messy.
Is this the common way of retrieving information from a stored procedure? Or is there a more up-to-date method that I'm not seeing in my search results?
I have a problem trying to link my my datagrid view to my sql server stored procedure. The way it should work is that when I select an item in a list from my combo box it returns a set of rows on the datagrid view specific only to that item This is the code on the server sideCREATE PROCEDURE spCompanySearch
[Code]...
The @comp is supposed to be each item in the combobox list but I don't know how to do it or how to go about it
I want to create a stored procedure in SQL server 2005 in order to check if there a specific value in a table. As I don't know how to do this can someone give me a link or an example on how to create and store the stored procedure? Secondly I wrote this for my the above stored procedure: CREATE PROCEDURE dbo.dokimi -- Add the parameters for the stored procedure here
[Code]....
One of the things that I am not sure is that I want to check the value that the user passes throuhg my application that I am creating. In the above code this exists in the select query @txtUserName.text. Is this right? Can I use it like this or should I declare something more after the create procedure statement?
I have a database designed and implemented using ms sql server 2005. initially, the user has entered the pictures with a very big size because there was not restriction. now when the user is opening the crystal report so it takes alot of time and some time memory full problem occur. now i want to reduce the stored images size using vb.net. is it possible? can you help me.. because there is nothing impossible as per my experence.
View 5 RepliesAll of those disadvantages of stored procedures (database portability etc.) I am now facing. We are going to migrate our VB.Net/ASP/SQL Server application to something like Mono/Postgresql and fully internationalize.
One of the many issues we face is that we have 800-900 stored procedures. What we are thinking of doing is moving the logic in these SP's in to the application code. I have searched around for how people have done this or how it can be done however I have found very little. Most of the info on stored procedures is about what should be in them etc. So I have come to the conclusion that the best way to approach this is to leave the SQL retrieve/update type queries as stored procedures and move the ones with business logic in to the application.
In my VB.NET code I construct a ODBC.COMMAND to call a stored procedure that eliminates a record from table in SQLSERVER 2008, I use this code in a FOR NEXT loop, it may contain 1 to 20 records_ID to pass to stored procedures to delete the records.
This code work well for several months, but since the last compilation it only deletes the first 2 records.
In debug mode in VS 2008 IDE works fine.
VB.NET CODE
''' <summary>
''' DELETE CANCELED CUSTOMER ORDERS
''' </summary>
[Code]....
I have a small question about stored procedures and the DateTime2 datatype in SQL Server 2008.
I got several stored procedures using the DateTime2 datatype and I want to insert the date 0001.01.01 00:00:00 but this won't work with VB.net and I cannot find the reason why.
I use this code fragment:
Dim sqlStatement As New SqlClient.SqlCommand
Dim sqlTransaction As SqlClient.SqlTransaction
sqlStatement.CommandType = CommandType.StoredProcedure
[Code]....
to call the stored procedures from my program (the stored procedure is a simple INSERT statement nothing else and works fine with actual dates). But when I enter the date 0001.01.01 00:00:00 it always comes up with the error that I cannot insert dates before '01.01.1753' when I want to execute the stored procedure.
Now I already know that the DateTime2 datatype in SQL Server should support this.
So my question is it possible that this is a driver problem and updating the SQLClient would solve this, or is this a general problem and I can finally stop searching and just use 1753.01.01.
I have a class with a static list of keys, and I have a static method called Remove() that removes a key from that list.Now what I understand from the contracts post conditions is that as the programmer of the class, I guarantee that the current public method does something specific, in this case : removing the element of the list.
Here's what I've written:
private static List<Keys> m_usedKeys; // private list of keys
public static void Remove(Keys _key)
{
[code]....
What I'm trying to "Ensure" here, is that the Remove() method removes the key for real from the list (Yes this might be a trivial example, but I get the error there.)when I write the Contract.Ensures() line, VS2010 gives me the following error :
Error 3 Detected expression statement evaluated for potential side-effect in contracts of method 'LibJungleTimer.KeyBind.Remove(System.Windows.Forms.Keys)'. (Did you mean to put the expression into a Requires, Ensures, or Invariant call?) C:UsersJoelDocumentsProgrammationJTJungleTimerLibJungleTimerKeyBind.cs 51
I think this error says that the expression m_usedKeys.remove(_key); has a potential side-effect. In fact, it has a side-effect, it removes a key from the list!If I try to write something like this instead :
Contract.Assert(!m_usedKeys.Any(x => x == _key));
well it compiles fine.
I am using sql server 2008 as database server. I have created "AddTest" stored Procedure and using it in my app,
Dim cn As new SqlConnection(connStr)
Dim da As New SqlDataAdapter("Select * from dbo.Subjects", cn)
Dim ds As DataSet
[code]....
I found a few examples online on how to import excel into sql via vb. but can i do it via stored procedure?
Insert into SQLServerTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D: esting.xls;HDR=YES',
'SELECT * FROM [SheetName$]')
So like, can I pass in:
('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D: esting.xls;HDR=YES',
'SELECT * FROM [SheetName$]')
As a parameter to SQL Server SP?
how to Pass datatable as a parameter to a SQL Server stored procedure
View 3 Replies