Re: Nullable datatyped and coalesce - C# Discussion Boards

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

4-Dec-07 22:15

got it through onkeydown event thank you

create objects from xml

netJP12L4-Dec-07 19:06

netJP12L

4-Dec-07 19:06

I writing my two object student and campus to a xml file but i am wondering is there a way to create student or campus object directly from the xml file. I mean I want to instiantiate student class if my program reading student data or campus from the xml file.
I couldn't find any simple example
Thanks for ur help in advance

pmarfleet4-Dec-07 19:40

pmarfleet

4-Dec-07 19:40

You should use the XmlSerializer[^] class. The documentation contains examples of its usage.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Mustafa Ismail Mustafa4-Dec-07 19:44

Mustafa Ismail Mustafa

4-Dec-07 19:44

Well, if you use XML serialization you can then create your objects from whatever source, serialize them onto your HDD and the opposite again.

Check this article out: http://www.codeproject.com/KB/cs/objserial.aspx[^]

happy coding

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

"There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib

"Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

Nouman Bhatti4-Dec-07 19:54

Nouman Bhatti

4-Dec-07 19:54

The other two posts suggested the right solution but i would like to add
that u have to design classes for that.

for example to load students directly from your XML file u need two classes
one contains the student properties whose each object represent one student and the other class to hold the collection of these student class objects