Re: How to increase Web Service performance ? - C# Discussion Boards

Re: Programmatically updating application properties or help creating my own xml file please.

Super Lloyd31-Jul-09 4:03

Super Lloyd

31-Jul-09 4:03

Ho.. ok, well I might do an extra effort this week end! Wink | ;-)

Caught in my own trap! Laugh | :laugh:

A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station....
_________________________________________________________
My programs never have bugs, they just develop random features.

Re: Programmatically updating application properties or help creating my own xml file please.

JollyMansArt1-Aug-09 2:33

JollyMansArt

1-Aug-09 2:33

Thanks a lot that was very helpful! Smile | :)

Re: Programmatically updating application properties or help creating my own xml file please.

Super Lloyd1-Aug-09 16:53

Super Lloyd

1-Aug-09 16:53

Good!

Now I should write an article about that! Roll eyes | :rolleyes:

not able to view the form controls when thread is running [modified]

Vivek Vijayan31-Jul-09 2:37

Vivek Vijayan

31-Jul-09 2:37

not able to view the form controls when thread is running
can any one help...plss
m using thread and timer
any problem in using timer or thread

This code was posted by me...

modified on Friday, July 31, 2009 8:57 AM

Re: not able to view the form controls when thread is running

stancrm31-Jul-09 3:30

stancrm

31-Jul-09 3:30

If you create / change a form from another thread, then you must use invoke to change anything in that form.

http://www.crowsprogramming.com/archives/18[^]

How to increase Web Service performance ?

hdv21231-Jul-09 2:35

hdv212

31-Jul-09 2:35

Hi i created a web service to load some information from sql server 2005 database, it works good but it has very low speed to return data, wheras sql server load data without overhead. i think the decreasing performance occures in while loop, here is my code :

[WebMethod]
        public List<InputOutput> GetAllInputOuts()
        {
            List<InputOutput> list = new List<InputOutput>();
            using (System.Data.SqlClient.SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["IOXPConnectionString"].ConnectionString))
            {
                using (SqlCommand cmd = con.CreateCommand())
                {
                    cmd.CommandText = "select * from vLinkToDataSource";
                    SqlDataReader dr = null;

                    if (con.State != ConnectionState.Open)
                        con.Open();
                    dr = cmd.ExecuteReader();

                    while (dr.Read())
                    {
                        InputOutput io = new InputOutput();
                        io.Code = dr.GetInt32(2);
                        io.Name = dr.GetString(1);
                        io.Family = dr.GetString(0);
                        io.DateInput = dr.GetString(3);
                        io.TimeInput = dr.GetString(4);
                        io.DateOutput = dr.GetString(5);
                        io.TimeOutput = dr.GetString(6);
                        list.Add(io);                        
                    }

                }
            }
            return list;
        }

how to improve the performance ?
Note 1 : the sql server 2005 return results good.
Note 2 : almost 17000 records exists in database.
Note 3 : beacuse i want to use this web Service in sharepoint, i must return result as List<T>.
Any help would be great appreciated

Re: How to increase Web Service performance ?

Dave Kreskowiak31-Jul-09 4:58

Dave Kreskowiak

31-Jul-09 4:58

So, you're returning all 17,000 records, adding them one at a time to the List<t>, then having the Web Method serialize the entire List<t> (will probably take a while), tranferring what amounts to megabytes of XML text, then having the client deserialize the entire list (will probably take a while, again)??

I think you biggest problem is trying to handle 17,000 records all at once. I'd probably want to limit the data I return from the database and reduce the dataset to only the data that is absolutely necessary at a certain point in time. What are you doing with all 17,000 records that you need to transfer them all?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: How to increase Web Service performance ?

hdv21231-Jul-09 6:37

hdv212

31-Jul-09 6:37

Hi Dave
my goal is load all data into sharepoint via bussiness data catalog (bdc), it's finder method, then write another webMethod to find only data which matched to criteria, It's specific finder method.

Re: How to increase Web Service performance ?

Dave Kreskowiak31-Jul-09 7:28

Dave Kreskowiak

31-Jul-09 7:28

Well, then I'd probably look at a caching solution on the Sharepoint side if your data doesn't change very often, or if your SQL Server is 2005 or above, some kind of solution to return the query as your XML dataset and returning that to the client.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: How to increase Web Service performance ?

hdv2121-Aug-09 9:21

hdv212

1-Aug-09 9:21

Thanks Dave
but, what's XML dataset ?
can u give me an example ?
thanks

Re: How to increase Web Service performance ?

Dave Kreskowiak2-Aug-09 6:12

Dave Kreskowiak

2-Aug-09 6:12

I don't have any examples, but you can start your own research into it by Googling for "SELECT FOR XML".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Middle mouse click and scroll

gwithey31-Jul-09 1:05

gwithey

31-Jul-09 1:05

I am experiencing difficulty trying to make a trackbar scroll when the middle mouse button/ball is clicked and scrolled.

I need the mouse scroll wheel to scroll up and down when it is clicked and reset the value to the middle when realised.

Does anyone know how this can be done.

Thanx George

Re: Middle mouse click and scroll

gwithey31-Jul-09 1:27

gwithey

31-Jul-09 1:27

I have tried this:

private void trackBar1_Scroll_1(object sender, MouseEventArgs m)
{
if (m.Button == MouseButtons.Middle)
{
label1.Text = trackBar1.Value.ToString();
}
}

but dont know if it will work as havent got it to compile because its complaining about the delegate

this.trackBar1.Scroll += new System.EventHandler(this.trackBar1_Scroll_1);

I dont know how to change it, it works with eventArgs but i put in mouseEventArgs which i need and it does not like it.

Re: Middle mouse click and scroll

Luc Pattyn31-Jul-09 1:38

Luc Pattyn

31-Jul-09 1:38

Hi,

you can't just change the partameter types; Scroll gives an EventArgs, not a MouseEventArgs.

you are aware of the Control.MouseWheel event? That one offers a MouseEventArgs.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Middle mouse click and scroll

Baeltazor31-Jul-09 7:35

Baeltazor

31-Jul-09 7:35

Thanks for that. You just answered my question too! lol Laugh | :laugh:

2 answers in 1!

Regards,
Jason Pezzimenti.

Re: Middle mouse click and scroll

gwithey2-Aug-09 20:51

gwithey

2-Aug-09 20:51

Thank you that was a silly thing to do.

This is the first time i have worked with events so will probably make a few mistakes along the way.

data synchronization between two client machine over the internet by Webservice?

Tridip Bhattacharjee31-Jul-09 0:41

Tridip Bhattacharjee

31-Jul-09 0:41

suppose a company has two branches in UK & US. say two windows client apps are there and they would like to transfer data to each other and their local data will be synchronozed with those data. so please guide me how can i develop a webservice which will work as a bridge and accept bulk data from client a and pass to client b vice versa. if i can get the concept then i can develop a good synchronization system by webservice. where webservice will play the role like bridge who can accept bulk data and also pass bulk data to other client.
please help me to accomplish this task.

Thanks in Advance

tbhattacharjee

Re: data synchronization between two client machine over the internet by Webservice?

Dave Kreskowiak31-Jul-09 4:51

Dave Kreskowiak

31-Jul-09 4:51

You may want to look into the MS Sync Framework[^] before you try developing your own sync services, which Web Services are not really suited for anyway.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

How to know toolbar got clicked through a BHO (C#)?

svt gdwl31-Jul-09 0:05

svt gdwl

31-Jul-09 0:05

In c#, How can I hook the IE wiindow.

Can I use Hooking API's in c#?

How to use these for getting the current printer settings when a print is given from an IE window?

similarly, How to know the handles of Navigation Toolbar on IE window through windows API's?

Totally, How can I hook each and every object on IE window through c#

code for updating datatable.

Omar Akhtar Sheikh30-Jul-09 23:46

Omar Akhtar Sheikh

30-Jul-09 23:46

// please anyone could help me write the update code

public DataTable GetCustomers()
                  {
                           string query = "SELECT * FROM Customer_2";
                           SqlDataAdapter da = new SqlDataAdapter(query, constr);
                           DataTable table = new DataTable();
                           da.Fill(table);
                           return table;

                  }

                  // For Inserting Customers
                  public void InsertCustomer(string customerName)
                  {
                           string query = "INSERT INTO Customer_2 (CustomerName) VALUES (@CustomerName)";
                           SqlConnection con = new SqlConnection(constr);
                           SqlCommand com = new SqlCommand(query, con);
                           com.Parameters.Add("@CustomerName", SqlDbType.NVarChar).Value = customerName;
                           con.Open();
                           com.ExecuteNonQuery();
                           con.Close();
                  }

                  // For Deleting Customers

                  public void DeleteCustomers(List&lt;int&gt; customerIDsToDelete)
                  {
                           string query = "DELETE FROM Customer_2 WHERE CustomerID = @CustomerID";
                           SqlConnection con = new SqlConnection(constr);
                           SqlCommand com = new SqlCommand(query, con);
                           SqlTransaction tr = null;

                           try
                           {
                                    con.Open();
                                    tr = con.BeginTransaction();
                                    com.Transaction = tr;
                                    com.Parameters.Add("@CustomerID", SqlDbType.Int);

                                    foreach (int item in customerIDsToDelete)
                                    {
                                             com.Parameters["@CustomerID"].Value = item;
                                             com.ExecuteNonQuery();
                                    }
                                    tr.Commit();
                           }
                           catch (Exception ex)
                           {
                                    tr.Rollback();
                                    throw ex;
                           }
                           finally
                           {
                                    con.Close();
                           }
                  }

// please anyone could help me write the update

Re: code for updating datatable.

Not Active30-Jul-09 23:51

Not Active

30-Jul-09 23:51

Write what update code? The C# or SQL? How about this[^]?

only two letters away from being an asset

Re: code for updating datatable.

Nagy Vilmos31-Jul-09 0:01

Nagy Vilmos

31-Jul-09 0:01

Wow! ur so rad man! i'd nvr thnk 2 bing!

Cool | :cool:

[NOTE THE JOKE ICON - the norm is to use google!]

Panic, Chaos, Destruction.
My work here is done.

Re: code for updating datatable.

PIEBALDconsult31-Jul-09 4:55

PIEBALDconsult

31-Jul-09 4:55

Never heard of them.

Re: code for updating datatable.

PIEBALDconsult31-Jul-09 4:54

PIEBALDconsult

31-Jul-09 4:54

Not that I use it myself, but: DataAdapter.Update

Re: code for updating datatable.

Adam R Harris31-Jul-09 8:05

Adam R Harris

31-Jul-09 8:05

Your using your DataAdapter all wrong.

It should be declared outside the scope of the GetCustomers(), so it can be accessed by all the other functions, and you should be using it to Create/Read/Updated/Delete.

How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual C# .NET[^]

NOTE: the code below has not been tested / probably wont compile because i cant spell

your code should look something like this;

// Dont know if this is going to be accessed outside of the class
// If so you might want to make a wrapper property for it
private SqlDataAdapter da;
// Should contain your data
private DataSet ds;

..... somewhere in your initialization code .....
da = new SqlDataAdapter("SELECT * FROM Customer_2", [YourConnectionString]);
da.UpdateCommand = [your update command];
da.DeleteCommand = [your delete command];
da.InsertCommand = [your insert command];

// dont return anything here, just fill the dataset
public void GetCustomers()
{
         da.Fill(ds);
}

// Saves all the changes to the database
public void SaveChanges()
{
         da.Update(ds, "[your table name]");
         // Accept the changes in the dataset
         ds.AcceptChanges();
}

Then all you need to do is Create/Update/Delete all the rows you want in the DataSet, just make sure you call SaveChanges().

Thats how your supposed to use the DataAdapters.

But if you still want to use it in the way that you are using it, your going to have to loop through all the rows in the DataTable and check if their RowState == DataRowState.Changed (i think, could be updated), then just run your update command against SQL.

If at first you don't succeed ... post it on The Code Project and Pray.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.