|
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.
|
|
|
|
|
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
|
|
|
|
|
|
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 
|
|
|
|
|
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?
|
|
|
|
|
sorry guys,
all done
thanks
|
|
|
|
|
Member 2842468 wrote: all done
But what was the problem? I am curious
|
|
|
|
|
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  
|
|
|
|
|
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.
|
|
|
|
|
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...
|
|
|
|
|
|
Create an application that allows the user to enter the length for the three sides of a triangle as ints. The application should then determine whether the triangle is:
• A right triangle, two sides of the triangle form 90-degree angle
• An equilateral triangle, all sides of equal length
• Neither.
You must create a class to represent a triangle object and define the event handler for the Create Button. Define the necessary properties:
Constructor that take the length of the three sides of the triangle as arguments
Three properties that enable clients to access and modify the length of the three sides. If the user enters a negative value that side should be zero.
Tow features to determine whether the sides form a right triangle. The other an equilateral triangle only get accessor "read-only".
help to solve this program..please...please
|
|
|
|
|
I will!!
But first, build me a house that has:
- Four bedrooms
- A garage
- A beertender in every room
I are troll
|
|
|
|
|
Obvious homework questions don't go down well here. Be more specific, and show you've had a go first. You might get a useful an answer that way.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
