Comments by benzimen (Top 31 by date)

<asp:TextBox ID="txt1" TextMode="MultiLine" runat="server">

thanks for u r reply..i have one doubt what it is in javascript we get any control value with the help of document.getelementbtid("txt1").value;
but you are not mentioned...

sake of performance issue...

Exactly ...not only textboxes and label including Gridview also

in which event i have write this foreach
loop?

where can i call this foreach loop?
i mean in all textbox _ontextchanged events?

its is webform and using asp textbox control

if (fup1.HasFile)
{
filename = Path.GetFileName(fup1.PostedFile.FileName);
string extension = Path.GetExtension(fup1.PostedFile.FileName);
string folderpath=ConfigurationManager.AppSettings["folderpath"];
string filepath=Server.MapPath(folderpath+filename);
fup1.SaveAs(filepath);
if(extension==".xls")
con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"");
else if(extension==".xlsx")

con=new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';");
con.Open();
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter da = new OleDbDataAdapter();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from [Sheet1$]";
da = new OleDbDataAdapter(cmd);
con.Close();
ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Session["dataset"] = ds;
btndup.Visible = true;
}
}

}
protected void btndup_Click(object sender, EventArgs e)
{
DataSet ds = (DataSet)Session["dataset"];
DataTable dt = ds.Tables[0];
dt = removeduplicates(dt, "Website URL");
//DataSet ds1 = new DataSet();
//ds1.Tables.Add(dt);
exporttoexcel(dt);


}
public DataTable removeduplicates(DataTable dtable, string colname)
{
Hashtable ht = new Hashtable();
ArrayList al = new ArrayList();
foreach (DataRow row in dtable.Rows)
{
if (ht.Contains(row[colname]))
al.Add(row);
else
ht.Add(row[colname], string.Empty);
}
foreach (DataRow row in al)
dtable.Rows.Remove(row);
return dtable;
}
public void exporttoexcel(DataTable dt)
{
Excel.Application excelapp=new Excel.Application();
Excel.Workbook excelwork = excelapp.Workbooks.Open(@"D:\Excel.xlsx");
foreach(DataTable dt1 in ds.Tables)
{
Excel.Worksheet wshee = new Excel.Worksheet();
wshee.Name=dt.TableName;
for (int i = 1; i < dt.Columns.Count + 1; i++)
{
wshee.Cells[1, i] = dt.Columns[i - 1].ColumnName;
}

for (int j = 0; j < dt.Rows.Count; j++)
{
for (int k = 0; k < dt.Columns.Count; k++)
{
wshee.Cells[j + 2, k + 1] = dt.Rows[j].ItemArray[k].ToString();
}
}
excelwork.Save();
excelwork.Close();
excelapp.Quit();

hi damith..i got an error..pls help me
where it it when i add worksheet to work book it raises error..pls help ..th snippet is
foreach(DataTable dt in ds.Tables)
{
Excel.Worksheet wshee= excelwork.Sheets.Add();//here getting error
wshee.Name=dt.TableName;
for (int i = 1; i < dt.Columns.Count + 1; i++)
{
wshee.Cells[1, i] = dt.Columns[i - 1].ColumnName;
}

hi damith..i got an error..pls help me
where it it when i add worksheet to work book it raises error..pls help ..th snippet is
foreach(DataTable dt in ds.Tables)
{
Excel.Worksheet wshee= excelwork.Sheets.Add();//here getting error
wshee.Name=dt.TableName;
for (int i = 1; i < dt.Columns.Count + 1; i++)
{
wshee.Cells[1, i] = dt.Columns[i - 1].ColumnName;
}

sinisa thankyou very much for u r response

Thanks praveen for u r valuble suggistion.i think this is right way after getting the excel file to remove duplicates...thankyou very much

Thnaks DamithSL..i will do in your way

DamithSl..i dont know how to start this...so pls give me tips how to do it...

Name Contacts
Mark 1234567891
Luois 9848598485
Mark 1234567891
i want to delete the Mark and Contact

Name Contacts
Mark 1234567891
Luois 9848598485
Mark 1234567891
i want to delete the Mark and Contact

praveen,that is not my requirement.even i enter one field also i get the Data from DB.this is my task.

no.even one field is matches also we get the data

Thanks for u reply.but it is not my requirement.when i press the Edit button in Gridview that values will be added to out side of Gridview. values should be append to Textboxes.

can u give me
brief explanation....

iam very beginner.so can u pls demonistrate how to write the function?pls

even in this process also we write so much code for every event handler.

Thank you for your reply.but in my Table i have only Date column,there is no column for Month.Here i will display the month names based upon the Date.how can i do it?
give me reply.