|
Make sure the size of dsMI[i] is one more than the value after "j <= " in for statement.Also if you are using "<" instead of "<=" put size equal to the value after "<".Check following lines, it will make it clear:
dsMI[i] = new DataSet_MI[size]; // if you use j < size
and
dsMI[i] = new DataSet_MI[size + 1]; // if you use j <= size
Until you realize this message has nothing to say, its too late to stop reading
|
|
|
|
|
hi .i have problem connecting the database to the textbox
SqlConnection cnn = new SqlConnection("server=(local); database=pubs;Integrated Security=SSPI");
SqlDataAdapter da = new SqlDataAdapter("select * from authors", cnn);
DataSet ds = new DataSet();
da.Fill(ds);
if i settle the connection above..
how do i connect the data from table authors e.g. 'name' to the textbox..
this.textbox.text = ???????
|
|
|
|
|
this.textbox.text = ds.DataTable[0].Rows[0]["name"].ToString();
|
|
|
|
|
|
datatable's function is to get one record ..
DataTable table999;
string command = "select * from Table1";
SqlDataAdapter father = new SqlDataAdapter(command, myConnection);
DataSet son = new DataSet();
father.Fill(son,"Table1");
table999 = son.Tables["Table1"];
this.aaa.Text= table999.Rows[0]["name"].ToString();
it said tat the father.fill(son,"Table1") got problem
|
|
|
|
|
Because the table name is the one you added in the dataset:
DataTable table999;
string command = "select * from Table1";
SqlDataAdapter father = new SqlDataAdapter(command, myConnection);
DataSet son = new DataSet();
son.Tables.Add("Table1");
father.Fill(son, "Table1");
...
That's work.
But there has only one select statement in your case, why don't you use the index rather than table name?
|
|
|
|
|
how to do that in index? can u pls kindly show your code. thanks
|
|
|
|
|
As I posted before:
this.textbox.text = ds.DataTable[0].Rows[0]["name"].ToString();
|
|
|
|
|
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#
|
|
|
|
|
|
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
|
|
|
|
|
you want to scroll bar show in the panel or your user control??
|
|
|
|
|
i want it in splitter control panel2.which i have used in user control.
amit
|
|
|
|
|
Did you set the panel2.AutoScroll to true? It's default is false
|
|
|
|
|
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
|
|
|
|
|
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...
dipak
|
|
|
|
|
Try passing System.DBNull.Value rather than just null.
|
|
|
|
|
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?
|
|
|
|
|
|
Using Plain Socket connection
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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;
|
|
|
|
|
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.
|
|
|
|
|
Sorry I forgot to mention that Im in Developing WEB APPLICATION
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
