|
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??
|
|
|
|
|
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.. 
Be an Eagle, Sky is Yours.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Hi I want source code c++ language modify to xml in c#. I want example. please help me thank.
|
|
|
|
|
I do not understand your question, please explain
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ?
|
|
|
|
|
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.”
|
|
|
|
|
"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";
DgvKeys.Rows[0].Cells["Region"].Value = "Bordeaux";
curApel = cRow["Appellation"].ToString();
curApelID = Tools.GetInt(cRow["ApelID"]);
noEvent = false;
return;
}
}
|
|
|
|
|
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 ???
|
|
|
|
|
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
|
|
|
|
|
|
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();
|
|
|
|
|
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();
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
My DLL is a message resource file - the source was .mc file format (event log message text).
|
|
|
|
|
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
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
|
|
|
|
|
Thanks - I'll give it a try!
|
|
|
|
|
Adding that version code to my .rc file then compiling and linking does put it into the DLL (I can see it with Notepad) but the DLL's Property page still has no Version tab. Looks like it may not be recognized as version info.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
