Dmitry Arefyev's Q&A profile

• SQL Server SQL2005 Express CSV import

  Hello, I hope I am posting this question in the right forum. I have been working on some ASP applications and using them to connect to a MySQL database. I would like to move all of the data from MySQL over to SQL2005 Express. The problem is that the express version doesn't offer an import/export tool for CSV files. I am able to export my table data from MySQL to a CSV file, how can I import this data into my SQL2005 Ex database Thanks. Jim Miller hi, you can perhaps have a look at linked server scenario, as described in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=553682&SiteID=1 regards ...Show All

• SQL Server String Formating

  Hai .net team I am returning the value Eg. 1000.00 in my select query but i need to format that vlaue like 10,00.00 by putting comma in to that value how to achive using sql server 2000 thanks sujithf I am also agree with u r commencts,but the thing is i am using RDL(business Intelegent report project using .Net )  report in my project so,my project manager wants me to do everything in SQL server side and there is only few  facility to do client side using rdl report. Thanks everybody for your valuable comments sujithf   ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Play Background Music Problem?

  Hi All, I want to play bg music with my game. How to set loop play with the music audio = new Audio("sound file"); audio.Play(); Best Regards, Hi ProfEclipse, I try check the sound state. But the sound evey time is playing state. public void audioCheckState() { if (audio.Stopped) Console.WriteLine("isStopped"); if (audio.Playing) Console.WriteLine("isPlaying"); if (audio.Paused) Console.WriteLine("isPaused"); } ...Show All

• .NET Development FileIOPermission

  OK, ive got a bit of a strange error Ive managed to get the IT staff to install visual C# 2005 express on a college computer, and it works pretty much fine. BUT When using an openfiledialog, i get this exception thown When do you get this error When the dialog opens When you select a file XP considers anything not local to be untrusted. (ie, it much like running a file off the internet). You can set the permission for that particular EXE to be trusted, but I believe you'd lose that next time you recompile. One can also make the user area trusted, but that's a OS admin question (out of my area) ...Show All

• Visual Studio 2008 (Pre-release) Unable to start Expression Interactive Designer June CTP.

  I have strange problem with Interactive Designer June CTP. It crashes during start! Everytime. I have installed NET3 June CTP. Error message in "Error Reporting" and EventLog is quite non-informative:   EventType : clr20r3     P1 : exprid.exe     P2 : 0.1.2656.0     P3 : 449c4f68 P4 : microsoft.expression.designsurface     P5 : 0.1.2656.0     P6 : 449c4f52 P7 : c2d     P8 : cd     P9 : system.typeinitialization   My system: WindowsXP TabletPC Edition 2005, .NET Framework 2.0 installed, NET3 June CTP installed. Hardware: Toshiba Portege M200   ...Show All

• Windows Forms Custum Button applying 3DBorderStyle (help please)

  Here is my Code for what i have made so far...I want to keep what i have but Change the Gradiant to Up and Down,not from Side to Side.. And Apply a 3DBorderStyle to the Custom Control... public class XtrmeButton : System.Windows.Forms. Button { private Color m_Color1 = Color .White; private Color m_Color2 = Color .LightBlue; private Color m_Color3 = Color .Black; private int m_color1Transparent = 60; private Button button1; private int m_color2Transparent = 60; private int m_color3Transparent = 40; private Border3DSide m_Border = Border3DSide .All; public static void Main() { } public Border3DSide XtremeBorder { get { return m_Border; } ...Show All

• Visual Studio Error During Installation

  Hi, Whilst attempting to install V3 of the SDK, I get this error: --------------------------- Error --------------------------- Error 1402.Could not open key: HKEY_CLASSES_ROOT\.htm. Verify that you have sufficient access to that key, or contact your support personnel. --------------------------- OK --------------------------- I am running as admin and have verified that the administrator has access to that registry key. Also, I have run regmon to check any registry access failures - none are reported. Anyone know what else might be causing this Thanks, Kent Hi Kent, I haven't seen this error before. Can you manually add a new key under that HKCR\.htm key I'm not sure what the Visual ...Show All

• Visual Studio Express Editions Keydown Event with Enter has strange results

  I'm creating a calculator as my first application while learning C#. I've setup a KeyDown event in the form that checks to see if the Enter key has been pressed. It works perfectly for the most part, but if one of the buttons on the form is highlighted (due to being the last button clicked), pressing Enter gives strange results... certainly not what I asked it to do. My guess is that the Enter key has some default function when a button is highlighted in this manner, and this function has priority over what I've programmed it to do. I figure I could fix this in two ways (both of which I can't figure out how to do): 1. Somehow turn off this default functionality for the Enter key OR 2. Disable the button highlighting that act ...Show All

• Windows Forms something broke between 1.1 and 2.0 here

  I have an old control I wrote, that worked in 1.1 but doesnt anymore (actually it does, but marshals some interop stuff wrong). its the SysIpAddress wrapped into .net, and one of the events isnt comming out right. in my WndProc: protected override void WndProc(ref Message m) {     if(m.Msg == (WM_REFLECT + WM_NOTIFY)) {         NmIPAddress ipInfo = (NmIPAddress)Marshal.PtrToStructure(m.LParam, typeof(NmIPAddress));         if(ipInfo.Hdr.Code == -860) {              if(values[ipInfo.Field] != ipInfo.Value) {                 values[ipInfo.Field] = ipI ...Show All

• Visual Basic Manually populate a combobox

  All I want to do is manually populate a combobox with a displaymember and valuemember.  I would've hope something like this would of work; combobox.items.add(new listitem (dr("Name"), dr("ID"))) but there is not listitem in VB.Net.  So what would I use Thanks, Mike Hi, you can build your own classess and add them to the combobox. You have to override the ToString() Method with the value that shall be shown in the combobox. myClass myCreatedObejct = new myClass(); combobox.items.add(myCreatedObject);   Dim  myCreatedObejct  As new myClass (); combobox.items.add(myCreatedObject);   ...Show All

• Visual Studio Team System Start Date is read-only from MS Project

  I have applied the fix for the MS Project "comma problem" (KB 919232) to my system, and can now refresh a project file from TFS. The problem I am having now is that the tasks all have a start date that was created when they were imported into TFS, and if I try to change it in Project I get an error message stating that that field is read only and cannot be changed. Can anyone tell me how I can change this date My project was an on-going one and some of the tasks were in process well before they were imported into TFS. TIA Ron L Did you check if you have ReadOnly rule set for Start Date field in work item tracking You can import that type using witimport and make sure no readonly rule is specified for that field. ...Show All

• Visual Studio 2008 (Pre-release) Detecting ComboBox value changes

  How do I detect value changes in a XAML combobox I can't figure out which Event to watch. Thanks! That seems to be working for mouse changes. For keyboard I'm using PreviewLostKeyboardFocus. Is that the best method for this ...Show All

• Visual Basic Display sum of records

  Hello, I need to display on a form, on a textbox, the value of a sum of records that is on a Query on my database. I've the following code: con2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=""C:\Programacao\Visual Basic\Inapal\ReportIt\ReportIt.mdb"";" con2.Open() sSQL2 = "SELECT Qtd FROM [TotalScrapQuery] WHERE ((Data LIKE'" & DateReport.Text & "') AND (Turno LIKE'" & ShiftReport.Text & "'))" da2 = New OleDb.OleDbDataAdapter(sSQL2, con2) ds2.Clear() da2.Fill(ds2, "TotalScrapQuery" ) con2.Close() How can I make something like ScrapBox.text=Qtd Thanks, Joao Pinto ...Show All

• Visual Basic Print to network printer

  I am trying to print to a network printer. I get the error saying: "Settings to access printer 'xxx.xxx.xxx.xxx' are not valid." This is what I have so far. I get the error on printdoc.Print(). Thanks in advance. Private Function Print(ByVal FileName As String, ByVal IPAddress As String) As String Try printdoc = New PrintDocument pSettings = New Printing.PageSettings printdoc.PrinterSettings.PrinterName = IPAddress.Trim printdoc.DocumentName = FileName AddHandler printdoc.PrintPage, AddressOf Me.printdoc_PrintPage printdoc.Print() 'If printdoc.PrinterSettings.IsValid = True Then 'Try ' printdoc.Print() 'Catch ex As Exception ' Print = ex.Message 'End T ...Show All

• Visual Studio Express Editions Error While Coding!!

  I am following a book's direction to code, but when i entered this startment ' For intForLoopCtr = 1 To CInt (txtNoPics.Text) ' <<<<<<<< then it said 'intForLoopCtr" is not decared....... so anyone have any idea to make it decleared Always have Option Explicit On ! Oh, and BTW, as spotty says, I would very very strongly recommend that you have it on. I believe this is written on the Big Stick of Recommendatons. Another common coding technique is to use short variable names for loop variables: usually i, j and k are very common ones: whatever book you are reading I'd say get rid of it and find another one, if that/those line(s) of code came from the book. ...Show All