Comments by Member 8194711

Member 8194711 9-Mar-13 8:54am View

My problem is how can i know the current active tab inside user control
because when i click save in first user control i want enable the other users control

Member 8194711 11-Feb-13 13:51pm View

i dont have much experience with dealing with scripts thats why i put the question here can you please tell me what is wrong in my script

Member 8194711 10-Jan-13 5:56am View

Sir i dont know actually so there is any way to avoid the space

Member 8194711 10-Jan-13 5:55am View

System.Data.DataTable db = GetExcelData(path, oSheet.Name);

protected System.Data.DataTable GetExcelData(string ExcelFilePath, string sheetName)
{

string OledbConnectionString = string.Empty;
OleDbConnection objConn = null;
OledbConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFilePath + ";Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(OledbConnectionString);

if (objConn.State == ConnectionState.Closed)
{
objConn.Open();
}

OleDbCommand objCmdSelect = new OleDbCommand("Select * from [" + sheetName + "$]", objConn);
OleDbDataAdapter objAdapter = new OleDbDataAdapter();
objAdapter.SelectCommand = objCmdSelect;
DataSet objDataset = new DataSet();
objAdapter.Fill(objDataset, "ExcelDataTable");
objConn.Close();
return objDataset.Tables[0];
}

DataView dv = myDs.Tables[0].DefaultView;
foreach (DataColumn item in db.Columns)
{
string sss = db.Rows[0][item.ToString()].ToString();
columnNames.Add(item.ColumnName);
if (item.ColumnName.Trim() == "Year")
{

dv.RowFilter = "Year=1425";
gv.DataSource = dv;
gv.DataBind();
}
}

Member 8194711 10-Jan-13 5:50am View

System.Data.DataTable db = GetExcelData(path, oSheet.Name);

protected System.Data.DataTable GetExcelData(string ExcelFilePath, string sheetName)
{

string OledbConnectionString = string.Empty;
OleDbConnection objConn = null;
OledbConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFilePath + ";Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(OledbConnectionString);

if (objConn.State == ConnectionState.Closed)
{
objConn.Open();
}

OleDbCommand objCmdSelect = new OleDbCommand("Select * from [" + sheetName + "$]", objConn);
OleDbDataAdapter objAdapter = new OleDbDataAdapter();
objAdapter.SelectCommand = objCmdSelect;
DataSet objDataset = new DataSet();
objAdapter.Fill(objDataset, "ExcelDataTable");
objConn.Close();
return objDataset.Tables[0];
}

DataView dv = myDs.Tables[0].DefaultView;
foreach (DataColumn item in db.Columns)
{
string sss = db.Rows[0][item.ToString()].ToString();
columnNames.Add(item.ColumnName);
if (item.ColumnName.Trim() == "Year")
{

dv.RowFilter = "Year=1425";
gv.DataSource = dv;
gv.DataBind();
}
}

Member 8194711 10-Jan-13 5:42am View

yah i have column it called year but it has some space when i convert dataset to xml the year column its show like this <year_x0020_><year_x0020_>

Member 8194711 10-Jan-13 5:40am View

i have column called year when i convert my dataset to xml my year column its show like this <year_x0020_> <year_x0020_>

Member 8194711 10-Jan-13 5:33am View

I can't Find the Year column its show me Error how can i find column its has space how can i avoid that space

Member 8194711 9-Jan-13 2:26am View

protected System.Data.DataTable GetExcelData(string ExcelFilePath, string sheetName)
{

string OledbConnectionString = string.Empty;
OleDbConnection objConn = null;
OledbConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFilePath + ";Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(OledbConnectionString);

if (objConn.State == ConnectionState.Closed)
{
objConn.Open();
}

OleDbCommand objCmdSelect = new OleDbCommand("Select * from [" + sheetName + "$]", objConn);
OleDbDataAdapter objAdapter = new OleDbDataAdapter();
objAdapter.SelectCommand = objCmdSelect;
DataSet objDataset = new DataSet();
objAdapter.Fill(objDataset, "ExcelDataTable");
objConn.Close();
return objDataset.Tables[0];
}

Member 8194711 9-Jan-13 0:54am View

the main problem i cannot find the column because is has some extra signals i dont know how its came and how can i find the column with this extra signal
<year><year> <year_x0020_><year_x0020_>

Member 8194711 9-Jan-13 0:39am View

i tried all the examples not working fine.
when i want to discover what is the error i found <year><year> tag its come like this <year_x0020_><year_x0020_> so how can i found the Year column in this <year_x0020_><year_x0020_>

Member 8194711 26-Dec-12 8:23am View

thank you very much...

Member 8194711 17-Dec-12 6:10am View

then after saving excel file to database there is any way for represent excel columns data in dropdown list dynamically for filtering data...
because this application user upload excel file and after some times user wants to filter this excel file also because excel files columns not the same columns name Ex:first excel file columns will be nationality and country and second will be employee name , employee ID unexpected excel file... if there is no way please tell me what should i do thank u very much

Member 8194711 17-Dec-12 6:09am View

Deleted

then after saving excel file to database there is any way for represent excel columns data in dropdown list dynamically for filtering data...
because this application user upload excel file and after some times user wants to filter this excel file also because excel files columns not the same columns name Ex:first excel file columns will be nationality and country and second will be employee name , employee ID unexpected excel file... if there is no way please tell me what should i do thank u very much

Comments by Member 8194711 (Top 14 by date)