|
Here am trying to delete the row in the dataset for Delete button click on each row and finally, when I click SAVE button, the entire dataset will be pushed into the db.
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataSet dsGr = (DataSet)Cache["MyGrid"];
int RowID = (int)GridView1.DataKeys[e.RowIndex].Value;
dsGr.Tables[0].Rows[RowID].Delete();
Cache["MyGrid"] = dsGr;
GridView1.DataSource = dsGr;
GridView1.DataBind();
}
The DataKeyNames property for gridview is set to "id".
When I delete the first row on the grid, the RowID=1 and hence the first row on the dataset gets deleted but actually the first row (0th row) should be deleted. Can you please suggest if am going wrong on identifying the RowID?
int RowID = (int)GridView1.DataKeys[e.RowIndex].Value;
Just guide me how to find the correct RowID
Thanks.
|
|
|
|
|
Should be:
int RowID = e.RowIndex;
This gets the correct Index for the row that fired the event.
|
|
|
|
|
 Thanks. I was finding the value.
|
|
|
|
|
HI,
i like to know if there is a special control that can do this :
imagne a table :
----Att1----Att2----
row1____----____----
row2____----____----
____ - the row/Att cross junction
i like to know if there is a possibilty to put there ( ____ )
a Combo box or any kind of a control or even number of controls
please HELP!!!!
if u can help me, i can talk over the messnger : kobiamor@gmail.com
THNKS
kobkob
|
|
|
|
|
I think I safely speak for everyone when I say "Uhhh... WHAT?"
|
|
|
|
|
HI
can i send u an email with a drawing that will explaine more???
kobkob
|
|
|
|
|
No. My mail filters will just delete it. I don't accept "direct email responses" from CodeProject, unless you're in an exception list. And you're not in the exception list.
Post your image on Flickr or any other free photo hosting site and post the link to it here.
|
|
|
|
|
Putting combo boxes, etc, inside data grids is the subject of countless articles here, and elsewhere.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Okay I can't get my update to work. here is my code:
namespace DBWinVoice
{
public partial class Company : Form
{
WinVoiceDataSet companyDS = new WinVoiceDataSet();
public Company()
{
InitializeComponent();
}
private void Company_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'winVoiceDataSet.Company' table. You can move, or remove it, as needed.
this.companyTableAdapter.Fill(this.winVoiceDataSet.Company);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
this.companyBindingSource.EndEdit();
this.companyTableAdapter.Update(this.companyDS);
MessageBox.Show("Update Successful");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
I know I am doing something dumb...can anyone help me?
Thanks
Christopher J. Thornburg
Senior Systems Analyst
Ideal Card
|
|
|
|
|
What are the error messages, if any?? Define how it's "not working".
Does this table have a primary key that is returned by the SELECT statement?? The adapters won't work without it. The Adapters write the changes back to the database by executing the INSERT, DELETE, and UPDATE command for each line in the table that needs updating. Without a primary key in your table, AND without that key being part of the resulting recordset, there is no way for the TableAdapter to tell the SQL database which record to update and how to do it.
|
|
|
|
|
Yes I have a primary key. I am not getting any error messages it just will not work. I have just added tables to my dataset so I need to change my code a bit.
Would this work better if I used a datatable variable assigned my company table and then passed the datatable to the update or should I use datarows?????
I just want you to know I have no idea what I am doing....
I am a little confused about the whole thing.
Christopher J. Thornburg
|
|
|
|
|
You're passing an empty DataSet to the update method.
You intialize companyDS as new and then never assign any data to it.
That's why there is no error. It is successfully updating with an empty DataSet into a database (that presumably) allows NULL values or empty strings.
|
|
|
|
|
Okay cool...will you show me how to do it????
I think I would need a dataset.table variable and then assign it the data of the current row, and then pass that to the tableadapter.update() is this right?
can you show me how you would do it in some code. I have 4 tables in my dataset.
Dataset = WinVoiceDataSet
Table = Company
Christopher J. Thornburg
|
|
|
|
|
Hi ,
How in C# .NET find the position of specifig image (saved for example in Bitmap) on the screen ?
Life would be much easier if we just could look at the source code
|
|
|
|
|
If you already know the exact bitmap you want to find, you can do a screen capture, then look for an exact pixel match from there. I don't recall how to do the screen capture, but I know there's support for it. You would use code like that in my image processing articles to turn the two bitmaps into byte arrays and go looking for the scanline that represents the top of the bitmap.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
I suspect you can copy it from Screens.PrimaryScreen ( or whatever it's called ).
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
In a very short amount of time I need to cause severe fragmentation on a volume on my system. I have found a bug in my program that is directly related to a volume being defragged. I would like a tool that will allow me to control the fragmentation of a volume then turn around and run the defragger.
Is there anyone who can help me with this? I need to cause fragmentation on any given volume on most OS’s from XP through Longhorn.
Thank you,
Matt Rowe
|
|
|
|
|
I doubt anyone has ever written a tool to make your volume fragmented.
There's API support to DEFRAG a volume, but not fragment it.
There are two approaches to this. Make a sector-by-sector image of a disk that is already fragmented and reload your stuff on it to test. When your test is complete you can restore the image and put everything back where it was.
Randomly create and delete thousands of files of various sizes on the volume to fragment the writing of those files. Leave some in place and delete others.
You cannot "cause fragmentation" of existing files on the volume without rewriting those files and moving individual blocks of data in those files to other locations on the disk. This would require "blackbelt" level knowledge of the NTFS file system and it's API's to accomplish.
|
|
|
|
|
Thank you for your feed back. I will give it a try.
|
|
|
|
|
Hi,
this is what I would suggest, it is not very hard to do:
1.
create a disk partition (with Partition Magic or something similar) of twice the minimal size
that will fit your needs (this speeds up what follows). Make sure it is empty to start with.
2.
create a lot of files of equal small size until your partition is full; give them sequential
filenames (such as A00000000.dat and counting up). small would be say 8KB (I would suggest
you take partition size divided by 64K and rounded up to the next power of 2
multiple of 512B, to try and get the cluster size).
3.
now delete half of those files (the ones with an even filename);
that should result in the most fragmented partition possible: half of the partition is
empty, but a file of that size would have all its clusters non-adjacent.
4.
now run your real app and see what happens...
BTW: I would do steps 2,3,4 separately so you can inspect the situation to make sure
the situation is as expected.
Hope this helps.
-- modified at 22:49 Tuesday 25th September, 2007
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Thank you for you suggestion. I a similar approach, but on vista I ended up with only 2% fragmentation.
|
|
|
|
|
how can i subtract and multiply cells in datagridview in vs 2005 or even in the database...i want for example to add all the cells together and get the result...in short how to make math operations in ado.net applications using DatagridView or something...i hope my question is clear !!!
|
|
|
|
|
Just use the sum aggregate in an SQL query to sum all records. Example:
select sum(price) as total from articles
---
single minded; short sighted; long gone;
|
|
|
|
|
When I did that I did something like total += the cell value. I did that from RowAdded or RowDataBound. I can't remember the exact name, but every time a row is added the total would be increased by that cell's amount. Then I output that final value in the datagrid footer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
