Interop.Excel (2007) Trouble... - C# Discussion Boards

First Prev Next

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

skhan1731-Aug-09 8:48

skhan17

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.

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

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

skhan17

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.

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

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();

Re: Interop.Excel (2007) Trouble...

Not Active31-Aug-09 6:54

Not Active

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

Re: Interop.Excel (2007) Trouble...

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.

Re: Interop.Excel (2007) Trouble...

Not Active31-Aug-09 8:18

Not Active

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

Re: Interop.Excel (2007) Trouble...

FilipKrnjic1-Sep-09 4:00

FilipKrnjic

1-Sep-09 4:00

Try with GemBox spreadsheet component. It is much faster and easier to use then Excel Automation.

Re: Interop.Excel (2007) Trouble...

Jacob Dixon1-Sep-09 4:01

Jacob Dixon

1-Sep-09 4:01

Thank you so much. I will give the free version a try.
Thanks again

Oracle Parser

Fayu31-Aug-09 5:17

Fayu

31-Aug-09 5:17

Hi,

I am trying to write custom grammar to parse oracle statements. Can anyone point me to the right direction.

Thanks in advance.

Re: Oracle Parser

Richard MacCutchan31-Aug-09 6:16

Richard MacCutchan

31-Aug-09 6:16

Could you be a bit more specific as to:
1) what you are trying to achieve
2) what you have tried
3) what problems you encountered.

Re: Oracle Parser

Fayu31-Aug-09 6:47

Fayu

31-Aug-09 6:47

I want to write a parser that will allow me to take a pl/sql statement and ensure that the statement is correct based on some type of grammer that I will specify.

I have not tried anything yet because I dont even know where to start. I am looking for a resource which I can start using that will help me acheive my goal.

------------------------------------------------------------
1. Parse a selected plsql statement and validate it based on some grammar.
2. I have not tried anything yet because this is completely new to me. I am hoping someone can point me to some resource/documentation/tutorial that will help me acheive this task.

Re: Oracle Parser

Richard MacCutchan31-Aug-09 7:12

Richard MacCutchan

31-Aug-09 7:12

OK, but I don't think this is a technical C# question. I would suggest using Google, or the CodeProject search facility, looking for the keywords 'parse' and 'grammar' as a starting point.

Re: Oracle Parser

Fayu31-Aug-09 7:18

Fayu

31-Aug-09 7:18

I was hoping it was possible to do this in C#.

Re: Oracle Parser

Richard MacCutchan31-Aug-09 9:15

Richard MacCutchan

31-Aug-09 9:15

Fayu wrote:
I was hoping it was possible to do this in C#.

Well it may be, but before you can start coding you need to design the structure of your program and the logic of your parser and associated grammar. As I said before, try to search on the subjects you are interested in and you may find that someone has written a technical paper on that very subject which will lead you to a solution. Always remember that CodeProject Search and Google are the first steps in finding an answer.

But don't expect anyone on these forums to write your program for you. We are all working on our own problems as well as answering questions.

Re: Oracle Parser

Fayu4-Sep-09 7:30

Fayu

4-Sep-09 7:30

I was not expecting you to write code for me. I have googled it and have seen that antlr is one way of going but I wanted to know if it was possible to do this in C#.

Re: Oracle Parser

Richard MacCutchan4-Sep-09 8:02

Richard MacCutchan

4-Sep-09 8:02

Well, as a general statement yes, it is possible to do it (or anything else) in C#. However, your original question was framed in such a way that implied you were asking for a full solution to your problem.

Re: Oracle Parser

Pete O'Hanlon31-Aug-09 9:32

Pete O'Hanlon

31-Aug-09 9:32

Why not take a look at using ANTLR[^]? It even has an PL/SQL grammar available here[^].

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

PictureBox Stretch Problem

Muammar©

31-Aug-09 5:09

Hi,
Why do I get a funny brightening gradient-like behavior when setting the size mode to stretch a small image in a large pictureBox control??

Thank you.

We will either find a way, or make one!
(\ /)
(- .-)
C(''')(''')

Connect to VPN server

yogesh_softworld12331-Aug-09 4:41

yogesh_softworld123

31-Aug-09 4:41

Hi,
I am suffering from one problem since few weeks. Could you please try to help me?

I am a C# programmer, i have client needs:
He have 10 computers in office (VPN connection). one computer is server and all are clients. server computer has one folder it always updated time to time, i had to writer code to copy that folder from server computer. i made it and it works fine when i run that software in two system LAN connected.

But VPN server needs user authentication. how can i connect to VPN server through C# program, this is my question.

Hope nice to hear from you!

Thanks!

yogesh

Re: Connect to VPN server

stancrm31-Aug-09 8:16

stancrm

31-Aug-09 8:16

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/e8df5c7b-3188-46dd-8d5f-b553dbda8a62[^]

Last Visit: 31-Dec-99 18:00 Last Update: 28-Jun-24 14:48

Refresh

ᐊ Prev 1...4444 4445 4446 444744484449 4450 4451 4452 4453 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.