Hi, When you add relation between tables (foreign key) only a small amount of data is added to system tables. The foreign key is enforced without any additional space requirements on your tables (however the system tables where the foreign key is defined are stored in the same database so they use a small amount of space, as data always does). When defining primary key, the information is also added to system tables, but in this case an index is typically also built to quarantee performance of the primary key. The size of the index can vary a lot so there's no way of saying how much space it will consume without the knowledge of the primary key definition along with table definition. Hope this helps, Mika

Try this article Smile: A curve that can set a lot of things straight! (\ /) (O.o) (><)

I've not used that before, can you define the column formats like you do in ASP.NET ? Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "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 .net 2005 This is a windows application I have adapted the following code in order to populate the datagridview from xml file DataSet ds = new DataSet(); ds.ReadXml(@"D:\myappl\Student.xml", XmlReadMode.Auto); dataGridView1.DataSource = ds.Tables[0]; While the datagrid is clicked then it mead=ns the user is tring to edit the record so that i can get the selected row and the selected rows first cell contains the primary key so i am passing that to the form 2 (edit form) as follows in that the constructor of the form 2 takes one string argument which is the primary key of the selected field passed from the form1 as follwos In form 1 private void dataGridView1_DoubleClick(object sender, EventArgs e) { MessageBox.Show("" + dataGridView1.CurrentCellAddress.Y); MessageBox.Show(dataGridView1.Rows[dataGridView1.CurrentCellAddress.Y].Cells[0].Value.ToString()); Form2 f = new Form2(dataGridView1.Rows[dataGridView1.CurrentCellAddress.Y].Cells[0].Value.ToString()); f.val = dataGridView1.Rows[dataGridView1.CurrentCellAddress.Y].Cells[0].Value.ToString(); f.Show(); } In form 2 public Form2(string value1) { InitializeComponent(); //getst he value and the value is stored in the txt box textBox1.Text = value1; DataSet ds = new DataSet(); //populates the dataset ds.ReadXml(@"D:\myappl\Student.xml", XmlReadMode.Auto); //assigns the primary key field ds.Tables[0].PrimaryKey = new DataColumn[] { ds.Tables[0].Columns[0] }; //finds and retrieves the row for the key DataRow dr = ds.Tables[0].Rows.Find(textBox1.Text); //populates the value you can extends also textBox2.Text =Convert.ToString( dr[1]); } if the Datarow and DataSet object is global and if you give the following code it will be deleted. dr.delete(); ds.WriteXML(...) Please tell me whether this is working or not but keeping a linklabel inside a datagrid is not possible if it is a web application then you can do that by keeing the hyper link field in the gridview control and it is possible to hide the primary key also -- modified at 5:43 Monday 11th June, 2007 Best Regards, M. J. Jaya Chitra

hi, thanks a lot for urhelp but mayu give me a code sample cause i didnt understand how 2 do it. Thanks alot Hamody

You can use the Request object to get a decent amount of information from each user. e.g. C# bool hasCookies = Page.Request.Browser.Cookies; VB Dim hasCookies as Boolean = Page.Request.Browser.Cookies Hope this helps!

This is all in the control properties, also you may click on the smart tag and click edit template. About : Islam About : Me

I think this will work if the number u require is always 1 less than the max number. Here is the command for the column which have random values. select max(colName) From tblName where colName not in( select Max(colName)From tblName) Regards, Arun Kumar.A

thanks a lot for ur idea but have u an idea on working with hhtpresponse and httprequest, have u an example on this Thanks alot Hamody

Next time, ask in the Visual Basic Forum. Yes and no. It depends on the type of the variable and it's context. No, there is no way to release it. You don't have to worry about it. Just let the runtime take care of it. Dave Kreskowiak Microsoft MVP - Visual Basic

try setting ImeMode property of the TextBox life is study!!!

Hey guys, i got the solutution which is: private string HexAsciiConvert(string hex) { StringBuilder sb = new StringBuilder(); for (int i = 0; i <= hex.Length - 4; i += 4) { sb.Append(Convert.ToString(Convert.ToChar(Int32.Parse(hex.Substring(i, 4), System.Globalization.NumberStyles.HexNumber)))); } return sb.ToString(); } Thanks alot Hamody

Hey guys, i got the solution which is: private string HexAsciiConvert(string hex) { StringBuilder sb = new StringBuilder(); for (int i = 0; i <= hex.Length - 4; i += 4) { sb.Append(Convert.ToString(Convert.ToChar(Int32.Parse(hex.Substring(i, 4), System.Globalization.NumberStyles.HexNumber)))); } return sb.ToString(); } enjoy and thanks to all of u :rose: Thanks alot Hamody

DataGridViewTextBoxColumn MyColumn = new DataGridViewTextBoxColumn(); myDataGridView.Columns.Add(MyColumn); Try that. Syntax is off the top of my head, so you may have to modify things slightly, but at runtime, that's the way to do it. In the designer, right click the DGV and select "add column"

Check this link: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1161100&SiteID=1 Gautham

I typed in 'vb script open web page' Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

No, but with the designer in VS2005, it's kind of trivial to whip up sample UI. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog

Don't post the same thing in multiple forums. Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert