I want something that is similar to vb code profiler which takes exe instead of .vbp and log the events.

In my client places, a record is missing occassionally and we could not reproduce it in our systems. I would like to track the events/function calls in the client's place with event log.

Hi, Is there any way to trap all the events, function/procedure calls fired and log it without modifying code for each function/event. Regards, Praveen

Hi, Let me explain you how I have to create to utilize msmqIntegrationBinding and netTcpBinding. The language I am using is C#. 1) Created a WCF Service Library project. 2) Created Windows Service project which has the above Library as reference 3) Configuration Settings(app.config) for WCF Service Library is placed in Windows Service project and the endpoints are defined here. The following is a piece of code for MSMQ endpoints. 4) Windows Service will be deployed in Server1 System. 5) TradeClient1 application will be residing on Client1 6) TradeClient2 application will be residing on Client2 Now my interest is create functions/procedures in WCF Service Library for this endpoints and a TradeClient1 to interact with msmqIntegrationBinding endpoint and TradeClient2 with netTcpBinding endpoint. Here MSMQ and Windows Service will be running all the time. 1) The TradeClient1 sends message to MSMQ of Client1 using msmqIntegrationBinding. 2) The message present in Client1 MSMQ will be forwarded to Server1 MSMQ (How this can be done?) 3) Windows Service which is running on the Server1 will track at any time for any new messages sent by Client1 in Server1 MSMQ (Should I go for public queue or private queue?) 4) If new message is found, it should check whether it is a duplicate message from client (To implement MessageQueueTransactionType.Automatic) 5) If it is a new Message either Windows Service or Server1 MSMQ forwards the message to Client2 MSMQ over the network 6) The MSMQ present in Client2 will receive message from Windows Service 7) When TradeClient2 is up it should read messages from MSMQ and update accordingly. One last thing to mention... I would not like to go for Active Directory as we are only using LAN. Could you give any guidelines in proceeding this way!!

Hi, I need a function in VB6.0 that formats a number and displays in full format. Eg. FormatFunction(1,Formattype) - One FormatFunction(222,Formattype) - Two Hundred and Twenty Two Thanks in Advance.

public static SqlDataAdapter CreateSqlDataAdapter(SqlConnection connection)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

// Create the commands.
adapter.SelectCommand = new SqlCommand(
    "SELECT CustomerID, CompanyName FROM CUSTOMERS", connection);
adapter.InsertCommand = new SqlCommand(
    "INSERT INTO Customers (CustomerID, CompanyName) " +
    "VALUES (@CustomerID, @CompanyName)", connection);
adapter.UpdateCommand = new SqlCommand(
    "UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " +
    "WHERE CustomerID = @oldCustomerID", connection);
adapter.DeleteCommand = new SqlCommand(
    "DELETE FROM Customers WHERE CustomerID = @CustomerID", connection);

// Create the parameters.
adapter.InsertCommand.Parameters.Add("@CustomerID", 
    SqlDbType.Char, 5, "CustomerID");
adapter.InsertCommand.Parameters.Add("@CompanyName", 
    SqlDbType.VarChar, 40, "CompanyName");

adapter.UpdateCommand.Parameters.Add("@CustomerID", 
    SqlDbType.Char, 5, "CustomerID");
adapter.UpdateCommand.Parameters.Add("@CompanyName", 
    SqlDbType.VarChar, 40, "CompanyName");
adapter.UpdateCommand.Parameters.Add("@oldCustomerID", 
    SqlDbType.Char, 5, "CustomerID").SourceVersion = DataRowVersion.Original;

adapter.DeleteCommand.Parameters.Add("@CustomerID", 
    SqlDbType.Char, 5, "CustomerID").SourceVersion = DataRowVersion.Original;

return adapter;

}

The above function returns adapter of SqlDataAdapter type. Could anyone suggest on how to use it for InsertCommand, UpdateCommand and DeleteCommand in some other place.

Simple databinding works fine with the following code.

Text.DataBindings.Add(Text",datatable1,"Name")

Could anyone suggest on how to do Databinding in Design mode in VS 2005

modified on Thursday, September 18, 2008 1:01 AM