|
|
Hi,
Imam using this to close the connection but I feel after many entries that the system will be slow and it will take a very long to run the process.. so is this enough:
if (sql_reader != null) sql_reader.Close();
if (sql_connection != null) { if (sql_connection.State == ConnectionState.Open) sql_connection.Close(); }
Technology News @ www.JassimRahma.com
|
|
|
|
|
That'll close the reader and the connection, but will not dispose of it - leaving that to the GC. Ideally, they'd be wrapped in a using-block.
Jassim Rahma wrote: I feel after many entries
You're not opening/closing the connection in a loop, are you?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
You're not opening/closing the connection in a loop, are you?
what do you mean?
I tried this now and will observe it for sometime:
if (sql_reader != null) { sql_reader.Close(); sql_reader.Dispose(); }
if (sql_connection != null) { if (sql_connection.State == ConnectionState.Open) { sql_connection.Close(); sql_connection.Dispose(); } }
Technology News @ www.JassimRahma.com
|
|
|
|
|
Jassim Rahma wrote: what do you mean?
for (i = 1 to 5000)
{
IDatabase idb = new SqlDatabase();
idb.Open();
ICommand.ExecuteNonQuery;
idb.Close();
}
Jassim Rahma wrote: I tried this now and will observe it for sometime:
Observe it? To see if it behaves? 
Are you also disposing of the command?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Summing up what was indirectly referred to in the other response.
When you close a database resource, like a reader or connection you should also call Dispose. There are different ways to do that. You should do it EXPLICITLY in your code and you should not rely on garbage collection to do it for you.
When you close a data reader it can take time. That is implied in the documentation for close. If you don't want it to take that long then don't do as much with it before you close (and dispose) it.
Jassim Rahma wrote: I feel after many entries that the system will be slow a
Your belief is probably ill founded. Resource management, when done correctly, will seldom even be measurable much less significant in an application. What is likely to be far more significant is what you actually do with the database and how you do it. So for example it takes far more time to do a database query than it does to close/dispose of the connection you used to do the query.
|
|
|
|
|
Hello to all
I have an application in LAN on a page that contains a GridView I want to disable or prevent
The edition of a line when it is already in edit mode by another user
Thank you.
|
|
|
|
|
Why! This sound like you can't work out how to manage a multi user application rather than a valid technical question. Your requirement would mean locking the table on the server so no other user can add/edit/delete a record. A truly nasty requirement.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello,
When the user clicks the Edit button it takes a little time to validate the line
I do not want another user treats the same line.
Thank you.
|
|
|
|
|
Why not, why can't 2 or 10 or 100 users be editing/adding the data, it is common that last in is the winner. 2 people begin editing the line, first person to save the changes loses those changes when to 2nd person saves, unless you are doing column comparisons.
This is the normal way of building an applications. Only managers worry about the 2+ editor problem, the rest of us live in the real world and just build the app.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello
I do not want a user to waste time processing a previously handled by another knowing that the treatment takes more than a minute online.
Thank you.
|
|
|
|
|
Now that is a different matter, if the source of the data is external to the system then you need an external process. If the data is selected by the user to process then put in place a selection process in your system. The user should "lock" the record when they select it for processing, then release it when completed.
I would use a dialog instead of a data grid. The user selects a record you flag it with a username and time and pop a dialog. When the dialog is closed you release the record.
You could also queue the records to a user, user 1 requests some records to process you deliver 1-5 for that user, user 2 requests some work so you deliver 6-10.
You need also need a repeating check for locked records older than a reasonable time span.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Locking, technet[^]
You can lock a single row[^] once someone starts editing.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Please I am a beginner in asp.net can give me an example.
Thank you.
|
|
|
|
|
You can't do this in ASP.NET. Well, not without a VERY COMPLEX solution.
Web servers cannot arbitrarily contact clients whenever they want. HTTP always relies on the client contacting the server for data and the server responding with the requested page. It NEVER goes the other way around.
You would have to use an out-of-band, TCP/IP-based client/server soltion, such as SignalR, to pull this off. But, you have a problem. What if one client "edits" a record, locking it for everyone else, and then that client either crashes or otherwise never submits any changes?? How are you going to detect this condition and unlock the record for other clients?? Not easily...
Really, this is WAY too much work to go through just to overly complicate your client pages for something that can be done with far better, and more reliable, concurrency control methods, such a SQL Timestamps. Google it.
|
|
|
|
|
I am using AjaxFileUploader to upload multiple files in my ASP.net project.
I want to validate RequiredFieldValidator on It, Means at least one file must be Upload before submit Form.
My Code is:
<ajaxtoolkit:ajaxfileupload
id="ajaxUpload1" throbberid="MyThrobber1" maximumnumberoffiles="5" runat="server" allowedfiletypes="jpg,png">
How can validate this control as Requiredfiled, because Simple RequiredFieldValidator does not work on it.
is there any other solution ???
|
|
|
|
|
Hitesh Vaghasiya wrote: I am using AjaxFileUploader to upload multiple files in my ASP.net project.
Then you should be using the ASP.NET forum.
Veni, vidi, abiit domum
|
|
|
|
|
Thanks for reply.
i have already find to asp.net forum.
but i can't got the solution.
if possible than please help me.
i am using VS 2010 and Ajax Toolkit 4.0.
If server side validation possible for that control than please send me code for that also.
Thanks Again ...
|
|
|
|
|
I don't know ASP.NET, which is why I told you to post your question in that forum. This one is for C# questions.
Veni, vidi, abiit domum
|
|
|
|
|
Are integration tests worth the trouble?
I personally don't like integration tests, or at least not when they're mixed in with unit tests. They are much more costly than unit tests and their benefit seems to be minimal. There was a time when I had to write lots of them for legacy code. They were complicated, took ages to write, forever breaking, very hard to fix and took ages to run. As far as I can see, if you have good unit tests, then the only real benefit is verifying that the IoC container is configured correctly and the config is passed through correctly. All of these things will get picked up by minimal manual or automated UI tests anyway.
The time they take to execute is a bit of an issue for. I like to do TDD and like to run all tests after most changes. This isn't practical with Integration tests as they take too long to execute, so I then need to find the test(s) I want to execute and choose those instead of just using a keyboard shortcut. Does anybody know a good way of separating them?
Does anybody know a better place for doing these kind of tests ie. no in MSTest or NUnit?
|
|
|
|
|
|
I am navigating Excel sheet in WebBrowser control.
eBrowser.Navigate("D:\test.xlsx", false);
if I am updating something in excel sheet which is displayed in WB control then I want to save that changes back to location or wants to import sheet with changes in data table.
I tried to get WB control document on Navigated and DocumentComplete event but always getting wb.Document as null.
So please help me to save the Excel from WB on button click.
I don't want to use ctrl+s option which we can use to save excel directly.
Regards,
Raj
|
|
|
|
|
|
this is my code
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (connect.State == ConnectionState.Open)
{
connect.Close();
}
connect.Open();
String query = "select * from V_General_Books where FileName= '" + FileNameComboBox.Text + "'";// '" + textBox2.Text + "' and UserName= '" + textBox3.Text + "' ";
cmd = new SqlCommand(query, connect);
dr = cmd.ExecuteReader();
if(dr.Read())
{
string bookid = dr.GetInt32(10).ToString();
BookIDTextBox.Text = bookid;
string generalid = dr.GetInt32(0).ToString();
GeneralIDTextBox.Text = generalid;
string isbn = dr.GetString(12);
ISBNTextBox.Text = isbn;
string author = dr.GetString(11);
AuthorNameTextBox.Text = author;
string genre = dr.GetString(16);
GenreTextBox.Text = genre;
byte[] x = (byte[])dr[8];
MemoryStream ms = new MemoryStream(x);
pictureBox1.Image = Image.FromStream(ms);
string series = dr.GetString(15);
SeriesTextBox.Text = series;
string year = dr.GetString(14);
YearOfPublicationTextBox.Text = year;
string dateacquired = dr.GetString(9);
DateAcquiredTextBox.Text = dateacquired;
string filename = dr.GetString(1);
FileNameTextBox.Text = filename;
string filepath = dr.GetString(2);
FilePathTextBox.Text = filepath;
string length = dr.GetString(5);
MediaLengthTextBox.Text = length;
string type = dr.GetString(6);
MediaTypeTextBox.Text = type;
string subtype = dr.GetString(7);
MediaSubTypeTextBox.Text = subtype;
DateTime dateadded = dr.GetDateTime(4);
DateAddedDateTimePicker.MaxDate = dateadded;
string filesize = dr.GetString(3);
FileSizeTextBox.Text = filesize;
string description = dr.GetString(13);
DescriptionRichTextBox.Text = description;
string title = dr.GetString(17);
TitleTextBox.Text = title;
}
connect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
|
|
|
|
|
Check SQL query in SQL server query wizard. The problem is with the SQL query. Whatever the query you written is not fetching any data from database. That is the reason why it's saying no data available.
Cheers,
Purna Chandra Rao.Ch
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
