Re: Is there any way ... [modified] - C# Discussion Boards

17-Aug-06 1:57

Hi all
I create a variable in Crystal report(formula editor) , for example :
numberVar MyNumber;
if MyNumber=10 then {TestReport.firstname} = {?myfirstname}
I want to use this variable(MyNumber)in Form1.cs(using c#.net).
How can do it , ? if not , what's the best way to passing this variable into the My Form.
Thanks

s_mostafa_h

lmoelleb17-Aug-06 2:13

Re: Is there any way ... [modified]

17-Aug-06 2:13

Yes, there are actually several ways to get to Rome... Oh, you mean something else...you might want to read point 3 in the post "How to get an answer to you question" pinned as the first post in this forum.

mostafa_h17-Aug-06 2:21

17-Aug-06 2:21

if u are angry , it's better for u to rest and relax ... .

s_mostafa_h

lmoelleb17-Aug-06 3:23

17-Aug-06 3:23

I am not angry, just using sarcasm.

Basically there are two reasons to use a decent subject:
1) It increase the likelyhood of the people reading your question are actually the people able to answer it - instead of just a random selection.
2) The forum becomes useless if all subjets simply says "how do i...", "help with..." etc. This means less users and hence fewer answers.

So for your own sake - and for the rest of us - please do not write meaningless subjects.

mostafa_h17-Aug-06 3:35

17-Aug-06 3:35

ofcourse , u are right , Blush | :O

but actually , I searched in anywhere to solving my problem .
in any case , if u are a developer , it's better to guide us for ur explaining .
Yours ,

s_mostafa_h

lmoelleb17-Aug-06 7:05

17-Aug-06 7:05

I am a developer, but I do not know Crystal Reports (and prefer to keep it that way). I did guide you by suggesting you post in a way so people with the required knowledge MIGHT look at your post.

mostafa_h17-Aug-06 7:42

Accessing Visual Source Safe or VSS using C#

17-Aug-06 7:42

it's better to forgot it ...

s_mostafa_h

Sriramv8217-Aug-06 1:53

Sriramv82

17-Aug-06 1:53

Hi Friends

This is Sriram working as a Software Engg in Chennai.

I have a requirement that has to access the VSS database.

The functionality must do what ever can be done using VSS client such as Checking out a specific folder or file, Checking in or getting the latest version of a specific folder by the specified user.

All these operations have to be performed through my C# code.

Do any one of u have done such a process or have any idea about it or is there any DLL's available to accomplish this task.

Waiting for the replies

lmoelleb17-Aug-06 2:14

17-Aug-06 2:14

There is a COM interface as far as I remember. I have for example seen a web interface based on this.

Kevin McFarlane17-Aug-06 4:55

17-Aug-06 4:55

You'll have to access the Visual SourceSafe automation model.

See How to: Create a C# Test Project[^]

Kevin

Sriramv8217-Aug-06 20:19

Sriramv82

17-Aug-06 20:19

Hi Friends

I have used SourceSafeTypeLib dll in Win32 folder to open a connection with VSS database and get the Latest of the file required.

But i am not aware of how to do the Check Out and Check in Process in using C#.

The code that i have used to Get the Latest version of the file is

IVSSDatabase m_DB;
string m_username;
ArrayList m_FileDetails = new ArrayList();
ArrayList m_UniqueFileDetails = new ArrayList();
string[] m_strPaths = new string[100];
int m_index = 0;

string result = Connect(@"C:\Documents and Settings\admin\My Documents\SampleDatabase\srcsafe.ini","pvs","pvs");
if(result=="Connected")
{
string result1 = GetLatest(@"$\Sample\Requirements\SRS",@"C:\Sample1\Requirements\SRS","pvs");
if(result1== "Completed")
{
MessageBox.Show("Successfully completed the task");
}
else if(result1 == "IVSSDatabase is null")
{
MessageBox.Show("Error while Getting the Latest");
}
}
else
{
MessageBox.Show("Cannot Establish Connection to Database Specified");
}
}
catch(Exception ex)
{
MessageBox.Show("Exception Raised");
MessageBox.Show(ex.ToString());
}

}

public string Connect(string databasePath, string username, string password)
{
m_DB = new VSSDatabaseClass();
try
{
m_DB.Open(databasePath,username,password);
}
catch(System.Runtime.InteropServices.COMException ex)
{
return ex.Message.ToString();
}
catch(Exception ex)
{
return ex.Message.ToString();
}
return "Connected";
}

public string GetLatest( string path, string localpath,string username )
{
m_username = username;
m_FileDetails.RemoveRange( 0, m_FileDetails.Count );
m_UniqueFileDetails.RemoveRange( 0, m_UniqueFileDetails.Count );
string strResult = "IVSSDatabase is null";
if( m_DB != null )
{
IVSSItem vitem = m_DB.get_VSSItem( path, false );
GetItems( path, localpath, vitem );
strResult = "Completed";
}
m_index = 0;
return strResult;
}

public void GetItems( string path, string localpath, IVSSItem item )
{
string temp = localpath;
if( item.Type == 1 ) // ignore if not project
{
}
else
{
IVSSItems ppItems;
ppItems = item.get_Items( false );
string strProj = item.Name;
foreach( IVSSItem childItem in ppItems )
{
localpath = temp;
string strUniquePath = localpath;
//m_index = 0;
string strname = childItem.Name;
string strPath = GetPaths( childItem );
string strC = strPath;
strC += "\\";
strC += strname;
localpath += strC;
string strLocalPath = localpath;
m_username = m_username.Replace(" ","");
strUniquePath += m_username;
strUniquePath += "\\";
strUniquePath += strC;
childItem.Get( ref strUniquePath, 0 ); // store as
// unique path
localpath = temp;
m_FileDetails.Add( strLocalPath );
m_UniqueFileDetails.Add( strUniquePath );
GetItems( path, localpath, childItem );
}
}
}

public string GetPaths( IVSSItem pItem )
{
string b;
string cStr = "";
IVSSItem pParent = pItem.Parent;
if( pParent != null )
{
b = pParent.Name;
if( b.Length > 0 )
{
cStr += b;
m_strPaths[m_index] = cStr;
m_index++;
GetPaths( pParent );
}
}
string strPath = "";
for( int i = m_index; i > 0; i -- )
{
strPath += "\\";
strPath += m_strPaths[ i - 1 ];
}
return strPath;
}

The above code snippet will get the latest from the VSS and creates the same folder structure as in VSS in a seperate path with user name added to the Folder Name in the Server itself from where the Files can be read and placed in the Clients machine. it works fine.

But i need to do a Check Out and Check in operation from VSS.

Do any of u aware of this operation using C#. Do post replies

Sriram

Kevin McFarlane18-Aug-06 0:10

18-Aug-06 0:10

Isn't it just a question of finding the methods for check in and check out in the SourceSafe automation model and calling them? Or is it that you've looked and it's not obvious how to access them?

Kevin

Sriramv8218-Aug-06 1:08

Sriramv82

18-Aug-06 1:08

I've looked at the methods in the SourceSafe automation model. I had some problem in accessing it while doing the Checkout and CheckIn process.

When i do the checkout i check for the file attribute to be readonly. While using the Checkout method by default the version in the VSS is updated in the local machine. I want to set a flag to control that operation. That is what the problem that i had

But now i have used the VSSFlag enum to control this.

Thanks for ur interest Kevin

Will post if i encounter any serious problem by doing it

Sriram

Change inheritance relationship dynamically using reflection

KPmylsamy20-Jan-09 20:12

KPmylsamy

20-Jan-09 20:12

Hi Sreram,

when i tried this code i am facing the problem of {System.Runtime.InteropServices.ExternalException} = {"Invalid DOS path: D:\\Projects\\Test_Msbuild\\MSBUILD\\data\\um.dat"}

Do you have any idea how to solve this problem?

Thanks
Priya
km@ciber.com

Kevin McFarlane17-Aug-06 1:36

Re: Change inheritance relationship dynamically using reflection

17-Aug-06 1:36

I have some code which looks like this:

// This class should be the only class that needs changing between Enforma & Enforma-NX
public class EnformaCubeUser : EnformaUser
// public class EnformaCubeUser : EnformaPassport
{
    EnformaCubeUser(System.Security.Principal.IPrincipal User)
    {
        base.New(User.Identity.Name);
        //base.New(User.Identity);
    }
}

Given that I know whether I am enforma or enforma-nx, as described in the initial comment, is there a way of changing the inheritance relationship of the EnformaCubeUser class according to the commented out lines using some devious reflection technique? (I am not permitted to modify the EnformaUser and EnformaPassport classes.)

Kevin

Kevin McFarlane17-Aug-06 2:40