Thank you :)

thank you very much :).i'll try

thanks yu-jian :)

Yes, how else would they get there? this.Controls.Add ( whatever ) ;

Hi, use odbc; c# Provide Ado.net , 'oledbconnection' ... // for example to connect access OleDbConnection conObj; conObj = new OleDbConnection(); conObj.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data source = " + Application.StartupPath + @"\用户.mdb"; conObj.Open(); you can get help from google

Check this site. Probably it may help you. Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Hi.. now i can fix this problem. in required field validator, enabledclientscript to false. thanks.

thanks .. the data is come from user input. now i can fix this problem. i solved like the following. 1. insert zero in front of numbers. 2. sort by using dataview and put into datatable 3. remove zero and bind with gridview. really thanks. :)

Rollback!

Have you tried looking up the MySQL documentation? "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Quit cross posting. kyi kyi wrote: I need it urgently. Oh well, that's your problem. Not mine or anyone else's. "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Your While statement should use a "Do" instead of "Begin" and an "End While" instead of "end" You might take a look at a few samples on the net to get examples of SQL code. One that I have found useful is http://www.artfulsoftware.com/infotree/queries.php?&bw=1260[^] I am not sure exactly what you are doing, with your extract, but you might consider chopping the string into substrings and sorting the substrings. That way your numeric substring(s) should be at the top, (assuming your original string does not contain any special char's). Good Luck

It's working in SQL Server dude. Since you are trying to execute it on MySql, you probably have to find which line should be replaced with the proper corresponding sql syntax in MySql. _

hi, 1.first replace ? with @ symbol for all the variables declared with? 2.give ur query like this select ExtractDigit ('') stringname--> your string name T.Balaji

thanks.

Here's another way of doing it: Private Sub DG_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles DG.PreRender Dim DG As DataGrid = CType(sender, DataGrid) Dim Tbl As Table = CType(DG.Controls(0), Table) For i = 0 To _NumberOfRowsToAdd - 1 Tbl.Controls.Add(AddEmptyRow) Next i End Sub Function AddEmptyRow() As DataGridItem Dim DGI As DataGridItem = New DataGridItem(0, 0, ListItemType.Item) Dim cell As New TableCell cell.ColumnSpan = _NumberOfColumns cell.Text = " " DGI.Cells.Add(cell) Return DGI End Function When you create your Datatable you will need to populate two fields with the number of columns and rows to add to the datagrid.

Haven't used MySql really so just guessing here. In the second statement, you have a potentially reserved word comment and also remark. Try removing them from the statement: INSERT INTO commentdetail (commentDetailID, commentID, commentType, locator1, locator2) VALUES (?commentDetailID, ?commentID, ?commentType, ?locator1, ?locator2) The need to optimize rises from a bad design. My articles[^]