|
Hi
You could use reflection for this.
----------------------------
Be excellent to each other 
EasiReports[^] My free reporting component for WinForms.
|
|
|
|
|
how? is there an example somewhere out there?
|
|
|
|
|
In a windows application(C#) I am working on,I have 5 threads accessing data from a table and running one after another.I want to lock data for each thread when it is accessing data ,so I have used "for update" in my select statement but it doesn't work.Every thread when accessing data sets one flag in the table so that other threads should not select this data again,but some times 2 or 3 threads access the same row .Any help to lock the rows please.
Thank you.
|
|
|
|
|
The time we have to did this, we have to create anhoter table in the database with information about the tables or rows locked.
I mean.
One Method to lock
Lock ( string TableName )
Lock ( int[] RowsIDs )
UnLock ( string TableName )
UnLock ( int[] RowsIDs )
Write this info in a table, and when the data is queried to the database do a Join with the rows of this table.
Also we add a delay of 5 minutes to set free the rows, because someone can forget the UnLock.
Regards
Ricardo Casquete
|
|
|
|
|
How draw formatted text in cell DataGrid
e.g. This text have different format Font
------------
piotrbla@poczta.fm
|
|
|
|
|
simply use the e argument of Cell_Formating event of your grid.
|
|
|
|
|
Use DataGridView control...
It is more powerfull then usual DataGrid...
|
|
|
|
|
Is there any way to make property grid values color changed in some
cases based on certain scenarios. I only wanted to change right side
values of some grids in property grid. Is there is any way to do this
plz let me know it( whether it is reflection or any other thing ). Also
another issue to make property grid readonly which i dont think any
body know.
Thanx in advance..............
|
|
|
|
|
You can.
There easier way in my opinion is to add the code for formating the cells in the Item_DataBound method.
In the Item and Alternate Item, do a loop to iterate for the cells of the Row and Set the Style you want
Ricardo Casquete
|
|
|
|
|
Thanx for ur reply.........
Now problem is that i have to change color of text of some grids not all of them. So can u plz give some code snippet that is applying what u said means Item_DataBound method.
Thanx again
|
|
|
|
|
Ok... give me a minute....
Ricardo Casquete
|
|
|
|
|
Drag and Drop any table to geenrate the SqlDataAdapter, Drag and drop the Grid and genereate the Item dataBound code...
and copy this
<br />
private void Page_Load(object sender, System.EventArgs e)<br />
{<br />
this.sqlDataAdapter1.Fill ( this.dstCategories1 );<br />
this.DataGrid1.DataBind();<br />
}<br />
<br />
private int i = 0;<br />
private int j = 1;<br />
<br />
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)<br />
{<br />
if ( ( e.Item.ItemType == System.Web.UI.WebControls.ListItemType.Item ) || ( e.Item.ItemType == System.Web.UI.WebControls.ListItemType.AlternatingItem ) )<br />
{<br />
if ( i % 2 == 0 )<br />
{<br />
e.Item.Cells [ 0 ].BackColor = Color.Aqua;<br />
}<br />
if ( j % 2 == 0 )<br />
e.Item.Cells [ 1 ].BackColor = Color.Red;<br />
else<br />
e.Item.Cells [ 2 ].BackColor = Color.Yellow;<br />
<br />
i++;<br />
}<br />
j++;<br />
}<br />
<br />
Regards
Ricardo Casquete
|
|
|
|
|
Thank u very much for ur reply
i will look into it and c what i can get from it
thanx alot............
|
|
|
|
|
Sorry to bother u again................
Actually i was on vacations and was not able to check what u had given to me.
First of all the code u given is for datagrid. Will it work for propertygrid fine as well............................
Thanx in advance.
|
|
|
|
|
I want the source code in c# datagrid for doing calculation like addition ,multiplication(in rows or cells) and i want to insert data from datagrid to sqlsever2000
I am a software developer in
c# dotnet located in bangalore india
|
|
|
|
|
I was wondering about the implementation of StreamReader.
I have a big file it can be about 2 gigabytes.
In the constructor, I constructed the StreamReader with a big buffer.
The question is if I use ReadLine does it work only with the buffer until it ends and then loads a new buffer or does it work with the file every time ?
I need it to be the most optimized possible.
If it doesn't work this way, do you know how to work with files in C# that don't work with streams and that I can implement it alone ?
Thanks, Clint
|
|
|
|
|
Explain what you are trying to do, I think I may have a solution. In general, it helps to post a little background but just enough to give an idea of what is going on.
|
|
|
|
|
Ok, I have actually 2 files.
Every file is a text file.
Every file is built out of vectors which the first column contains the date and time of the line.
I need to merge the two files so that in a each time stamp I will have a united vector of both files.
for example :
File 1:
10/2/2000 10:00:00 10 20 30 40 50 60 70 80
10/2/2000 10:00:01 13 18 30 25 54 12 9 8
10/2/2000 10:00:02 30 40 2 3 5 8 9 9
File 2 :
10/2/2000 10:00:00.1 FunctionA
10/2/2000 10:00:00.15 FunctionA
10/2/2000 10:00:00.2 FunctionB
10/2/2000 10:00:00.4 FunctionB
10/2/2000 10:00:00.6 FunctionB
Merged File :
10/2/2000 10:00:01 13 18 30 25 54 12 9 8 2 3
This an example only for the time 10:00:01.
What I am doing taking the time, date and the rest of the vector from the first file.
I check between every interval in this case 10:00:00 and 10:00:01 what happend in the second file, FunctionA happend twice and FunctionB happend 3 times, therefore in the merged file the 2 3 are placed in the end.
I built a program that does that, but it takes a long time to merge the files.
I was wondering whether I should implement the reading somehow else.
Thank you for your help.
Clint.
|
|
|
|
|
Hi
What is your actual req ? I think Streamreader will get slow if handles with big files. so better use Filestream. It can create byte arrays according to file size.
Cheers
|
|
|
|
|
Navaneeth.K.N wrote: I think Streamreader will get slow if handles with big files. so better use Filestream.
Why do you think that?
A StreamReader uses a FileStream to read the file, it doesn't read the file itself.
---
b { font-weight: normal; }
|
|
|
|
|
I replied before about what actually I want to do.
Please read and if you can help return to me.
Thanks,
Clint
|
|
|
|
|
I have already read that, and I can not add anything to what I have already said without any specific information on how you handle the data. If there is performance problems, it's not likely to be because of the StreamReader.
---
b { font-weight: normal; }
|
|
|
|
|
I want to multiplication like orderqty*rate=amount in c# datagrid windows appliction without using any button control when the cursor goes to the fild of amount inthe datagrid it should multiply the values given in the field of orderqty,rate if you need more description me ask me through email cutegirl_doctor@yahoo.co.in
I am a software developer in
c# dotnet located in bangalore india
|
|
|
|
|
Keep this in the thread you already created. Don't post the question in other threads too.
---
b { font-weight: normal; }
|
|
|
|
|
I'm not sure how the StreamReader uses it's buffer, but if it has one I hardly think that it's not using it.
Anyway, the file system also buffers file reads. A file is read in blocks of at least one cluster at a time, and a cluster is normally something like 4 kiB or 8 kiB.
Furthermore the disk may also use read-ahead, which means that when you read a sector, a certain number of sectors following it will also be read and stored in the drive cache. That means that when the file system requests the next sector, it will already be in the cache, and no physical read is needed.
So unless you have extremely long lines in your file, the disk will not be accessed for every call to ReadLine. There are several layers of buffering and caching that are quite efficient, so unless you run into performance problems, you hardly need to worry about it.
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
