Checking a webpage doesn't redirect [modified] - C# Discussion Boards

problem reading an Excel file

21-Aug-09 20:49

Thats the 4th post and i given you a hint what to do.

that needs to be in Foreach loop.

MenuItem subItem = new MenuItem();
subItem.Text = parentItem["Catname"].ToString();
subItem.MenuItemClick += new MenuEventHandler(menu_MenuItemClick);
menu.Items.Add(subItem);

Edit: That is yust a sample. I saw you have 3 foreach. Each MenuItem needs to have click event. Don't worry if it is same method(Function).

VCsamir21-Aug-09 20:17

VCsamir

21-Aug-09 20:17

Hi,
I want to import excel data into the database and also update that excel data using asp.net in c#.
I tried import the excel files but sometime the data is ecel file is not read.
Just because there is no single quote at the begining of each record.
How to solve this issue??

Re: problem reading an Excel file

Suresh Suthar21-Aug-09 20:39

Suresh Suthar

21-Aug-09 20:39

Hi,
Can you explain that how you reading the data from excel file using odbc or using COM objects..
Please put you code sample here.
Hope I can help you.. Smile | :)

Be an Eagle, Sky is Yours.

Link in Dynamic menu

rummer21-Aug-09 19:18

rummer

21-Aug-09 19:18

I have create a dynamic menu but problem is that how we give for a page link in clildnodes.

my code is like that---------------------------------------------

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class top : System.Web.UI.Page

{

SqlConnection conn;

DataUtility dut = new DataUtility();

protected void Page_Load(object sender, EventArgs e)

{

PopulateMenu();

}

private void PopulateMenu()

{

DataSet ds = GetDataSetForMenu();

Menu menu = new Menu();

menu.MenuItemClick += new MenuEventHandler(menu_MenuItemClick);

foreach (DataRow parentItem in ds.Tables[0].Rows)

{

MenuItem categoryItem = new MenuItem((string)parentItem["Catname"]);

menu.Items.Add(categoryItem);

foreach (DataRow childItem in parentItem.GetChildRows("Children"))

{

MenuItem childrenItem = new MenuItem((string)childItem["Subcatname"]);

categoryItem.ChildItems.Add(childrenItem);

}

}

Panel1.Controls.Add(menu);

Panel1.DataBind();

}

void menu_MenuItemClick(object sender, MenuEventArgs e)

{

string selected = e.Item.Text;

Response.Write(selected);

}

private DataSet GetDataSetForMenu()

{

conn = dut.getConnection();

SqlDataAdapter adCat = new SqlDataAdapter("SELECT tbl_Category.* FROM tbl_Category,tbl_Usercat where tbl_usercat.uid=1 and tbl_Category.sno=tbl_Usercat.catid", conn);

SqlDataAdapter adProd = new SqlDataAdapter("SELECT tbl_SubCategory.* FROM tbl_SubCategory,tbl_UserSubcat where tbl_UserSubcat.UID=1 and tbl_SubCategory.sno=tbl_UserSubcat.SubCatid", conn);

DataSet ds = new DataSet();

adCat.Fill(ds, "tbl_Category");

adProd.Fill(ds, "tbl_SubCategory");

ds.Relations.Add("Children", ds.Tables["tbl_Category"].Columns["sno"], ds.Tables["tbl_SubCategory"].Columns["CatID"]);

return ds;

}

}

so plz help me soon.

thanks

vivek

Re: Link in Dynamic menu [modified]

Saksida Bojan21-Aug-09 19:47

How to source code c++ language modify to with XML in c# ?

21-Aug-09 19:47

How many times will you create this thread. This is already 3rd time within 24 hours on this forum. Also put your code in code block: <pre></pre>.

For each menu and sub menu add event click. you can assign to same event to same method, and then in event method handle your request

modified on Saturday, August 22, 2009 1:54 AM

bolly12521-Aug-09 17:55

bolly125

21-Aug-09 17:55

Hi I want source code c++ language modify to xml in c#. I want example. please help me thank.

Re: How to source code c++ language modify to with XML in c# ?

Saksida Bojan21-Aug-09 19:38

Checking a webpage doesn't redirect [modified]

21-Aug-09 19:38

I do not understand your question, please explain

craigchrist823921-Aug-09 15:22

craigchrist8239

21-Aug-09 15:22

I am making a program were you type in your Xbox LIVE gamertag and it retrieves the info about it. I have most of it set up, but one thing I would like is to check if it exists or not. If you go to "http://live.xbox.com/en-US/profile/profile.aspx?pp=0&GamerTag=???" and replace the ??? with the textBox1 input, then if it exists, it takes you to the info. But, if it doesn't exist, it will still load the page like it exists, but then it will redirect to "http://live.xbox.com/en-US/profile/invalid.aspx". Is there a way to detect this redirection?

Also, I would like to retrieve some text on a certain location of a web page, could someone show how that is done?

modified on Friday, August 21, 2009 11:42 PM

Re: Checking a webpage doesn't redirect

Saksida Bojan21-Aug-09 19:55

Get the underlying combo of a datagridviewcomboboxcolumn

21-Aug-09 19:55

without javascript, i don't think that was possible. You coud try holding session data and inside you woud have variable that holds the pages visited

baranils21-Aug-09 10:04

baranils

21-Aug-09 10:04

Hello

I'm trying to acceed the combobox property of a datagridview combobox column

I can do it using the EditingControlShowing event

// ***********************************************************************************
private void DgvKeys_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
  if (noEvent)
  {
    return;
  }

  ComboBox combo = e.Control as ComboBox;
}

But I need to acceed directly any combo in some column without having to waint an event on it !
To set the combo selected intex for example

I was trying this but it does not work !

DataGridViewComboBoxColumn cby;
cby = (DataGridViewComboBoxColumn)DgvKeys.Columns["Region"];
cby.SelectedIndex = cby.FindStringExact(combo.Text);

Any idea ?

Re: Get the underlying combo of a datagridviewcomboboxcolumn

Henry Minute21-Aug-09 10:18

Henry Minute

21-Aug-09 10:18

baranils wrote:
I was trying this but it does not work !

Can you describe in more detail the circumstances when you would want to do this?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Get the underlying combo of a datagridviewcomboboxcolumn

baranils21-Aug-09 10:41

baranils

21-Aug-09 10:41

Thank you Henry

"Can you describe in more detail the circumstances when you would want to do this?"

Good question !

I have three combobox column on single row (one and only one)

Those three combo are binded to three different tables
There is a logical relation berween those tables

If the user select a value in the third combo I want to show the related value in the first and second cell

So I'm trying to force the values of two cell but it doesn't work
I'm trying this

If I change the appellation Column

Pays must shows "France"
And Region must Show "Bordeaux"

But Pays remain empty !!
I thought it was because I also have to change the selected item of the combo ??

// ***********************************************************************************
private void DgvKeys_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
  if (noEvent)
  {
    return;
  }

  ComboBox combo = e.Control as ComboBox;
  if (combo != null)
  {

    combo.DropDownStyle = ComboBoxStyle.DropDown;
    combo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
    combo.AutoCompleteSource = AutoCompleteSource.ListItems;

    combo.SelectedIndexChanged -= new EventHandler(ComboBox_SelectedIndexChanged);
    combo.SelectedIndexChanged += new EventHandler(ComboBox_SelectedIndexChanged);
  }
}

// ***********************************************************************************
private void ComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
  noEvent = true;
  ComboBox combo = (ComboBox)sender;

  if (combo.SelectedItem == null)
  {
    return;
  }

  DataRowView cRowV = (DataRowView)combo.SelectedItem;
  DataRow cRow = cRowV.Row;


  if (combo.DisplayMember == "Appellation")
  {
    DgvKeys.Rows[0].Cells["Pays"].Value = "France"; // = GetPaysName(cRow["PaysID"]);
    DgvKeys.Rows[0].Cells["Region"].Value = "Bordeaux"; // GetRegionName(cRow["RegionID"]);
    curApel = cRow["Appellation"].ToString();
    curApelID = Tools.GetInt(cRow["ApelID"]);
    noEvent = false;
    return;
  }
}

Re: Get the underlying combo of a datagridviewcomboboxcolumn

baranils21-Aug-09 11:21

baranils

21-Aug-09 11:21

Hello !

I've just finded out that a part of the problem seems to come because I've defined a Value Member to my ComboboxColumn

If I remove the assignation of the valuemember I can force the value of the cell without problem ???

run a function before exiting a web application

JohnQuar121-Aug-09 8:58

JohnQuar1

21-Aug-09 8:58

Hello,

I am wondering if there is some functionality with the upper right exit button when it is pushed. I need to do a check to make sure that a button was pushed (save button) before they close the browser. I wasn't sure if there was some code I could run in the code behind to do this or not. Thanks!

John Michael

Re: run a function before exiting a web application

xstoneheartx21-Aug-09 9:26

xstoneheartx

21-Aug-09 9:26

Take a look at this link: Dirty Panel Extender (ASP.NET AJAX)[^]
It seems to be useful for you.

can not copy database files

msrezapro21-Aug-09 8:16

msrezapro

21-Aug-09 8:16

hi.i want copy database files.when i do detach database throw exeption.i search web and find things.but i cant drive result.
please help me.thanks.

string ConnStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mydb.mdf"
+";Integrated Security=True;User Instance=True";
SqlConnection mycon = new SqlConnection(ConnStr);
SqlCommand mycom = new SqlCommand("sp_detach_db @d=db_name()", mycon);
mycon.Open();
mycom.ExecuteScalar();
mycon.Close();

Re: can not copy database files

xstoneheartx21-Aug-09 9:38

xstoneheartx

21-Aug-09 9:38

Try these:

string ConnStr = @"Data Source=.\SQLEXPRESS;Database=Master;Integrated Security=True";
SqlConnection mycon = new SqlConnection(ConnStr);
SqlCommand mycom = new SqlCommand("sp_detach_db", mycon);
mycom.CommandType= CommandType .StoredProcedure ;
mycom.Parameters.Add(new SqlParameter("@dbname", SqlDbType.NVarChar,50));
mycom.Parameters["@dbname"].Value = "mydb";
mycon.Open();
mycom.ExecuteScalar();
mycon.Close();

Re: can not copy database files

Dave Kreskowiak21-Aug-09 9:54

Dave Kreskowiak

21-Aug-09 9:54

What was not pointed out is that you cannot detach a database the your using. You have to execute the detach sp connected to the master db in SQL Server.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Message Resource file version info

cturn21-Aug-09 6:03

21-Aug-09 6:03

How can you add the usual AssemblyInfo data (version etc) to a Message Resource file?

I have a Message resource DLL - created via the method described in article "Using MC.exe, message resources and the NT event log in your own projects" (by Daniel Lohmann) How do I get version info into that DLL?

Saksida Bojan21-Aug-09 6:26

21-Aug-09 6:26

Assembly myAssembly = Assembly.GetExecutingAssembly();
AssemblyName myAssemblyName = myAssembly.GetName();
MessageBox.Show(myAssemblyName.Version.ToString());

This code sample is for current rrunning app. Just load external Assembly

cturn21-Aug-09 6:34

21-Aug-09 6:34

I appreciate the response, however what I am looking for is how to get the version info *into* the DLL. The method I used to create the DLL did not embed any version info.
Method:
mc -u customdefs.mc
rc -r -fo customdefs.res customdefs.rc
link -dll -noentry -out:customdefs.mc.dll customdefs.res /MACHINE:X86

Is it possible to somehow compile an AssemblyInfo.cs file and link it into the DLL?

Saksida Bojan21-Aug-09 7:13

21-Aug-09 7:13

Sorry i missread it. I did check the article and i noticed it is in C++? Is your dll in C++? If so, you can't include or Link any C# files into native dll.

cturn21-Aug-09 8:39

21-Aug-09 8:39

My DLL is a message resource file - the source was .mc file format (event log message text).

Saksida Bojan21-Aug-09 9:59

21-Aug-09 9:59

cturn wrote:
My DLL is a message resource file - the source was .mc file format (event log message text).

are you saying this Message Resource file is stand alone?

Edit: http://social.msdn.microsoft.com/Forums/en-US/windowssdk/thread/bca3b73f-5f17-407d-99fa-565aa6ba2442[^]
Here i saw comment about how to do it

This sample shows version info block

/////////////////////////////////////////////////////////////////////////////
//
// Version
//

VS_VERSION_INFO VERSIONINFO
 FILEVERSION 1,0,0,1
 PRODUCTVERSION 1,0,0,1
 FILEFLAGSMASK 0x17L
#ifdef _DEBUG
 FILEFLAGS 0x3L
#else
 FILEFLAGS 0x2L
#endif
 FILEOS 0x4L
 FILETYPE 0x0L
 FILESUBTYPE 0x0L
BEGIN
    BLOCK "StringFileInfo"
    BEGIN
        BLOCK "042404b0"
        BEGIN
            VALUE "FileDescription", "SimpleNotDo"
            VALUE "FileVersion", "1, 0, 0, 1"
            VALUE "InternalName", "SimpleDo"
            VALUE "LegalCopyright", "Copyright (C) 2009"
            VALUE "OriginalFilename", "SimpleDo"
            VALUE "ProductName", "SimpleDo"
            VALUE "ProductVersion", "1, 0, 0, 1"
        END
    END
    BLOCK "VarFileInfo"
    BEGIN
        VALUE "Translation", 0x424, 1200
    END
END

cturn25-Aug-09 12:37