Ntc's Q&A profile

• Windows Forms bind 2 string arrays, first as .displaymember 2nd as .valuemember

  Hi, I have two two arrays, one of string type and second of System.Guid type. How can I bind array of strngs as display member of a listbox and array of System.Guid as Value member of a listbox  Thanks, I have another field in the dataset that is of bool datatype. Can I bind that with the list as well, that would make the  ...Show All

• SQL Server sproc call udf to generate alternating background color tags

  I am using a sproc to select rows from a table and it calls a udf() to get alternating background colors as a "<tr>" string. I use the surrogate key and extract the last byte and based upon even/odd of the last digit return (from the udf) a <tr> tag with different background colors. This works just fine UNTIL my sproc does a selective pull and the rows from the audit table are not sequential - that is I get instead of even/odd/even/odd I might get odd/odd/even/odd/even/even/even.  This of course results in several table rows being the same background color.  I do NOT want to do this in the host language as I am fetching ...Show All

• .NET Development The conversion of a char data type to a datetime data type resulted in an out-of-range datetime

  I am putting the current datetime in a microsoft sql server database in the following manner: System.Data.SqlTypes.SqlDateTime time = new        System.Data.SqlTypes.SqlDateTime(DateTime.Now); sql = "insert myTable (datetime) values ('" + (string) time.ToSqlString() + "')"; SqlCommand cmd = new SqlCommand (sql, conn); int result =  cmd.ExecuteNonQuery(); the column of my table has datatype DATETIME I tried it 7 times yesterday and today without problem. Now (at 00:45 hours) I get an exception: the exceptionmessage: System.Data.SqlClient.SqlException: The conversion of a char data type to a datetime d ...Show All

• Visual Studio Team System Can't add project Web Parts to home page

  I'm trying to add web parts from the project gallery, just the ones installed by default, but they give this error every time: An unexpected error has occurred. Only the project gallery web parts give this error. If I add one from the "Online Gallery", those work just fine. But the ones associated with the project fail. I have three TFS projects and I get the same error on all three. I also have two other non-TFS SharePoint sites on the same error, but those do not generate an error. Jay McCleery posted the answer below. It worked for me. Jay McCleery wrote: Unfortunately, thi ...Show All

• Visual C# PC to PC Call using RTC Client

  Hi, I am trying to setup PC to PC call, but my session state is never connected. As soon as I try to establish PC to PC call, the Session state event is Inprogress and then it goes to Disconnected. I am not sure why its not able to establish the connection. Also is it neccessary to register SIP server and the profiles of the user on SIP Pls help me. Thanks, Ekta ...Show All

• Visual Basic Just wondering is it possible to change the default title of MsgBox?

  Is there a way to change the default *ugly* title of MsgBox Please don't take it wrong. I know that I can provide the 3rd parameter - but I have to do it on every call. Any ideas Hi, Defaultly the Application name is displayed in the title bar of a MessageBox if you don't specify a title. So if you want to change the default title, then change your application name. cheers, Paul June A. Domag ...Show All

• Visual FoxPro upgrading old foxpro apps

  we currently have foxpro version 5, and a handfull of apps which were developed on it.  the person who developed them has since left us and it has become my job to find a way to upgrade these apps.  the problem is that i don't know the first thing about foxpro - i am a coldfusion guy.  so the biggest thing we want to do is to get the data from the foxpro databases into a sql server database.  if we do this can we still run the existing foxpro frontend   or do we need to upgrade to a new version of foxpro and can we use the existing frontend or would we need to modify the foxpro code basically we are just trying to ...Show All

• Visual Basic Buying Visual Basic 2005

  Am I able to buy just VB 2005 or do I have to buy the Visual Studio suite Thanks in advance! I just looked, again. I didn't see anything in the way of a Standard edition. There hasn't been a pro edition since VB6 (So I'm told) So basically the answer is no. But you can still get just VB by way of an express version. http://msdn.microsoft.com/vstudio/express/vb/ And it's free and downloadable. Randy Dear Santa,    Please make a VB Pro version with ASP.Net, webtools & mobile development for X-mas. Thanks. I been good!   ...Show All

• Visual Studio Tools for Office Excel 2007 Beta Charting Problem/Question

  Sorry for posting this in the wrong area if so. I was trying to get an answer out of the Excel tech yesterday but she could not help and suggested that I post here. In prior versions of Excel you have the ability to drag datapoints on a line chart around. It would either just make a change to that cell ref or if it was a cell that was dependant it would start the goal seek utility and ask for the cell that needed changed to make the change to the cell that your changing. I have the Beta version now and this seems to be either turned off or does not exist any longer. So are there settings that I'm missing or has this been taken out of the new ...Show All

• SQL Server Unable to use MS SQL 2000 SA Password

  Dear All! I have installed my sa password "sa" during my MSDE (desktop engine of sql) installation. currently i am loging into query analyzer using windows authentication. But i cant access the database through my code, coz i dont have sa access. Please kindly Help me finding my current sa password. Thank You! Did you get an answer I am having the same problem. Thanks. Oguchi ...Show All

• .NET Development Accessing deleted row information

  I have a strongly typed dataset 'A' with a Customer datatable and data. I create a new instance of the same dataset ('B') with same table structure and import selected rows into the 'B' Customer datatable from dataset 'A' Customer datatable. I pass dataset B to a method that deletes a row in dataset 'B' Customer datatable and now want to mark the row as deleted in dataset 'A' customer datatable. What is the best way to do that I thought I could loop through the Customer B rows, find rows with row state = deleted, find them in Customer A and delete them. However, this process throws an exception that the deleted row is inaccessibl ...Show All

• Visual Basic Database/Project Problems

  Hey, for my project i have to create a program for a travel agency. i've got most of the program working but im having big problems writing to my database. What i don't understand is that i can read from it with out any problems but when i try to write to it i keep getting errors. The debugging error keeps coming up when i execute this line "objDetails.Update(objDataSet, "Customers")". the debuggin error i get is " An unhandled exception of type 'System.Data.OleDb.OleDbExecption' occurred in system.data.dll "   im using Access 2003 for my database. heres the code for my form   {have to take the code away its too long an ...Show All

• Visual C++ How can I handle this error

  Dear all ,    I couldn't handle this error like the code below.    I know "strncpy" shouldn't pass the value -1 , but    how could I debug this kind of error         try    {        char test[20];         strncpy(test,"123",-1); //problem here -1    }    catch(...)    {    }    It also couldn't be handled this after using "SetUnhandledExceptionFilter" api .    Could you help me thanks ..    ...Show All

• Visual Studio Express Editions RS232 (Comm Port) Cant read the line HELP

  Hi, I was trying to read the text from comm poert w/ new SerialPOrt object but for some reson it dosnt work. But I can write everything though. I'm using all defult seetings for the port object. And here is the code that I have. Also when I chnded read timeout, I got an error in time out. Public Class PORTs Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click sp.Open() End Sub Private Sub Button2_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click sp.Close() End Sub Private Sub sp_DataR ...Show All

• Visual Basic Textbox Reading

  Hi All, i have a problem with a certain little textbox which i cant seem to get working again , i wish to read everything in a textbox before a certain character , in this case a space how would i get this done where a button is pressed and it will display only the characters before the space into another texbox eg text1 = "John Smith" where as i would like text2 = "John" since the next character was a space .. many thanks this is in VB6 (just in case) Rob I'm not sure about VB6 details, but here is something that must be close to it: dim s as string dim spacePos a ...Show All