Hi, the gridview has an OnRowDataBound event. In that event you can do your thing like: Int32 Total = 0; Int32 ValueCol1 = 0; Int32 ValueCol2 = 0; Int32 Together = 0; if (e.Row.RowType.Equals(DataControlRowType.DataRow)) { try { DataTable tabel = (DataTable)myGridView.DataSource; ValueCol1 = Convert.ToInt32(tabel.Rows[e.Row.RowIndex].ItemArray[0]); ValueCol2 = Convert.ToInt32(tabel.Rows[e.Row.RowIndex].ItemArray[1]); Together = ValueCol1 * ValueCol2; Total += Together; } catch (Exception err) { lblError.Text = err.Message; } } if (e.Row.RowType.Equals(DataControlRowType.Footer)) { e.Row.Cells[2].Text = Total.ToString(); } for: ValueCol1 = Convert.ToInt32(tabel.Rows[e.Row.RowIndex].ItemArray[0]); find the appropriate field in the ItemArray. Field[0] is the first displayed field

hi you can use the query strings like trainname.aspx?mumbaiexpress and take the value of query string on pop up form and show the respective value

It's always a good practice to keep the string values which is common to the application in a assembly resource file. In Framework 2.0, accessing the named strings from assembly resource file has been made very simpler. You have to add the resource file to the App_GlobalResources folder and add the named strings to the resource file. Say for an example, you have added a resource file with the name GlobalData.resx and a string ApplicationName with the value "Sample Application". The named strings you add to a global resource file are accessible through a namespace named Resources. It takes a single line of code... lblAppName.Text = Resources.GlobalData.ApplicationName - Regards -    J O N A good thing is a bad thing if it keeps you from the best thing. - Dr. Adrian Rogers

Sasmi wrote: i want to provide download functionality in my website What is big there in implementing download functionality ? Provide a link to the file, and download will be managed by browser. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

try this, declare @n int SET @n=5 SELECT DISTINCT (a.salary) FROM Table1 a WHERE @n=(SELECT COUNT(DISTINCT(b.salary)) FROM Table1 b WHERE a.salary<=b.slaray) They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!! CrazySanker

This[^] can help, if you are using SQL Server 2005. And next time please give your message a more descriptive subject.

:rose:Thanks for the info. I will get understand the namespace for any other help i will disturbe you. Sasmi

You have to create a Bitmap with form's size. Then, create a new Graphics from the Bitmap, and then call the "CopyFromScreen" method of the Graphics object. Here you have c# sample code... You only have to translate to vs basic. Bitmap oCaptura = new Bitmap(this.Width, this.Height); Graphics oGfx = Graphics.FromImage((Image)oCaptura); oGfx.CopyFromScreen(...)

In SQL Server, you can use the Query Profiler. Also, you will want to look at the execution plan for your query. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before.

Try this: CREATE TRIGGER [InsertIntoTable2] ON [Table1] FOR INSERT AS INSERT INTO Table2 SELECT (Field1, Field2, (and so on)) FROM INSERTED the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before.

Thanks for giving direction. Sasmi

I assume this is a COM dll, otherwise you could just put the dlls in the directories with the apps and it would be fine. You've done the wrong thing, and there's no easy way around it. If you're going to change a COM dll, you need to generate a new GUID so you have a new version. Either way, you should never break existing functionality, only add new functionality. In .NET, dlls are not registered, and are just loaded from the local directory. This change was made because the recommended way to use COM would work fine, but too many people just didn't bother to do it properly/thoughtfully. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog

Hi You can set the "Path" property of the filelist box. Hope this helps! Kanniah

The SELECT statement won't work, if I uderstand what your trying to do. There's isn't enough detail in your question to determine this! If you're looking to return a record or filtered set of records, it might look something like this SELECT PN, VA FROM Table1 WHERE PN=@PN AND VA=@VA If you're looking to return all the data in those two columns in Table1, then no parameters are necessary: SELECT PN, VA FROM Table1 Dave Kreskowiak Microsoft MVP - Visual Basic