I am New to VB.NET, Iam having a problem such as transaction numberDuplicatiion, Because so many users using a application, Some times transaction trnumber has been duplicatedIn my code i open LOCATION TABLE AND FETCH JOURNAL NUMBERAND INCREASE JOURNAL NUMBER WITH 1 AND THEN UPDATED.SOME TIMES JOURNAL NUMBER HAS BEEN DUPLICATED IN TRANSACTION FILE
View 1 Replies
Recently, I am working on the website where I am generating random number and storing it in database as the primary key. So, this key would be foreign key for many table, now how would I generate the random number and check if random number does not have duplication? Is there any function to check if number is not duplicate?
View 1 RepliesHere am using Autopostback true with drop down lists control
View 2 RepliesWe all know that we should only be publishing our ASP.NET Web Applications with release build type, so why do I not get a warning when I trigger the "Publish" command in Visual Studio 2008, for a project configured to build in debug mode? Sure, there might be cases where I need to publish a debug build to a development or test environment, but answering yes in a confirmation dialog would be acceptable in these cases. Is there an option that I have overlooked, forcing Visual Studio to warn me every time I try to publish a debug build? Yes, we could just ban using the "Publish" command and use a more solid build management tool, but this involves a change of process and right not be an option in this particular case.
View 3 RepliesThis is strange behavior that I've noticed with Visual Studio. I'm correcting some namespace and scope issues with in a project. When I start to address the issues with one of the files I start off with 12 errors. Then I open the file and the number of errors increase to 36. But then when the file is open and I build the project it says that there are only 12 errors. Why would it show that there are 36 errors initially when there are really only 12 when the solution is built?
View 1 RepliesI am trying to use a transaction scope in a transaction-per-request pattern. So I have a http module that do (simplified):
private void Application_BeginRequest(object sender, EventArgs e)
{
var scope = new TransactionScope(TransactionScopeOption.RequiresNew);
PutScopeInHttpContext(scope);
}
private void Application_EndRequest(object sender, EventArgs e)
{
var scope = GetScopeFromHttpContext();
try
{
if (HttpContext.Current.Error == null)
{
scope.Complete();
}
}
finally
{
scope.Dispose();
}
}
Then, in my web.config, I have:
<httpModules>
<clear/>
<add name="OutputCache" type="System.Web.Caching.OutputCacheModule"/>
<add name="Session" type="System.Web.SessionState.SessionStateModule"/>
<add name="Profile" type="System.Web.Profile.ProfileModule"/>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="UrlRoutingModule" type="System.Web.Routing.UrlRoutingModule, System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
<add name="TransactionPerRequestWebModule" type="Acme.Web.TransactionPerRequestWebModule, Acme.Web"/>
</httpModules>
<sessionState mode="SQLServer" sqlConnectionString="Data Source=localhostSQLEXPRESS;Integrated Security=SSPI;" cookieless="false" timeout="360"/>
Now, at what seem like randomly rate, roughly 1 page out of ten gives me the following error:
[SqlException (0x80131904): Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1951450
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849003
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2394
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteReader() +89
System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags) +516
[HttpException (0x80004005): Unable to connect to SQL Server session database.]
System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e) +229
System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags) +649
System.Web.SessionState.SqlSessionStateStore.GetItemExclusive(HttpContext context, String id, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags) +48
System.Web.SessionState.SessionStateModule.GetSessionStateItem() +117
System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +487
System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +66
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
What I (think I) understand is that the connection to the ASP.NET session database is sometimes enlisted in my business transaction, and I get this error when my business transaction is completing first.
There is a couple of problem with that:
I don't think the transaction for the session state should be the same as my business one. These are 2 separate concerns.
It makes the transaction automatically escalate to a distributed (MSDTC) one, which impacts my performance.
How do I decouple my business transaction from the ASP.NET session one?
Is there any way to increase the number of tab in VS 2008?
View 5 RepliesHow do I set the number of Most Recent Projects displayed. I have tried the obvious -- Tools-Options..... but I cannot see it.
View 9 Repliesis it posssible to autoincrement version number for every checki-in with TFS 2008? How?
View 1 RepliesI want to get the line number of my code -- not in case of an exception though. Is there a way to capture this?
[Code]....
When writing up a codebehind in Visual Studio for ASP.NET web forms applications, I often use the dropdowns at the top of the window to autogenerate page event handlers (e.g. Page_Load, Page_PreRender). I've noticed that sometimes Visual Studio likes to add numbers to these function names like "Page_Load1" or "Page_PreRender2".
View 2 Replieswhat exactly is the difference between build number and the revision number in assembly.cs file?
For instance the assembly version is 1.2.407.7890
Major = 1
Minor = 2
Build = 407
Version = 7890
Now when i make some change in the projects file and recompile it, only the version number changes. When does the build number changes?
In what scenario does the build number changes?
Also let me know what exactly is AssemblyFileVersion? How is it different from AssemblyVersion?
I was thinking of formatting it like this
TYYYYMMDDNNNNNNNNNNX
(1 character + 19 digits)
Where
T is type
YYYY is year
MM is month
DD is day
N is sequencial number
X is check digit
The problem is, how do I generate the sequencial number? since my primary key is not an auto increment integer value, if it was i would use that, but its not.
EDIT can I have the sequencial number resets itself after 1 day (24hours).
P201012080000000001X <-- first
transaction of 2010/12/08
P2010120810000000002X <--- second
transaction of 2010/12/08
P201012090000000001X <--- First
transaction of 2010/12/09
(X is the check digit)
I just installed Visual studio 2010 ultimate RC on my windows 7 server. It doe snot show line number. So I went to Tool->Option->Editor, however, there is no where I cna find line number choice.
I used to have Visual Studio 2010 professional beta, it has the same problem, no line number to show up. However, it has a check box: line number. Even if I check the box, still no line number to show up.
How do I specify a port number for a Data Connection in the Server Explorer of Visual Studio 2008. It would use 1433 as a default but the administrators changed it for security purposes.
View 2 Repliesis it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project
my current project references
i have a very annoying iis problem
iis server stops working until app pool is recycled
i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem
Anyone know if I can maintain a VS 2008 (.net 3.5) project by using the VS 2010 IDE ?
View 1 RepliesI have a stored procedure which is part of the aspnetdb but i am using my own database and therefore these stored procedures are added on my sql server locally.So i uploaded the databases to my hosting company 1and1 and created the stored procedures and tables as those in aspnetdb but i get the error as in the title. this is a standard stored procedure which lives in the aspnetdb database but not sure why this is happeningthe code is below which is for aspnet membership createuser a standard stored procedure
[Code]....
where to find/download visual source safe plug in or visual source safe client for visual studio 2005 IDE?
I do not want to install visual source safe 2005 server.
Is it possible to migrate the application which is in visual studio 2003 to visual studio 2010. provide me details about how to migrate.
View 2 RepliesI have a site in production developed in 2005 and i am planning to migrate to Visual studio 2010. Is there an easy way to do it?
View 1 RepliesI want to use a source control in VS2010, I know my best bet is TFS, but at the moment TFS(can't afford ). As i understand TFS is the new VSS_2005(can afford)Can VSS 2005 be use as a source control for VS 2010 solutions/projects?
View 2 RepliesI just recently upgrade my asp.net web project from visual studio 2005 to visual studio 2010. The upgrade was successful with no problems however im missing some features with this project. The One Click Publish feature(which is greyed out) in the header area of Visual Studio 2010 and the Add Config Transforms feature which is no where to be seen when you right click on web.config. When i create a new web project straight from visual studio 2010, these options work fine.
View 1 RepliesVisual Studio 2010 Beta 2 locked up, and when I tried to restart it, it wouldn't load, so I did a devenv.exe /resetuserdata to get it going again. It reset everyhing in my options of the web app/ etc, and now some AJAX conrols don't work such as dragpanel. I assume that it is because something got reset that I haven't enabled again, but can't figure it out.
View 2 RepliesIm working on a website project with Visual Studio 2010 from 2 different computers (home & work).
In Dreamweaver Im used to FTP to upload/download files to/from a webserver to syncronice my files on the current computer Im working on.What is best option in Visual Studio 2010 to sync project files between home & work computers? I have seen there is a built in FTP, but seems only it can upload files, limited functionality?
