Manoj G's Q&A profile

• SQL Server Restricting password to contain atleast one letter and one number

  Hi, how should I apply restriction on the password field to have atleast one number and one letter The password field is 6 characters long. Thanks, You can modify the WHILE loop condition to ensure that you have at least 1 number and 1 letter. while (@i <= @passwordLength) and not (@password like '%[ABCDEFGhijklmnop]%' and @password like '%1234%') ...Show All

• Visual Studio Tools for Office ListObject binding Help

  hi i am facing a small problem in excel programming. I just read your doubt. From that it seems you may be able to clear my doubt. My problem is as follows: I have one listObject added to each sheet in a workbook during design time. Inside Workbooks sheet activate event I iterate through all worksheets using foreach loop as follows foreach(Excel.Worksheet ws in ThisWorkbook.Worksheets) { Excel.ListObject ls = ws.ListObjects[1]; } Now i need to bind this listobject to a dataset using SetDataBinding method inside the foreach loop. Is it possible Or is there any other way to find listobject added to each sheet (design time) and bind it to the dataset. Hope u will be able to help me Thanking ...Show All

• Smart Device Development Web service, xml, local storage

  hello, im very green to .net cf and some help are needed regarding the usage of xml as local storage. i've used web service to open a connection to database to get the data that i want and convert it into xml. below are the code <WebMethod()> _ Public Function getStud() As DataSet <-- does this means, im going to return a dataset to the calling application Dim conn As New SqlConnection("Data Source=localhost;Initial Catalog=Proj;Integrated Security=SSPI") conn.Open() Dim da As New SqlDataAdapter("GetStudent", conn) da.SelectCommand.CommandType = CommandType.StoredProcedure Dim ds As New DataSet da.Fill(ds, "Student") ds.WriteXml("C:\student.xml") <-- how d ...Show All

• SQL Server Preformance issue on Sql 2005 Analysis Services

  I have installed the Sql 2005 Ent. Edition (180 days Trial version) on my desktop Windows XP machine with P4 3.00GHz and 2.5 GB ram. The installatin includes Database Engine, SSAS and SSRS. I created several OLAP databases and several dozen OLAP reports just for demo purpose. The management and the end users really like this technology and the preformance of it. As a result we purchased the full license of the Sql 2005 Ent. Edition. I installed it in two virtual servers running on Windows 2003 Server R2 Ent. Edition SP1, the Database Engine and Analysis Services installed on a VM with the AMD Opteron processor 275 and 2.5 GB ram and the Reporting Services installed on a VM with the AMD Opteron processor 275 and 1.0 GB ram. I deployed the O ...Show All

• SQL Server Linking entities in report builder by table columns that are not primary or foriegn keys.

  What is the best way to join two tables by something other than there primary or foriegn keys in report builder.  I actually want a relationship between two tables based on a combination of two columns. Thanks Dear, Delete the relationship and join the table as per ur criteria.But the Primary and Foregin key Relation is the best to retrieve the record and applying functions. and also on criteria basis. HTH From Sufian ...Show All

• Software Development for Windows Vista Creating Self-Issued Card backed by a Smartcard Certificate?

  Is it possible to create a self-issued card that's backed by a Certificate on a SmartCard Hello Francis. Backing a card means supplying a mean of authentication with the STS that is invoked for issuing you the token described by the card itself. So if you back a managed card with a smartcard the STS will authenticate you according to your usage of a private key, if you back a managed card with u/pwd the STS will perform a check on that, and so on for all the 4 supported authentication methods. A self-issued card obtains its associated token by contacting an internal STS, to which you're already authenticated from the sheer fact that you are using the UI on that machine. Hence, there's no need (or way) of "backing" a ...Show All

• .NET Development Dataset.Tables[0]?????

  the dataset.tables...does that refer to the tables that returned from my dataadpater and when i include the [0] that means i am refering to the first table that has been returned from my dataAdapter, so in other words are the tables 0 index based And DataRow.Row[0] is that 0 index based refering to the current row's in my dataTable do you mean you wish to bind the table to a bindable control if so: this.theDataGridView.DataSource = table; this.theDataGridView.DataMember = "FieldName"; //if you wish to only show values of a particular column say you wish to bind to a listbox: this.theListBox.DataSource = table; this.theListBox.DisplayMember = "FieldName"; does this help ...Show All

• Visual C++ ICloneable, memory and garbage collector

  ICloneable::Clone returns a new instance of the object being cloned. However, it seems possible that the garbage collector could release this memory before the calling function receives a reference to the memory. If this can occur then it introduces an error that would only occur at random times. Is this really a problem or does .NET take the necessary steps to ensure the memory is first referenced by the calling function before the garbage collector gets a chance to check the memory Thanks, Ian Are you observing this problem, or simply surmising A local object variable is a reference, if you "return" that value from Clone at least one reference to the object will be maintained until the meth ...Show All

• .NET Development Error "ExecuteScalar requires an open and available connection..."

  H all, I have an application that retrieves data from a local SQL2005 (Standard edition) database frequently (e.g. more than 10 times/second normally). It usually works fine. However, if the program was paused for a while (e.g. for a few hours) by a pop-up error message box or an Sleep() statement, it generates the following error message when its data processing resumes: " ExecuteScalar requires an open and available connection. The connection's current state is closed ." The application is coded with C# using ADO.Net. The connection is OleDbConnection. It seems there is some timeout process that I do not know. Could anyone offer any hint Thanks, hz Yes, I believe that once you enable the shared mem ...Show All

• Visual FoxPro reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle SharathMum wrote: nNoofFile = ADIR( aFile, "C:\Temp\*.*") FOR i = 1 TO nNoOfFile INSERT INTO tableDirFile ( nr ) VALUES ( aFile[i,1] ) NEXT DELETE FROM tabelle_1 WHERE nr IN ( SELECT nr FROM tableDirFile ) this is good it gives me how many files in the directory so what i want to know now how do i get the names of the DBF files without its extension .DBF and select the names one by one or save in a current variab ...Show All

• Architecture Calling Biztalk Rules Engine Remotely

  I want to know if we can call the BRE from custom code (.NET API) remotely Lets say, The BRE is installed on Biztalk server. And I have an Asp.NET Web Application on a different IIS Server. Can I invoke the BRE from this ASP.NET web application If service is located on web server, Biztalk Framework should be installed on webserver to refer Microsoft.RuleEngine.dll. ...Show All

• Windows Forms How do I animate a button click from code?

  This code preforms the button2 operation with button2.PerformClick(), but the user has no indication that button 2 has been clicked. How do I get button2 to go down and back up public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button2_Click(object sender, EventArgs e) { Console.WriteLine("button 2 was clicked."); } private void button1_Click(object sender, EventArgs e) { button2.PerformClick(); } } Thank you B14 Thanks to everyone for their replies. Attached is working code that based on CommonGenius.com 's post. Some may find this solution too complicated. A classmate sugge ...Show All

• .NET Development process.StartInfo.Arguments

  I am trying ot run this programm from a windows form application but at command line it stops with message: "Reading passphrase from file descriptor 0 ..." and nothing happens. Same program run fine on command line with follwoing line: C:\Program Files\GNU\GnuPG>gpg --passphrase-fd 0 < c:\gnupg\passphrase.txt -o c:\HIF\Clock.swf -d c:\gnupg\Clock.gpg This is a command to decrypt the file using GnuPG encryption and decryption program. Any help is most welcome. Thank you. Bharat Gadhia. ================================= public void Decrypt() { string strArg = @" --passphrase-fd 0 < c:\gnupg\passphrase.txt -o c:\HIF\Clock.swf -d c:\gnupg\\Clock.gpg"; process.Start ...Show All

• Audio and Video Development Using Media Foundation with C# ?

  Hi, Microsoft will provide managed interface (wrapper ) for Media Foundation in order to use it with .NET Because Direct Shows is almost unusable with C#... Thanks Becky Weiss - MSFT wrote: No, unfortunately we don't have plans to include a managed wrapper for Media Foundation in its v1 (Windows Vista). IMHO that's very unpleasant. You have not provided managed wrapper for Windows Media Format SDK - OK, I have written one by myself. Windows Media Format SDK has been create long before .NET era. By why the heck you do not give what you already do have .NET Framework 1.2 (yes, there has been such development version, plz see http://www.winfx247.com/247reference/System/Windows/Media/Core/ ...Show All

• Windows Forms ListView column header height in .NET Framework 2.0

  When I increase the font size of ListView, the height of column headers keeps fixed and is smaller than the height of header text. In .NET Framework 1.1, there is no such problem. How can I solve it Thanks, Chester Hi, Peter,   Thank you for letting me know it is a bug of windows common control 6.0. The UI in my application is for touch screen, so we need very large font like this post. Because we don't mind theme and style, it's ok for us not to enable visual styles. Thanks again. Chester ...Show All