Click here to Skip to main content
15,884,176 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: Not able to Ajax post knockout (KO) data in XML format Pin
AumSingh23-May-12 23:52
professionalAumSingh23-May-12 23:52 
Questiontigrina lexikon ትግርኛ መዝገብ ቃላት seglelet.com Pin
mululer19-May-12 22:27
mululer19-May-12 22:27 
QuestionHow to display XML data using XSL in HTML? Pin
RedUnited18-May-12 1:35
RedUnited18-May-12 1:35 
AnswerRe: How to display XML data using XSL in HTML? Pin
berba19-May-12 6:44
berba19-May-12 6:44 
QuestionProblem with Knockout mapping of observable array. Pin
AumSingh18-May-12 0:04
professionalAumSingh18-May-12 0:04 
AnswerRe: Problem with Knockout mapping of observable array. Pin
AumSingh18-May-12 20:07
professionalAumSingh18-May-12 20:07 
Questionhow can i bind data from excel file? Pin
heinhtataung16-May-12 23:09
heinhtataung16-May-12 23:09 
AnswerRe: how can i bind data from excel file? Pin
frostcox19-May-12 21:36
frostcox19-May-12 21:36 
Hey they are 2 ways which you can achieve this. You can get the cell range and store it in an array and then read the values from the array like so :
this.openFileDialog1.FileName = "*.xls";
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open(
openFileDialog1.FileName, 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
0, true);
Excel.Sheets sheets = theWorkbook.Worksheets;
Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1);
for (int i = 1; i <= 10; i++)
{
Excel.Range range = worksheet.get_Range("A"+i.ToString(), "J" + i.ToString());
System.Array myvalues = (System.Array)range.Cells.Value;
string[] strArray = ConvertToStringArray(myvalues);
TextBox.Text = strArray[0].ToString();
}
}
or you could use OleDb like so assuming you have a sheet in the excel file called MyObject :
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties=Excel 8.0");
OleDbDataAdapter da = new OleDbDataAdapter("select * from MyObject", con);
DataTable dt = new DataTable();
da.Fill(dt);

Hope this helps
AnswerRe: how can i bind data from excel file? Pin
frostcox25-May-12 11:08
frostcox25-May-12 11:08 
QuestionUse of Session states in SharePoint 2010 Pin
Athar Raza Faridi16-May-12 20:37
Athar Raza Faridi16-May-12 20:37 
QuestionMessage box with 3 buttons Yes/NO/Cancel in ASP.Net Pin
berba16-May-12 3:15
berba16-May-12 3:15 
AnswerRe: Message box with 3 buttons Yes/NO/Cancel in ASP.Net Pin
Sandeep Mewara16-May-12 7:38
mveSandeep Mewara16-May-12 7:38 
QuestionEmails Sent by Window Service/C# Code are landing in spam in Gmail Pin
masterprogrammertech14-May-12 1:19
masterprogrammertech14-May-12 1:19 
AnswerRe: Emails Sent by Window Service/C# Code are landing in spam in Gmail Pin
Bernhard Hiller14-May-12 21:36
Bernhard Hiller14-May-12 21:36 
QuestionSubpages are not found. Pin
m_kukulka10-May-12 3:03
m_kukulka10-May-12 3:03 
AnswerRe: Subpages are not found. Pin
Bernhard Hiller10-May-12 4:25
Bernhard Hiller10-May-12 4:25 
QuestionWeb Crawling / Searching Pin
eddieangel9-May-12 6:08
eddieangel9-May-12 6:08 
AnswerRe: Web Crawling / Searching Pin
Bernhard Hiller9-May-12 21:20
Bernhard Hiller9-May-12 21:20 
QuestionFormat Date According to Regional Settings Pin
berba9-May-12 3:22
berba9-May-12 3:22 
AnswerRe: Format Date According to Regional Settings Pin
Richard MacCutchan9-May-12 4:31
mveRichard MacCutchan9-May-12 4:31 
AnswerRe: Format Date According to Regional Settings Pin
David Mujica9-May-12 4:35
David Mujica9-May-12 4:35 
GeneralHow to write code for Admin approve ! Pin
heinhtataung8-May-12 18:26
heinhtataung8-May-12 18:26 
GeneralRe: How to write code for Admin approve ! Pin
David Mujica9-May-12 4:30
David Mujica9-May-12 4:30 
GeneralRe: How to write code for Admin approve ! Pin
heinhtataung10-May-12 21:00
heinhtataung10-May-12 21:00 
QuestionGenetic algorithm for class schedule with PHP Pin
Luki Dwiyanto7-May-12 19:14
Luki Dwiyanto7-May-12 19:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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