Returning datatable/dataset by from server in a Multithread Client server socket

Question

0.00/5 (No votes)

See more:

How can I do the following number 4 and 5 task using client server socket programming?
1. Client send a query as regular text to the server. [I can do this]
2. Server get the SQL from the client. [I can do this]
3. Server execute the query(Select statement). [I can do this]
4. Server return the query result as datatable or dataset to the client [How can I do this]
5. Client get the datatable or dataset and display to the client side.[How can I do this]
Please help me guys I have to submit my project very soon

Posted 22-Mar-11 19:33pm

Pritam N. Bohra

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-03-22T19:38:00

For filling the dataset, have you had a look at this: http://msdn.microsoft.com/en-us/library/377a8x4t.aspx[^]

And for displaying the result, it depends what technology you use (WinForms, WPF, ...) and what requirement you have but for example this control may help you http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx[^]

Mahendra.p25 · Answer 2 · 2011-03-22T20:06:00

hi
You need dataadapter to fill the dataset

SqlDataAdapter da = new SqlDataAdapter(CommandObj,ConnectionObj)
da.fill(ds);

to diplay the data you need controls like GridView,Repeater,dataList

now you have to bind that dataset to gridview or repeater like

gridView.DataSource= ds;
gridView.DataBind();

Returning datatable/dataset by from server in a Multithread Client server socket

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0