Brijwasi SIngh's Q&A profile

• SQL Server MySQL function equivalent

  Hi, In MySQL, from_unixtime(lonvalue) returns the date format in 'YYYY-MM-DD HH:MM:SS'. Is there any equivalent available in SQL Server, to view the date in man readable format, when the input is an long value in milliseconds. Eg : SELECT FROM_UNIXTIME(875996580); Thanks, Smitha Take a look at the CONVERT function in Books Online. It has different styles that you can use. Optionally you can format the string using various datepart calls. select CONVERT(varchar, CURRENT_TIMESTAMP, 121) -- odbc canonical format ...Show All

• Windows Forms Custom formatter

  I have to do databinding to a custom object. This custom object has an int property which must be databinded to a textbox with a special format (it's for chess squares, so 0 means "a1", 1 means "a2" , ... ,  63 means "h8"). And the databinding must be two-way (editing the textbox  will update the int property). I'm not sure how to do this: I have to implement my own IFormatProvider Are there any other ways Thanks, Valentin iliescu Where can I find some doc about MaskDescriptor. I looked at the IPv5 sample and I don't really see how it works. Thanks in advance, Philippe ...Show All

• Windows Forms Custom DataGridViewCell - odd problems

  Hi, I'm trying to build a CustomDataGridViewCell that should set ForeColor according to the values in the cell. However, it should support different coloring methods, e.g. color red if value < 0 or color red if last value > this.value. To achieve this I though I could create a custom cell with an enum in the constructor like this:     public class CustomCell : DataGridViewTextBoxCell     {         private double _dlast;         private ColorType _type;         public CustomCell(ColorType type) ...Show All

• SQL Server URGENT Merge Replication: missing rows at Publisher and Subscriber: no conflicts

  We have SQL Server 2000 with merge replication at a Publisher and subscriber. We have some records getting deleted at Publisher and Subscriber and no conflicts are logged. We have tried the compensate_for_errors setting and this has had no effect. This is causing serious data corruption and has now become an URGENT issue. Out tech team are almost out of ideas. Has anyone experienced this or have any ideas as to what to check next What do you mean records getting deleted Do you make inserts at the subscriber and after merging, you find those rows deleted If so it could be happening because those rows are violating some ...Show All

• SQL Server SQL 2005 woes

  I installed VS 2005 & SQL Server 2005. When I use SQL Server Management Sudio,  I can create a new database in SQL Server 2005, but when I try to create a new table in that database, I get the following error: "Class does not support aggregation. Microsoft.Sqlserver.Sqltools.VsIntegration" any help would be appreciated. Thanks Does this happen when you create the most basis table   If not, what is the composition of this new table Peter ...Show All

• Visual C# Propagating events up an object chain

  Hi All, I’m looking for advice on how to handle events in the following scenario: I have a TcpConnection object which I’ve written to handle creating client/server connections and managing them. It has some events: Connecting Connected ConnectionFailed Disconnecting Disconnected Now for an example project, a telnet program. I have a class called TelnetProtocol which uses my TcpConnection object to handle its connection. Ok great, so I subscribe to my TcpConnection events in my telnet protocol and do what I need to. Now I also have TelnetTerminal control for a form that uses a TelnetProtocol object to handles its co ...Show All

• Visual Basic A program that converts VB6 code to the 2005 Express Edition?

  Is there one out there I'm in desperate need of it! babbel fishken http://web.telia.com/~u31115556/desc/programs.htm#BabbelFisken ...Show All

• Windows Forms Get Server time in VB6

  Hi, Did anyone know how to get the server time in the network using VB6. Well in a windows 2000 server solution with windows 2000 pro clients you automaticly get the date/time from the server thanks to the time service. Also this is a winforms .net site. I would advise going to the public forums on the msdn site for more info or  ...Show All

• Windows Forms MDI child window cannot have main menu

  Does it seem odd to anybody that a Form window having an MdiParent will actually have its main menu generated on the MdiParent's menu bar rather than itself  Is there a way to have it render on the child window itself Likely one could forget the window to stick within the parent window. But I do think this window system will&nbs ...Show All

• Visual Studio Team System Build always checks out most of 'Bin' directory? (VS2005 Team Suite RC1)

  I searched a bit for this, but VS2005 Team Suite has been checking out most of my 'Bin' directory each time I open OR build my solution. Has anyone seen this before Is this simply an option that I have forgotten to turn off or is this a bug fixed in RTM Its a very annoying behavior, because often I just want to build the solution and don't have any pending changes, but because its checking out everything all the time it picks up all the Bin and Solution (.sln & .vssscc) files as Pending Checkins.. My team is using VS2005 Team Suite RC1 running on Virtual PC 2004 SP1 and connecting to Team Foundation Server Beta 3. Thanks, Graham ...Show All

• SQL Server The Trash Destination Adapter - Really needed?

  Quick question... I have a conditional split transform in a dataflow... One of the outputs of the conditional split will take records that are just not needed... Do I have to send that output into the Trash Destination adapter Or can I just let those records hang Will there be a memory leak if I don't use a trash adapter I'm just thinking about if I move the package I'd have to go reinstalling the trash adapter every time... Thanks Let them hang. The Trash Destination is really only for development pruposes, the primary use being to provide a destination thus giving a path that ca ...Show All

• Visual C++ Buttons

  I know that this is probably one of the most simple and easy things to do, but I don't know how to do it,so can someone please help me with Click events so that when I click a button it goes from "form1" to "form2." Because I'm new at programming in C++. this->button1->Click += gcnew System::EventHandler(this, &Form1::button1_Click);   System::Void button1_Click(System::Object^  sender, System::EventArgs^  e)   { Form2 form; form.ShowDialog(this);   }   ...Show All

• Visual Studio Tools for Office Word Document

  I am creating a word document from the code, what i do is creating a table in the document which contains two columns , the first column contains the title and the second contains description. The first column is shaded tabParent.Rows.Add() ParentRow = ParentRow + 1 tabChild = tabParent.Cell(ParentRow,1).Range.Tables.Add(tabParent.Cell(ParentRow, 1).Range, 1, 2) tabChild.Rows.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle tabChild.Cell(1, 1).Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorGray10 tabChild.Cell(1, 1).Width = 105 tabChild.Cell(1, 2).Width = 413 tabChild.Cell(1, 1).Range.Text = "COMMENTS" objDo ...Show All

• Visual Studio Team System TFSService Permissions

  What are the required permissions on the local machine when using a domain acct I have no problems installing the server when using a local machine acct named TFSService, but when I switch to a domain acct with a different name I get an Error 28925 about a third of the way through installation. Brent In Addition the only way to get this to work is to currently place the domain acct into the local admins group. ...Show All

• SQL Server How to import Pervasive Database into SQL Server 2005

  Hi I have tried to import Pervasive Database to SQL Server 2005. I am not getting any option in Data Source for Pervasive So I tried following I have Provided the following Connection String to SQL server Import and Export Wizard (in .net framework data provider for ODBC) Connectio String: Dsn=DEMODATA;Driver={Pervasive ODBC Engine Interface} DSN: DEMODATA Driver:Pervasive ODBC Engine Interface but i m getting error that "Can not get supported data types from th database connection." Can you please look in to it and tell me possible ways by which I can import pervasive Database into SQL server 2005. a ...Show All