C# Discussion Boards - CodeProject

31-Aug-09 9:48

AFIK there is no system defined large cross cursor.

BTW, why go through all of this rather than use Cursors.Cross and Cursors.None?

only two letters away from being an asset

Re: [Message Deleted]

Christian Graus31-Aug-09 15:35

Christian Graus

31-Aug-09 15:35

Don't delete your question, that is really rude.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

[Message Deleted]

skhan1731-Aug-09 6:41

Re: Dropdown list value is not retaining on page post back

31-Aug-09 6:41

[Message Deleted]

Not Active31-Aug-09 6:49

Re: Dropdown list value is not retaining on page post back

31-Aug-09 6:49

First, this is the wrong forum, you should use the ASP.NET forum as this question is ASP.NET, not C# in general

Second, we're not going review all of you code. Describe your problem and include the relevant bits, not everything.

only two letters away from being an asset

skhan1731-Aug-09 7:12

Re: Dropdown list value is not retaining on page post back

31-Aug-09 7:12

I am sorry for posting it here...I am deleting the post from here....and to my defense I would say that I thought this much code would be needed to see what I am trying to do here. Though it might seem to be a very unprofessional way to some of us.

stancrm31-Aug-09 8:19

stancrm

31-Aug-09 8:19

Just info :

1. Do some debugging, and give us only the line, where exception/error is thrown.
2. If we see a lot of code, then we just skip it, sometimes we have no times to review all of your codes.

Re: Dropdown list value is not retaining on page post back

skhan1731-Aug-09 8:48

Re: Dropdown list value is not retaining on page post back

31-Aug-09 8:48

private void Page_Load(object sender, System.EventArgs e)
{
if (this.IsPostBack)
{
getMLNO(Specific_Query_DDL.SelectedItem.Value); //This is where I am generating all the values from the DB for the second dropdown list. And as it's getting post back so even if I click submit button then the page gets post back and the selected value for the second dropdown list gets set to the default value, which is ANY
}
}
private void getMLNO(string selectedvalue) //This is the method where all the MLNOs are generated
{
if(selectedvalue=="ResistantL")
{
string sql= "SELECT re_MLNO, MAX(re_SpecimenDate)-MIN(re_SpecimenDate) AS DaysSeronegative FROM ml_hiv_status WHERE (re_HIV1_Status=0) GROUP BY re_MLNO";

OleDbConnection connection = new OleDbConnection(HIV.Database.DataConstants.CONNECTION_STRING);
OleDbDataAdapter adapter = new OleDbDataAdapter();
OleDbCommand command = new OleDbCommand(sql, connection);

DataSet ds = new DataSet();
adapter.SelectCommand = command;

if (adapter.Fill(ds) > 0)
{
DataView view = ds.Tables[0].DefaultView;
mlno_DDL.DataSource = view;
mlno_DDL.DataValueField="re_MLNO";
mlno_DDL.DataTextField = "re_MLNO";
mlno_DDL.DataBind();
resultsLabel.Visible= true;
mlno_DDL.Items.Insert(0, "ANY");
}
connection.Close();
}
}
private void mlno_DDL_SelectedIndexChanged(object sender, System.EventArgs e)
{
}

private void submitButton_Click(object sender, System.EventArgs e) //SubmitButton_Click method fetches all the data from the Database depending on the 2 values selected from the 2 dropdown list
{
if(Specific_Query_DDL.SelectedItem.Value=="ResistantL")
{
if(mlno_DDL.SelectedItem.Value=="ANY") //All the values from the Db are pulled if ANY is chosen from the second DDL
{
executeResistantListQuery_ANY();
}
else if(mlno_DDL.SelectedItem.Value!="ANY") //Data are pulled if a specific MLNO is chosen from the DB, and this one is not working as always ANY value is chosen from the postback method
{
executeResistantListQuery_MLNO(mlno_DDL.SelectedItem.Value);
}
}

}

Please help. Thank you.

Christian Graus31-Aug-09 12:03

Christian Graus

31-Aug-09 12:03

skhan17 wrote:
if (this.IsPostBack)
{
getMLNO(Specific_Query_DDL.SelectedItem.Value);

This will reset the selected item. This is still not the ASP.NET forum.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Dropdown list value is not retaining on page post back

stancrm31-Aug-09 20:30

stancrm

31-Aug-09 20:30

Wrong forum. Go to ASP.NET forum.

Re: Dropdown list value is not retaining on page post back

skhan171-Sep-09 3:09

UDP-Server (Connection closed by remote host!?)

1-Sep-09 3:09

Thank you all for your suggestion and very strong criticism. This is posted in ASP.NET as well and I don't want to have any reply anymore. Thanks again.

Re: [Message Deleted]

Luc Pattyn31-Aug-09 16:19

Luc Pattyn

31-Aug-09 16:19

Please do not delete a message, it creates a mess and is against the rules.
When you're satisfied or no longer interested, edit the message to indicate so in the subject line.

Smile | :)

Luc Pattyn

Badger | [badger,badger,badger,badger...]

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

softwarejaeger31-Aug-09 5:52

softwarejaeger

31-Aug-09 5:52

Hello,

i have a very strange problem, i have a multi-threaded udp-server and a client. Everytime i send a datagram to my server i get a SocketException "Connection was closed by remote host". CONNECTION? in UDP?

I've made my UDP-Server directly with Sockets and not with UdpClient. But the same error i got as i had my server with UdpClient. I really don't know what's wrong there...

Does somebody knows something about this Exception? Can somebody help me please?

Re: UDP-Server (Connection closed by remote host!?)

harold aptroot31-Aug-09 7:00

harold aptroot

31-Aug-09 7:00

Maybe it has something to do with this[^]?
I'm not sure though

Interop.Excel (2007) Trouble...

Jacob Dixon31-Aug-09 5:48

Jacob Dixon

31-Aug-09 5:48

I am having the hardest time tyring to read from a Excel workbook and putting it into a listview.
I cannot seem to find any good examples online of how to do this with Excel 2007.

Below is basically what I have. It is a standard template. I will NOT know how many rows will be in the workbook either.
So what I am trying to do it take what is in the excel workbook and put it into a listview to get ready to IMPORT into a database.

The reason I am not using the OLB driver is because I didn't really like it. It tended to mess up formats or not import anything.

Excel.Application xla = new Excel.Application();
Excel.Workbook wb = xla.Workbooks.Open(txtFile.Text, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "\t", true, false, 0, true, false, false);
Excel.Sheets excelSheets = wb.Worksheets;

Excel.Worksheet ws = (Excel.Worksheet)excelSheets.get_Item(1);

int g = 1;
for (int i = 1; g <= ws.Rows.Count - 1; i++)
{
    Excel.Range range = ws.get_Range("A" + i.ToString(), "J" + i.ToString());
    System.Array _values = (System.Array)range.Cells.Value2;

    ListViewItem lstItem = new ListViewItem();
    lstItem.Text = _values.GetValue(g, 1).ToString();
    lstItem.SubItems[1].Text = _values.GetValue(g, 2).ToString();
    lstItem.SubItems[2].Text = _values.GetValue(g, 3).ToString();
    lstItem.SubItems[3].Text = _values.GetValue(g, 4).ToString();
    lstItem.SubItems[4].Text = _values.GetValue(g, 5).ToString();
    lstItem.SubItems[5].Text = _values.GetValue(g, 6).ToString();
    lstItem.SubItems[6].Text = _values.GetValue(g, 7).ToString();
    lstItem.SubItems[7].Text = _values.GetValue(g, 8).ToString();
    lstItem.SubItems[8].Text = _values.GetValue(g, 9).ToString();
    lstItem.SubItems[9].Text = _values.GetValue(g, 10).ToString();

    lstImport.Items.Add(lstItem);

    g++;
}

xla.Quit();

Not Active31-Aug-09 6:54

31-Aug-09 6:54

If you're just telling us what your working on, then use Twitter or Facebook, otherwise clearly state the problem and/or question you have.

only two letters away from being an asset

Jacob Dixon31-Aug-09 7:51

Jacob Dixon

31-Aug-09 7:51

Let me quote this out for you on what I'm trying to do:

So what I am trying to do it take what is in the excel workbook and put it into a listview to get ready to IMPORT into a database.

I did forget to put in the error. It is giving me a index out of range error. Now how about you state "Hey you forgot to post the error it was getting".
I understand that I forgot that. Now I did provide what I was TRYING to do.

So maybe you should read it before jumping down someones throat.

Not Active31-Aug-09 8:18

31-Aug-09 8:18

Jacob Dixon wrote:
So what I am trying to do it take what is in the excel workbook and put it into a listview to get ready to IMPORT into a database.

Yes, you've stated that before. Repeating it doesn't change it.

Jacob Dixon wrote:
Now how about you state "Hey you forgot to post the error it was getting".

No, it's your responsiblity to include all relavant information.

Jacob Dixon wrote:
Now I did provide what I was TRYING to do.

So we are supposed to imply the difficulties and/or exceptions or errors you are getting simply because you've state what you are TRYING to do.

Jacob Dixon wrote:
So maybe you should read it before jumping down someones throat.

Perhaps the same advice to you. Read this[^] and pay attention to item #2.

Jacob Dixon wrote:
It is giving me a index out of range error.

Have you debugged this code? Where is it throwing this exception? Is it when accessing the Excel Workbook, Row or the ListViewItem. We're not here to debug your code for you.

only two letters away from being an asset