Click here to Skip to main content
15,894,896 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: call client side function in server side function in asp.net Pin
Christian Graus7-Sep-09 22:04
protectorChristian Graus7-Sep-09 22:04 
AnswerRe: call client side function in server side function in asp.net Pin
Arun Jacob7-Sep-09 22:04
Arun Jacob7-Sep-09 22:04 
GeneralRe: call client side function in server side function in asp.net Pin
vnsraj7-Sep-09 22:18
vnsraj7-Sep-09 22:18 
AnswerRe: call client side function in server side function in asp.net Pin
Arun Jacob7-Sep-09 22:22
Arun Jacob7-Sep-09 22:22 
QuestionProbelm in open new Website Pin
Abbas_here7-Sep-09 21:49
Abbas_here7-Sep-09 21:49 
AnswerRe: Probelm in open new Website Pin
Christian Graus7-Sep-09 22:03
protectorChristian Graus7-Sep-09 22:03 
GeneralRe: Probelm in open new Website Pin
Abbas_here7-Sep-09 22:12
Abbas_here7-Sep-09 22:12 
Questiondata transfer from excel to excel Pin
amittinku7-Sep-09 21:47
amittinku7-Sep-09 21:47 
public partial class _Default : System.Web.UI.Page
{
OleDbConnection oo;
OleDbDataAdapter adp;
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
oo = new OleDbConnection(ConfigurationManager.ConnectionStrings["xls"].ConnectionString);
adp = new OleDbDataAdapter("select EID from [Sheet1$]", oo);

if (!IsPostBack)
{

ds = new DataSet();
ViewState["ds"] = ds;
adp.Fill(ds, "sheet1");
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
ds = (DataSet)ViewState["ds"];
GridView1.DataSource = ds;

}
}


protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int pos = e.RowIndex;

string name = ((TextBox)GridView1.Rows[pos].Cells[1].Controls[0]).Text;

ds.Tables[0].Rows[pos][0] = name;
ds.AcceptChanges();

GridView1.EditIndex = -1;

GridView1.DataBind();

}
protected void Button1_Click(object sender, EventArgs e)
{
adp = new OleDbDataAdapter("select EID from [Sheet1$]", oo);
OleDbCommandBuilder xx = new OleDbCommandBuilder(adp);
adp.Update(ds, "sheet1");

}
----------------------------------------------
In the above code,
In page_load: Reading from excel. It works fine. Gridview is bind with that. Works fine.
update the date in gridview(working in disconnected mode). Row_updating works fine.

Now want to transfer the data from disconnected excel to same excel in connected mode (written under button1_click).
Data is not getting pdated in connected excel.
Why?
AnswerRe: data transfer from excel to excel Pin
Christian Graus7-Sep-09 22:02
protectorChristian Graus7-Sep-09 22:02 
GeneralRe: data transfer from excel to excel Pin
amittinku7-Sep-09 22:12
amittinku7-Sep-09 22:12 
QuestionProcess termination Pin
Amit Patel19857-Sep-09 21:43
Amit Patel19857-Sep-09 21:43 
AnswerRe: Process termination Pin
Christian Graus7-Sep-09 21:45
protectorChristian Graus7-Sep-09 21:45 
AnswerRe: Process termination Pin
vishwjeet8-Sep-09 11:13
vishwjeet8-Sep-09 11:13 
QuestionHow To add pop Calender in content page using master page Pin
Samarjeet Singh@india7-Sep-09 21:13
Samarjeet Singh@india7-Sep-09 21:13 
AnswerRe: How To add pop Calender in content page using master page Pin
Christian Graus7-Sep-09 21:14
protectorChristian Graus7-Sep-09 21:14 
AnswerRe: How To add pop Calender in content page using master page Pin
Blikkies7-Sep-09 21:25
professionalBlikkies7-Sep-09 21:25 
GeneralRe: How To add pop Calender in content page using master page Pin
Samarjeet Singh@india7-Sep-09 21:36
Samarjeet Singh@india7-Sep-09 21:36 
GeneralRe: How To add pop Calender in content page using master page Pin
Christian Graus7-Sep-09 21:37
protectorChristian Graus7-Sep-09 21:37 
GeneralRe: How To add pop Calender in content page using master page Pin
Samarjeet Singh@india7-Sep-09 21:42
Samarjeet Singh@india7-Sep-09 21:42 
GeneralRe: How To add pop Calender in content page using master page Pin
Christian Graus7-Sep-09 21:49
protectorChristian Graus7-Sep-09 21:49 
GeneralRe: How To add pop Calender in content page using master page Pin
Samarjeet Singh@india7-Sep-09 21:53
Samarjeet Singh@india7-Sep-09 21:53 
QuestionAJAX - How to Handling Response in Multiple Requests Pin
j_u_sankar7-Sep-09 21:00
j_u_sankar7-Sep-09 21:00 
AnswerRe: AJAX - How to Handling Response in Multiple Requests Pin
Christian Graus7-Sep-09 21:17
protectorChristian Graus7-Sep-09 21:17 
GeneralRe: AJAX - How to Handling Response in Multiple Requests Pin
j_u_sankar8-Sep-09 0:50
j_u_sankar8-Sep-09 0:50 
Questionhow to show diff kind of files in the same place with adrotation? Pin
Member 38798817-Sep-09 20:57
Member 38798817-Sep-09 20:57 

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.