Re: adapter.fill method Catch and Finally block do not execute - C# Discussion Boards

Programm3r14-Jan-09 2:40

14-Jan-09 2:40

Christian Graus wrote:
The sigs around here are getting stranger and stranger. C# is not a complex language, I don't see how being a user of it, means someone is terribly good.

I think I should really change my sig, the strange thing is that it use to be "... C ..." and everybody was fine with that(during my first two year of being a member), but after I made it "... C# ..." I'm dodging bullets. Maybe I should change it back Unsure | :~

Christian Graus wrote:
If you're running it remotely, I think it runs as the remote user and so won't show on the desktop. But, I could be wrong.

That is what I thought too, but then I changed my local PC account to the account name of the remote PC, and it still does the same thing.

Thanks for the input.

The only programmers that are better those C# programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Christian Graus14-Jan-09 3:05

Christian Graus

14-Jan-09 3:05

Programm3r wrote:
the strange thing is that it use to be "... C ..." and everybody was fine with that(during my first two year of being a member), but after I made it "... C# ..." I'm dodging bullets.

Yeah, that makes sense. You know C and C# are almost totally different, right ?

Christian Graus

Driven to the arms of OSX by Vista.

Programm3r14-Jan-09 3:14

14-Jan-09 3:14

Yeah, almost Smile | :)

The only programmers that are better those C# programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Programm3r14-Jan-09 2:54

14-Jan-09 2:54

Accoring to this[^] it is due to security reasons..

The only programmers that are better those C# programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Programm3r14-Jan-09 3:17

14-Jan-09 3:17

Ok, even if you make use of a batch file that starts the UI application on the remote PC side ... does it not work, looks like there is no way around this one ?? Confused | :confused:

The only programmers that are better those C# programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

adapter.fill method Catch and Finally block do not execute

Dave Kreskowiak14-Jan-09 3:44

Dave Kreskowiak

14-Jan-09 3:44

You cannot create an interactive process remotely. This is so someone can't start an arbitrary application and trick someone into entering usernames and passwords or credit card information or some other sensitive information.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

mpavas14-Jan-09 1:56

mpavas

14-Jan-09 1:56

I have the below lines of code in a windows service.

When I run the service locally this works fine. But on the server it creates an issue on line no 6 "_dAdapter.Fill method". I can not debug it on the server as there is no VS 2005 installed.

The issue is the program just hangs and do not move further to line no 6 and it never comes on catch. It do not come on Finally block too.

Please advice.

1. try
2. {
3. ...
4.OracleDataAdapter _dAdapter = new OracleDataAdapter();
5. _dAdapter.SelectCommand = _oCom;
6. _dAdapter.Fill(dsGetOrder, "process");
7. }
8. catch (Exception ex)
9. {
10. ...
11. }
12. finally { }

Regards,
Pavas

Re: adapter.fill method Catch and Finally block do not execute

Colin Angus Mackay14-Jan-09 2:04

Colin Angus Mackay

14-Jan-09 2:04

mpavas wrote:
I can not debug it on the server as there is no VS 2005 installed.

But you can add instrumentation and logging to get a view of what is happening inside your application.

mpavas wrote:
The issue is the program just hangs and do not move further to line no 6 and it never comes on catch. It do not come on Finally block too

Is your live database bigger than your test/development database? The issue could be that it is attempting to load in all that data into memory.

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

Re: adapter.fill method Catch and Finally block do not execute

Christian Graus14-Jan-09 2:27

Christian Graus

14-Jan-09 2:27

Hangs for how long ? Sounds like it's just taking a long time to execute the call.

Christian Graus

Driven to the arms of OSX by Vista.

Default character sets for fonts and foreign characters

tim_gunning14-Jan-09 1:55

tim_gunning

14-Jan-09 1:55

hi all

I seem to have run into a problem and was wondering if anyone else had seen someting similar or could point me in the right direction.
I have an application that displays user inputted text in a choice of fonts (they choose). However when somebody inputs cyrillic text it doesnt show into the correct font (AbbeyRoad NF) but displays it in Arial. I thought this was because I set a default font face and then try to reset as the chosen one but this isnt the case, as AbbeyRoadNF doesnt have the cyrillic char set in it I'm assuming its defaulting to Arial internally but I can't see where this is happening as its not throwing any errors and I need to catch where this happens so I can alter the font for the print processing (which doesnt default to Arial).

has anyone heard of anything like this ? Any thoughts at all welcome.

thanks

tim

DataGridView and DataSet , Update and AccpetChanges

half-life14-Jan-09 1:52

half-life

14-Jan-09 1:52

Hi,

the situation is this :

i have a datagridview bound to a dataset.

when i click on a button i've got on every datagridviewRow i need to update the changes in the same row, the thing is that i need also to change a column named "status" in the same row

here is the event :

private void dgvCalibrtion_CellContentClick(object sender, DataGridViewCellEventArgs e)
 {

     if( e.ColumnIndex == 6)
     {
             UpdateCalibrtionData((dgvCalibrtion.Rows[e.RowIndex].DataBoundItem as DataRowView).Row, e.RowIndex);
             TA_CalibrationData.Update((dgvCalibrtion.Rows[e.RowIndex].DataBoundItem as DataRowView).Row);
             dS_StationManager.T_CalibrationData.AcceptChanges();


     }
 }

the thing is that the change in the column status //Cell[2]// never send to the DB
the Datagridview shows the string ("Valid", ... ) but does'nt pass the change to the *.mdb,
Neither the color of the string is changed.

but all the other manually changes to the datagridview ( input from user ) is updated o.k.
//Here i'm changing the value of the cell myself//

private void UpdateCalibrtionData(DataRow dgvDataRow, int RowIndex)
{

    DateTime ncalTime = (DateTime)dgvDataRow.ItemArray[3];

    if (ncalTime < DateTime.Now)
    {
        dgvCalibrtion.Rows[RowIndex].Cells[2].Style.ForeColor = Color.Red;
        dgvCalibrtion.Rows[RowIndex].Cells[2].Value = "Date Expired";
        return;
    }

    if (ncalTime > DateTime.Now)
    {
        if (ncalTime < DateTime.Now.AddDays(SM_ApplicationData.Instance.CalibrationThreshold))
        {
            TimeSpan dayDiff = (DateTime.Now - ncalTime);
            int dDays = -(dayDiff.Days - 1);
            dgvCalibrtion.Rows[RowIndex].Cells[2].Style.ForeColor = Color.Orange;
            dgvCalibrtion.Rows[RowIndex].Cells[2].Value = "will expire in" + dDays.ToString() + " Days";
            return;
        }

        dgvCalibrtion.Rows[RowIndex].Cells[2].Value = "Still Valid";
        dgvCalibrtion.Rows[RowIndex].Cells[2].Style.ForeColor = Color.Green;
    }
}

any one???

Smile | :)

Have a nice day

Have Fun
Never forget it

Please Can any one Help

Member 284246814-Jan-09 1:24

Member 2842468

14-Jan-09 1:24

I am getting problem in searching. I am using SQL2005 and C#.net 2008. I have 6 text boxes to take input from user. input is depend upon user

either input for search in 1 textbox, either input in 2 or either input in 3 or in all

i am looking how can i handle it. i am not using data set in this application at all.

i have stproc for all other operations. please let me know how can i handle it.

thanks

musefan14-Jan-09 1:39

musefan

14-Jan-09 1:39

how to handle what? getting input from a textbox?

I think you may need to re-write your problem here Smile | :)

musefan14-Jan-09 1:46

musefan

14-Jan-09 1:46

are you able to create a connection to the server and query a database?

you will need to build your query string dynamically based on the input from the user.
make sure you use parameters thou and not direct text appends

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Colin Angus Mackay14-Jan-09 2:15

Colin Angus Mackay

14-Jan-09 2:15

Well, what specifically are you having difficulty with? Writing the query? Writing the code to query the database? Writing a stored procedure? Figuring out how to pass the parameters? Something else?

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

Member 284246814-Jan-09 2:53

Member 2842468

14-Jan-09 2:53

sorry guys,

all done

thanks

constructing own tcp/ip header

vaghelabhavesh14-Jan-09 8:58

vaghelabhavesh

14-Jan-09 8:58

Member 2842468 wrote:
all done

But what was the problem? I am curious Smile | :)

Member 458420114-Jan-09 0:59

Member 4584201

14-Jan-09 0:59

Hi All,

I would like to create own tcp/ip header for my client in c# like raw and can be send with data, my application wants this kind of process for my client.

Can any one please help me out in this with example or code in c#.

Thanks n Regards
Ankur Shrivastava Sleepy | :zzz:

Re: constructing own tcp/ip header

Dave Kreskowiak14-Jan-09 3:39

Dave Kreskowiak

14-Jan-09 3:39

That's a very bad solution to an unknown problem. RAW packets can only be created by an admin level account since Windows XP Service Pack 2.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

storing Data from textbox created At runtime?

developer.ravish14-Jan-09 0:53

developer.ravish

14-Jan-09 0:53

public partial class try1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected override void OnInit(EventArgs e)
{
base.OnInit(e);
string query_ddl = "select range from DDLValue";
SqlDataAdapter da = new SqlDataAdapter(query_ddl, con);
DataSet ds = new DataSet();
con.Open();
da.Fill(ds);
con.Close();
ddl_value.DataSource = ds;
ddl_value.DataTextField = "Range";
ddl_value.DataValueField = "Range";
ddl_value.DataBind();
}
protected void ddl_value_SelectedIndexChanged(object sender, EventArgs e)
{
createTextbox();
}

private void createTextbox()
{
string selectedValue = ddl_value.SelectedValue;
if (!string.IsNullOrEmpty(selectedValue))
{
int aSample = Convert.ToInt32(selectedValue);
for (int i = 0; i > aSample; i++)
{
TextBox txtbox = new TextBox();
txtbox.ID = "txt" + i.ToString();
Button1.Click += new EventHandler(Button1_Click);
PH1.Controls.Add(txtbox);
}
}

}
protected void Button1_Click(object sender, EventArgs e)
{

}

}
}

How insert Data from Textbox at Button_click

Tom Deketelaere14-Jan-09 1:25

Tom Deketelaere

14-Jan-09 1:25

At first glance there are several things wrong with this code.

1: you create several textbox controls but you don't set there location, so unless 'PH1' is a tablelayoutpanel or flowlayoutpanel all your textbox's will be shown on top off each other.

2: why add a new eventhandler to button1 for every textbox you create.
If button1 is created at designtime you don't need to add an eventhandler to it in code.
If button1 is created at runtime (off which there is no code here) adding it only once should be enough.

3: as to your question, the way you wrote it here you have 2 options.
Having a array variable (global) and adding all your textbox's to this array, then in button click event iterate this array.
Or iterate all the controls in 'PH1', check if there type is of the type textbox and get the text that way.

Re: storing Data from textbox created At runtime? [modified]

developer.ravish14-Jan-09 2:32

developer.ravish

14-Jan-09 2:32

Can u Post Some code or Links

Tom Deketelaere14-Jan-09 2:44

Tom Deketelaere

14-Jan-09 2:44

I knew this question was going to come.

Did you at least try to do anything I said?

I don't write c# so can't help you with that

But here is some vb.net code (easy to convert)

for each c as control in PH1.controls
if c.gettype.equals(gettype(textbox)) then
dim txt as textbox=c
dim textstring as string = txt.text 'now you have the text in the textbox
end if
next

modified on Wednesday, January 14, 2009 8:51 AM

developer.ravish14-Jan-09 19:19

developer.ravish

14-Jan-09 19:19

Give Error at GetType?
How track the Dynamic id of textbox?