Hi John, Thanks for your prompt reply. As per your suggestion I executed bcp command in the command prompt. URL referred : http://www.databasejournal.com/features/mssql/article.php/3391761 First I used following command to export data from source table in SQL 2000 database table to a .bcp file [DatabaseName].dbo.[tablename] out c:\file1.bcp -n -S[servername] -U[username] -P[password] Next I used following command to import data to the target table on SQL 2005 database [DatabaseName].dbo.[tablename] out c:\file1.bcp -n -S[servername] -U[username] -P[password] But it looks to me as if I need to write as many statements to export/import data for as many tables. Anyway, thanks again for your valuable suggestions as it gave me right direction.:) Thanks & regards, Vaibhav

Hi all, Currently I am working on importing data from SQL 2000 database to SQL 2005 database. The original SQL 2000 database contains Japanese as well as English text. For importing data from SQL 2000 to SQL 2005 I have followed following steps. 1. I have created SQL script for generating table structure in SQL 2005. Which I executed and it created table structure in SQL 2005. 2. I have created SQL script for generating stored procedures in SQL 2005. This was also successful. 3. Same way, I have created user defined functions in SQL 2005. 4. But the problem comes while importing data to SQL 2005. For this I have done following things. - Exported the data from SQL 2000 database to an excel sheet.and - Import to SQL 2005 database which is causing problems. :( There is no problem with importing data which is in English to SQL 2005. But as we have to import Japanese text alongwith English, it is causing problems. * * * Error is * * * "The character-string data type of the Unicode form and the character-string data types of the form other than Unicode cannot be converted by the row "Description". So, I guess the problem is related to the importing of combination of UNICODE and Non-Unicode data to SQL 2005. So, please let me know if we can use some other alternatives for importing of Japanese text to SQL 2005. Any suggestion/solution from you on this issue is greatly appreciated. Thanks in advance. Thanks & regards, Vaibhav

Hello everyone !!! I want to migrate SQL Server 2000 database onto SQL Server 2005 database. The original SQL Server 2000 database tables contain some Japanese characters and I need to transfer them as well to SQL Server 2005 database. For this purpose I have done following things. 1. Exported all tables data to a excel sheet. (by choosing Microsoft Excel 97/2000) 2. But when I try to import this data to SQL server 2005 I am getting following error It verifies it. (error) Message Error 0xc02020f6: data flow task: The character-string data type of the Unicode form and the character-string data types of the form other than Unicode cannot be converted by the row "Description". (SQL Server import and export wizard) Error 0xc004706b: "Component" conversion of the data flow task ahead- tblCMSTypeMaster "(26)" failed in the verification, and the verification state "VS_ISBROKEN" was returned. (SQL Server import and export wizard) Error 0xc004700c: data flow task: It failed in the verification because of one or more components. (SQL Server import and export wizard) Error 0xc0024107: data flow task: The error occurred while verifying the task. (SQL Server import and export wizard) I guess this problem is related to importing of Japanese characters. I am stuck with this problem. Any solution/suggestion on this issue is greatly appreciated. Thanks in advance. Thanks & regards, Vaibhav

Hi Chetan, Looking at the error "Could not Access CDO.Message Object", I think there is a problem related to the permissions to relay through the IIS SMTP Service. To allow access, open up the IIS Admin MMC. Locate the SMTP Virtual Server, and right-click, then select Properties. On the Access tab, click the Relay button. In the Relay Restrictions dialog, grant your IP address (e.g 127.0.0.1) to the Computers listbox. Close down all dialogs, and restart the SMTP Service. I got the same problem some time back and used the above procedure. Hope it helps u.. For more details u can check this link http://www.systemwebmail.com/faq/4.2.3.aspx[^][^] Thanks for reading, Vaibhav :-D

Hi ptvce, I think the links below will be appropriate in ur case. http://www.programmersheaven.com/2/FAQ-CSHARP-Jagged-Array-Explained http://www.c-sharpcorner.com/Code/2002/July/WorkingWithArrays.asp[^ Thanks for reading, Vaibhav

Hi, I think u will have to check for ItemDataBound event of the datagrid for this purpose maybe check if u can get the current column width and then change it there only or adjust the text by inserting
into the string to be bound to that column... I haven't tried this yet...But just thought of sharing this idea... Thanks for reading.. Thanks & regards, Vaibhav

Thanks a lot.. I tried this one and it's really very good solution. Thanks a lot for the help. Thanks & regards, Vaibhav :)

ya..That's a useful advice... Thanks a lot..:-D

Hi, I think u must be returning a DataSet to bind it to the dropdown containing "ID" and "Name"...You can do following to display "ID/Name" to DropdownList where ID & Name are column names u return through ur query. if(ds!=null && ds.Tables.Count > 0) { if( ds.Tables[0].Rows.Count > 0) { ds.Tables[0].Columns.Add("strDisplay",typeof(System.String)); for(int i = 0 ; i < ds.Tables[0].Rows.Count;i++) { ds.Tables[0].Rows[i]["strDisplay"] = ds.Tables[0].Rows[i]["ID"] +"/" + ds.Tables[0].Rows[i]["Name"] ; } } } And to bind the dropdownlist DropdownList.DataTextField = "strDisplay"; DropdownList.DataValueField = "Value"; I think this should work fine... Thank u, Vaibhav

Hi, I think u can do it in Asp.NET and also in the SQL query. I just tried the same. Here it is... SELECT ct.intUSCityId, ct.strUSCityName,CAST(ct.intUSCityId AS VARCHAR(50)) + '/' + ct.strUSCityName AS Vaib ,ct.isDeleted FROM tbCity AS ct WHERE ct.intUSCountyId=10 To bind it to the dropdownlist DropdownList.DataTextField = "Vaib"; DropdownList.DataValueField = "intUSCityId"; The other one ofcourse by concatenating ID+ "/" + "Name" in Asp.NET It's working fairly well. So, I think u can use any of these methods Thanks for reading, Vaibhav :)

Hi, You can also have a look at the code below..Hope it's useful to u.. class ReadXml { //private const String filename = "c:\\ala.xml"; private const String filename ="data.xml"; static void Main(string[] args) { XmlTextReader txtreader = null; XmlValidatingReader reader = null; try { // Load the reader with the data file and ignore // all whitespace nodes. txtreader = new XmlTextReader(filename); txtreader.WhitespaceHandling = WhitespaceHandling.None; // Implement the validating reader over the text reader. reader = new XmlValidatingReader(txtreader); reader.ValidationType = ValidationType.None; // Parse the file and display each of the nodes. while (reader.Read()) { switch (reader.NodeType) { case XmlNodeType.Element: Console.Write("\t<{0}>\n", reader.Name); break; case XmlNodeType.Text: Console.Write("\t{0}\n",reader.Value); break; case XmlNodeType.CDATA: Console.Write("", reader.Value); break; case XmlNodeType.ProcessingInstruction: Console.Write("", reader.Name, reader.Value); break; case XmlNodeType.Comment: Console.Write("", reader.Value); break; case XmlNodeType.XmlDeclaration: Console.Write("\n"); break; case XmlNodeType.Document: break; case XmlNodeType.DocumentType: Console.Write("\n", reader.Name); break; } } } finally { if (reader!=null) reader.Close(); } Console.ReadLine(); } } Thank you, Vaibhav

Hi, Check this link http://www.dotnetbips.com/articles/displayarticle.aspx?id=172 I think this may be useful for u... Thank you, Vaibhav:-D

Hi, Use history.forward(1) in the script tag. I think this will solve ur problem. :) Thank u...

Hi, Check for the CommandName of the button inside ItemCommand like this... public void DataGrid1_ItemCommand(object sender, System.Web.UI.WebControls.DataGridCommandEventArgs e) { if(e.CommandName == "Insert") { do something... } } Thank u.. -- modified at 5:25 Friday 14th April, 2006

Hi, Add this code inside ur Page_Load DropDownList1.Attributes.Add("onchange","javascript:getValue();"); This is the javascript code. function getValue() { var textBox1 = document.getElementById("TextBox1"); textBox1.value = document.getElementById("DropDownList1").value; } I hope this solves ur problem... Thank u...

Is it possible to retrieve session state from SQLServer after I close the browser and then restart ? If yes then how ?:cool: