i would like to write a streaming programming which will keep updated or query the database. I would like to use a connection instead of open and close connection on each transaction. But the streaming programming would not end, running at all the time. So, is it any effect if i am using only one connection (within a long period). Such as performance, timeout issue, or others exception.
View 1 RepliesI want to know that What are the factors if we use methods on each .cs page for connection and executing query on each aspx code behind page rather then using BAL .
How our application get affected in terms of performance and speed or other way?
when we put our website on server after publish/compile in general approach (using query in C# code behind) rathor than using stored procedures?
then which logic is better and why ?
I have a site with potentially very long running SQL queries and verification process. The user would have an idea how far along they would be by the part number currently being analyzed in the process. I've done a lot of reading and have determined that setting up a two way socket with the client would be the best way to communicate this information to the user. Are there any vb examples out there on which I could base my code?
View 5 RepliesWe are storing the WAV file into a database table as VARBINARY(MAX). We want to play the WAV file directly in a web page. We want to use PLAY, PAUSE and STOP for these WAV files.
We want the user to have a Control on the page to play the WAV file.
Here we DO NOT want to store the FILE in the Web Server's file structure. It is againt the SECURITY policy.
We tried different ways. Nothing is working. We used SoundPlayer class. Using this, we can only PLAY and STOP but can not PAUSE the WAV file.
I am working on live trading system, in this web system i have to show live data so i am calling my store procedure for bind my data. I have few questions -
Is it possible to use MSMQ in web ?
Is it possible to use socket programming in web ?
Its because i am calling SP in every 5 seconds and its very lengthy. I want to use socket programming or MSMQ in LIVE trading system because if any thing update or modify in tables then only web page get notification from MSMQ or Socket and i will bind my page then only. And if possible then its secure and perfect for web live environment ?
how to control camera through Asp.net sessions and Asp.net application programming architecture
View 2 RepliesI am trying to develop a chess application in asp.net (C#). I am very confused about overall structure of the application. I am just unable to figure out the complete model (or prototype) of my project. As chess programming should be very efficient in memory consumption and speed, can someone provide me a good idea , how should I develop my application. Currently, I am taking a class named 'Chessboard' for my project and its objects are chesspieces ( pawn,king,queeen). I am initialising each object with some properties (type, value, color etc). But its quite complex. I am having 32 objects in this approach.
View 1 Repliesbut I am rather confused about what to invest in. I heard that server-side code translates into client-side code. So, if you have an .aspx file, it will be converted to HTML/CSS/JavaScript. I have experience with the latter three technologies put into a rather dull text file and rendered by a web browser. My question is how much HTML/CSS/Javascript coding would I have to do when server-side programming? In other words, can someone using ASP.NET program purely on the server side and not bother to write for the client side? Of course, I don't care about server-side being translated into client-side, but I am wondering if client-side programming needs to be done explicitly and to what degree.
View 4 RepliesQuestion: I have an annoying problem with nhibernate.The problem is I cannot get any example I find on the web to work... I've now tried for two days...
The first problem was it wouldn't read the config file, so I had to move it into app.config / web.config.
The second problem is that whatever I do, I always get an error:
No persister for: NHibernate.Examples.QuickStart.User
I've searched google and I did change the mapping to embeded ressource, and I did add the mapping to the config file, but nothing helps...
The example is from this page:
https://www.hibernate.org/362.html
I've uploaded my Visual Studio 2005 project to
http://daniel-steiger.ch/exchange/NhibernateCrap.rar
I have a silverlight application project in my solution. The other project is a web application project that has a .xap file in ClientBin.
When I created the silverlight project, it asked if I wanted the asp.net application to host it (and I said yes).
In the root directory, there is a test page for the silverlight control. That loads the control.
In another directory, I insert the SAME asp markup to get the silverlight control to launch again.
Nothing happens.
Why would the silverlight launch on one page and not on the other? how to documentation about dependencies that I might not know about?
I've put a reference to Silverlight.js on the page as well.
Here's the markup:
[code]....
In Crystal Reports Viewer (2008) for ASP.Net, when you click on the Export button, the Export dialog shows up with File Format options:Crystal Reports (RPT) PDF Microsoft Excel(97-2003) Microsoft Excel(97-2003) Data-Only Microsoft Word (97-2003) Microsoft Word (97-2003) Editable Rich Text Format (RTF) XMLhow to remove some of these options so that end users wouldn't see it?
View 1 RepliesI have a gridview set up as follows:
[Code]....
Now, as you can see I've set up the commandargument, and was expecting to get to that in my code behind file. My code is as follows:
[Code]....
Ok...so far so good, and as long as I'm the only one working on the system it works fine. The problem is if this scenario happens:
* I go to the page and look at the gridview
* Someone else enters a new record into the database, causing the first row to contain a new record (not displayed in my browser)
* I click select.
What happens then is that, for some odd reason, I will get n numbers higher than the one I actually selected (n = num_added -num_removed).
I was under the impression that the commandargument wouldn't change for my session as long as I didn't refresh the gridview...?... There are no ajax or anything else messing with postbacks or viewstate as far as I can see..
i would like to know if there's something wrong in this asp.net code:
mydatareader = mycmd.executeReader()
if myDataReader.HasRow then
// Do something
end if
myConnection.Close()
If i avoid to call a "MyDataReader.Close()" does the connection close anyway ? I ask this because i'm assuming that if call a "MyConn.Close" it automatically close the associated datareader... or am i wrong ?
I have th following code:
[Code]....
I got any error from the code, saying 'not all code path return a value', i suspect it is the catch block doesnt return a value. If so, what value should i return?
When i connection on database Microsoft SqlServer 2008 By This code.
Code:
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from [City]", cnn);
cnn.Open();
Code In configration Manager
Code:
<add name="myconnection" connectionString="Data Source=.;Initial Catalog=db;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
found this Sql Exception:
The user instance login flag is not supported on this version of SQL Server. The connection will be closed. what is problem?
i have 5 methods in classA. each and every methods i have open the sqlconnection and close it, instead of that is there anyway to create a sqlconnection at one time if its opened then no need to create a new connection, if its closed then we have to connect.
View 5 RepliesI always use SqlConnection() To open a connection then use the connection to interact database. But I have heard somewhere that opening SQLconnection() take a time. and if on different pages of projects I repeatedly Connect database then It will take long access time always. So I want to know that if there is any other methods which don't use the SQLConnection to interact database and increase the response time of database.
View 1 Repliesso i have the function below in a webservice. and it works, but when i try to copy it to aspx page code behind, i get the message in the subject. Can someone tell me if the function below is valid? One of my project uses it and it works.
[Code]....
in my application when i type sqlconnection it is not showing any intellisence, i added the namespace System.Data.Sqlclient not only sqlconnection even i am not getting Page calss can u help me.actually i am sharing this application from my company server.
in our company previously there was .net 2.0 frame work when this project was developed(one year back).
yesterday our company installed 3.0 .net frame work is this any problem for previous project which are developed in 2.0 how can i go through this problem.
Is it possible to use a pre-existing ConnectionString in this construction?
myConnection = New SqlConnection("server=localhost;" & "database=pubs;Trusted_Connection=Yes")
Regards -Penn
I have a whole bunch of data access methods where in each one I am doing this
[Code]....
and them moving on with my SqlCommand and SqlDataReader and so on.Is this creating to many instances of an SQLConnection?I was thinking doing this instead. Creating a SqlConnection Manager which would look like this
[Code]....
and then in my database access methods
[Code]....
Is this a good or bad idea and why?Also would this even be neccesary?
Because of the way the server is set up I'm using, I don't think I can use Integrated Security=SSPI in my SQLConnection string. However, I'm a bit wary of giving the database username and password in the connection string in a aspx.cs file. Is there any way of making it more secure?
View 3 Repliesi am making a simple cms system
but I have a problem when updating some information
here is the code
[Code]....
and in the page load everything is fine
[Code]....
'SqlConnection' is not defined in the behind code as follows:
Source Error:
[Code]...
Source File: I:WebsitesCMPHostFox BackupDefault.aspx.vb Line: 24
Snippet reads as follows:
[Code]...
can capture return value from a SQL by using SqlConnection SqlCommand
[Code]....