MultiClient Prob. - C# Discussion Boards

export datagridview to excel

5-Dec-07 16:40

As I posted before:
this.textbox.text = ds.DataTable[0].Rows[0]["name"].ToString();

Nitin Raj4-Dec-07 20:31

Nitin Raj

4-Dec-07 20:31

i have to export the data present in a datagridview to excel. Does anyone know how to do it. this is windows application using c#

Re: export datagridview to excel

Vasudevan Deepak Kumar4-Dec-07 21:40

Vasudevan Deepak Kumar

4-Dec-07 21:40

A quick Google search got me this code snippet:

http://www.dotnetspider.com/kb/Article2356.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Scrolling in form

amit_834-Dec-07 20:23

amit_83

4-Dec-07 20:23

Hi,
i have a user control windows form.where i use splitter control.
and i drag this user control on another form. i want scrolling on
my user control.for which i have use used splitter control.but
splitter control,do not shows scrolling (splitter control panel2)
so how can i show scrolling in user control, when i drag it in to another form.

amit

Re: Scrolling in form

Jacky Yiu4-Dec-07 20:33

4-Dec-07 20:33

you want to scroll bar show in the panel or your user control??

Re: Scrolling in form

amit_834-Dec-07 21:22

amit_83

4-Dec-07 21:22

i want it in splitter control panel2.which i have used in user control.

amit

Re: Scrolling in form

Jacky Yiu4-Dec-07 23:44

Nullable datatyped and coalesce

4-Dec-07 23:44

Did you set the panel2.AutoScroll to true? It's default is false

MultiClient Prob.

DeepOceans4-Dec-07 20:07

DeepOceans

4-Dec-07 20:07

I want to send video file to multiclients from server using sockets in C# . As using threads I've successfully sent to multiclients but not simultaneously.
If one client sends a request to server for a file, then server starts transmitting it and during that transmission if any other client sends request for file then 1st transmission got prob. and 2nd one also not initiated.
plz help me out how to send file to multiclients simultaneously.
Thanx.

Shanzay

DIPAK@EMSYS4-Dec-07 19:50

DIPAK@EMSYS

4-Dec-07 19:50

Hi all i am using Coalesce function in sqlserver 2005 following is sp
ALTER PROCEDURE [dbo].[GetAllBillDetails]
(
@FromDate AS DATETIME,
@ToDate AS DATETIME
)
AS
BEGIN
DECLARE @Err int

SELECT
BillNo,
SalesDate,
CustName,
Address,
Discount,
TotalAmount,
NetPayable
FROM
Sales
WHERE
SalesDate BETWEEN COALESCE(@FromDate,SalesDate)
AND COALESCE(@ToDate,SalesDate)
SET @Err = @@Error
RETURN @Err
END

following is code to in C# to call this sp

private void BindGrid()
{
SqlCommand command = new SqlCommand("GetAllBillDetails", sqlConn);
SqlDataAdapter ada = new SqlDataAdapter();
DataSet dataSet = new DataSet("Master");
ada.TableMappings.Add("Table", "Master");
command.CommandType = CommandType.StoredProcedure;
DateTime? fdate;
DateTime? todate;

fdate = dtpFromDate.Value.Date;
todate = dtpToDate.Value.Date;

if (!dtpFromDate.Checked)
{
fdate = null;
}

if (!dtpToDate.Checked)
{
todate = null;
}

command.Parameters.Add(new SqlParameter("@FromDate", fdate));
command.Parameters.Add(new SqlParameter("@ToDate", todate));
ada.SelectCommand = command;
ada.Fill(dataSet);
}

It is giving me error like procedure or function GetAllBillDetails requires parameter @FromDate which was not supplied.

Can any one help me to solve this issue...
Dipak Thesiya
DRC Pvt Ltd... Confused | :confused:

dipak

Re: Nullable datatyped and coalesce

Colin Angus Mackay4-Dec-07 22:09

Colin Angus Mackay

4-Dec-07 22:09

Try passing System.DBNull.Value rather than just null.

Upcoming FREE developer events:
* Developer Day Scotland

My website

Chat Server

Smithakrishnan4-Dec-07 19:43

Smithakrishnan

4-Dec-07 19:43

I'm trying to make a chat server. I can make a server/client connection and use that to chat back and forth between the server and the client.

But I need to be able to have multiple clients and I don't know how to do that at all.

Can someone help me with this? Is there a tutorial for making a chat server in C# somewhere or an example of one I can look at?

Message Closed

4-Dec-07 20:07

CKnig

4-Dec-07 20:07

Message Closed

Re: Chat Server

Smithakrishnan4-Dec-07 20:53

Smithakrishnan

4-Dec-07 20:53

Using Plain Socket connection

Re: Chat Server

N a v a n e e t h4-Dec-07 20:20

N a v a n e e t h

4-Dec-07 20:20

Smithakrishnan wrote:
But I need to be able to have multiple clients

Your server program should be multi threaded. Are you using a socket connection ? If yes you have to keep all your client objects in an arraylist for further communication. When a new client is connected, create a thread for him and keep it's object in an array list/list.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Editable Grid On Keypress

Archana New to Dotnet4-Dec-07 19:23

4-Dec-07 19:23

Hi All,
Can any one please tell me how to make a grid editable on a keypress.

My exact requirement is I have a Gridview1 which has the edit column and can be updated.

but I have been asked to do it in a keypress for eg. if some press F2 the row should be Editable.

Thanks in Advance

Nouman Bhatti4-Dec-07 19:50

Nouman Bhatti

4-Dec-07 19:50

you can code in keypress event to check for F2 key press and then set the edit mode of your grid

forexample
dataGridView1.EditMode = DataGridViewEditMode.EditOnEnter;

Jacky Yiu4-Dec-07 19:54

4-Dec-07 19:54

2 simple way to complete your requirement.

1.) add a menustrip in your application, then add an item and set the shortcut to f2

2.) add a keyboard event handler in your app and detect if key == Key.f2

either way to fire a function to set the gridview tobe edit mode.

Archana New to Dotnet4-Dec-07 20:03

4-Dec-07 20:03

Sorry I forgot to mention that Im in Developing WEB APPLICATION

Jacky Yiu4-Dec-07 20:18

4-Dec-07 20:18

you can add a javascript event capture the keypress, if event == f2, then fire the callback and set the gridview as editmode.

FYR.

function dosomething()
{
var key = window.event.keyCode;
alert(key);
}

Archana New to Dotnet4-Dec-07 21:57

4-Dec-07 21:57

Since f2 is a functional key ..can you please tell how to get the keypress value for it

Archana New to Dotnet4-Dec-07 22:15