DataGridView and DataSet , Update and AccpetChanges - C# Discussion Boards

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: ^_^

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: ^_^

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

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

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.

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.

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

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

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

how to handle what? getting input from a textbox?

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

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

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?

* 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.

sorry guys,

all done

thanks

Member 2842468 wrote:
all done

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

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:

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

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

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.

Can u Post Some code or Links

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

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

developer.ravish wrote:
Give Error at GetType?

What's the error? please be more descriptive when asking questions.

developer.ravish wrote:
How track the Dynamic id of textbox?

What do you mean by this. If you mean how can you just put 'txt1.text' in your code and get the text form that dynamicly created textbox, then you can't (well maybe with reflection but I don't know).

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string query_ddl = "Query";
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();
ddl_value.Items.Insert(0, (new ListItem("Please Select Value", "0")));
}
}

protected void ddl_value_SelectedIndexChanged(object sender, EventArgs e)
{
createTextbox();
}

private void createTextbox()
{

TableRow tr = new TableRow();
TableCell tc = new TableCell();

string selectedValue = ddl_value.SelectedValue;
if (!string.IsNullOrEmpty(selectedValue))
{
int count = Convert.ToInt32(selectedValue.ToString());
for (int i = 0; i < count; i++)
{
tr = new TableRow();
tc = new TableCell();
TextBox txtbox = new TextBox();
txtbox.ID = "txt" + i.ToString();
tc.Controls.Add(txtbox);
tr.Cells.Add(tc);
tbl1.Rows.Add(tr);

tr = new TableRow();
tc = new TableCell();
TextBox txt_box = new TextBox();
txtbox.ID = "txt_" + i.ToString();
tc.Controls.Add(txt_box);
tr.Cells.Add(tc);
tbl2.Rows.Add(tr);

}

// tbl1.Rows.Add(tr);

}

}

Now on Button_Click i want to save Data From the Texboxes?

This is completely different than the first code you posted.

But basicly its the same, you'll have to go thru all the rows of tbl1 and tbl2.
Get the cell of that row(since you only have one column you should be able to get it very easy). That cell should then contain your textbox off which you can get the text.

pseudo code (vb.net sorry)

for each row as datarow in tbl1
dim txt as textbox = row.item(0).control(0)
dim data as string = txt.text
next

You'll have to adapt this code it is untested and from memory so...

how to find controls