ModalPopupExtender confirmation not working in <asp:CommandFiel in grid view - ASP.NET Discussion Boards

Hi,

How to open excisiting excel document in asp.net??

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

You can read excel into a dataset and then can dispay it easily using grid view of whatever control you prefer.

int workSheetNumber = 0;

OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePathWithName + ";Extended Properties=Excel 8.0;");

                OleDbCommand ExcelCommand = new OleDbCommand();
                ExcelCommand.Connection = ExcelConnection;
                OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand);

                ExcelConnection.Open();
                System.Data.DataTable ExcelSheets = ExcelConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
                string SpreadSheetName = "[" + ExcelSheets.Rows[workSheetNumber]["TABLE_NAME"].ToString() + "]";

                DataSet ExcelDataSet = new DataSet();
                ExcelCommand.CommandText = @"SELECT * FROM " + SpreadSheetName;
                ExcelAdapter.Fill(ExcelDataSet);

Hello,

Please help i want to add update and delte data from the specified table.I m using Gridview and i want to to add data in grid when add button is clicked and also edit it on edit button. It same as we do in windows app (i.e., is add data in specify cells and click on save button to save the data in table.)Please help its urgent?

ClickHere[]

Its not so hard but i want add Data in Gridview Selected Cell and Save its contains in Table as we do using fp spread for some other 3 party components?

Hello,

I need help, i want to list a content from specific folder from FTP, a can make the connection to FTP, but i don't know how can list the files contended in a specific Folder from FTP in one ListBox.
Thank's for you time, i'm new ( beginner) in .NET

Thank's again !

This is my code in C#

public partial class _Default : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{
FtpWebRequest Request = (FtpWebRequest)WebRequest.Create("ftp://server.com");
Request.Method = WebRequestMethods.Ftp.ListDirectory;
Request.Credentials = new NetworkCredential("user", "pass");

FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();
Stream ResponseStream = Response.GetResponseStream();
StreamReader Reader = new StreamReader(ResponseStream);

//ListBox1.Items.Add(Response.BannerMessage);
//ListBox1.Items.Add(Response.WelcomeMessage);
while (!Reader.EndOfStream)//Read file name
{
ListBox1.Items.Add(Reader.ReadLine().ToString());
}
Response.Close();
ResponseStream.Close();
Reader.Close();
}
}

and i have one folder ftp;//server.com/FolderX/
i want to list the files from FolderX in one ListBox and in one label to show me the numbers of files from FolderX

Many thamks

hi actualy i want to create dynamic menu accroding to permission of user.
it should get generate dynamically.....
for that i used database...there are three tables related to menus
1. tblModule -which contains module code and module description i.e. masters,search,rate entry
2. tblMenu- which contains menucode,menu desc.(bus,car,flight,train),modulecode.
3. tblSubMenu-which contains submenucode,submenuname(add new bus,del bus,modify bus,search bus,add new rate entry
for bus ...etc),submenulinks(means path of aspx file i.e. Masters/bus/newBusEntery.aspx),menucode

now i want to dynamically create menus according to permissions like bus|car|flight...
after clicking on bus it should display the submenu in dropdown manner like this,
-add new bus
-modify bus
-delete bus
and after selecting add new bus it should display the 'newBusEntery.aspx' page which is in Masters/bus folder
whose path is stored in tblSubMenu table..

please, give code samples i need it urgently and i am new in asp.net,so help me friends....

thanx..

Hi to all forum members.

I am stuck in implementing ModalPopupExtender in <asp:CommandField in grid view.
Although below code is working fine in <asp:template field in grid view.
<asp:TemplateField HeaderText="Delete" HeaderStyle-CssClass="tableheading" HeaderStyle-Width="70px">
<ItemTemplate>
<center>
<asp:ImageButton ID="imgDelete" runat="server" OnClientClick="showConfirm(this); return false;"
ImageUrl="~/Images/delete.png" OnClick="imgBtnDelete_Click" /></center>
</ItemTemplate>
</asp:TemplateField>

following is my code which I am trying to implement in <asp:CommandFiel in grid view.
.aspx code

Grid view code
<asp:CommandField HeaderText="Edit/Delete" ItemStyle-HorizontalAlign="Center" CausesValidation="false"
ShowCancelButton="true" ShowEditButton="True" ShowDeleteButton="true" />
modal popup code
<ajaxToolkit:ModalPopupExtender ID="md1" runat="server" BackgroundCssClass="modalBackground"
BehaviorID="mdlPopup" CancelControlID="btnNo" OkControlID="btnOk" OnCancelScript="cancelClick();"
OnOkScript="okClick();" PopupControlID="Confiramtiondiv" TargetControlID="Confiramtiondiv">
</ajaxToolkit:ModalPopupExtender>
<div id="Confiramtiondiv" runat="server" align="center" style="display: none">
<table id="Table3" cellpadding="1" cellspacing="1" border="0" bordercolor="blue"
runat="server" align="center">
<tr>
<td colspan="4" align="center">
<asp:Label ID="lblConfirmmsg" runat="server" Text="Are you sure you want to delete this Trip ?"
CssClass="lblConfirmmsg"></asp:Label>
</td>
</tr>
<tr>
<td width="20%">
</td>
<td width="30%">
<asp:Button ID="btnOk" runat="server" Text="Yes" CausesValidation="false" Width="50px" />
</td>
<td width="30%">
<asp:Button ID="btnNo" runat="server" CausesValidation="false" Text="No" Width="50px" />
</td>
<td width="20%">
</td>
</tr>
</table>
</div>

.cs code
protected void grdTrips_RowDataBound(object sender, GridViewRowEventArgs e)
{

if (e.Row.RowState != DataControlRowState.Edit) // check for RowState
{
if (e.Row.RowType == DataControlRowType.DataRow) //check for RowType
{
string id = e.Row.Cells[0].Text; // Get the id to be deleted
LinkButton lb = (LinkButton)e.Row.Cells[8].Controls[2]; //cast the ShowDeleteButton link to linkbutton
if (lb != null && lb.Text == "Delete")
{

lb.Attributes.Add("onclick", "showConfirm(this); return false;"); //implementing Ajax modal popup extender

}
}
}

Java Script Function

// keeps track of the delete button for the row
// that is going to be removed
var _source;
// keep track of the popup Confiramtiondiv
var _popup;

function showConfirm(source){
this._source = source;
this._popup = $find('mdlPopup');

// find the confirm ModalPopup and show it
this._popup.show();
}

function okClick(){
// find the confirm ModalPopup and hide it
this._popup.hide();
// use the cached button as the postback source
__doPostBack(this._source.name, '');
}

function cancelClick(){
// find the confirm ModalPopup and hide it
this._popup.hide();
// clear the event source
this._source = null;
this._popup = null;
}
This code opens modal popup but its does not goes to RowDeleting Event of gridview
.
When I changed this code
lb.Attributes.Add("onclick", "showConfirm(this); return false;");
to
lb.Attributes.Add("onclick", "showConfirm(this);");
it open the modal popup but then directly goes to to grid view RowDeleting Event of gridview with out asking confirmation from the users.
I again told this code is working fine in <asp:templatefield.

Welcome for your valuable suggestions

Vishnu Narayan Mishra
Software Engineer

hi,

i have useing asp.net 2.0 and ajax extension.
i have pass 3 value to popup window...if update some values in child(popup) window. its automatically refresh particular (update panel or) gridview in parent page.

i have code for refresh parent window. but i dont have code for refresh particular window.

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

are you using that popup from same page or open popup from another page?

(New) another page

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Dear all,

I was doing a calculation on the total of costs using datagrid. There are only two row in my data. I use the following to insert the summary to the footer but is not success which is as below:

For RawCount = 0 To ItemCount - 1

Quantity(RawCount) = Me.dtGrid.Items(RawCount).Cells(2).Text
Price(RawCount) = Me.dtGrid.Items(RawCount).Cells(5).Text
Costs(RawCount) = Quantity(RawCount) * Price(RawCount)

Me.dtGrid.Items(RawCount).Cells(6).Text = Costs(RawCount)

TotalQuantity = Quantity(RawCount) + TotalQuantity
TotalCost = TotalCost + Costs(RawCount)

If Me.dtGrid.Items(RawCount).ItemType = ListItemType.Footer Then

Me.dtGrid.Items(RawCount).Cells(2).Text = TotalQuantity

End If

Could anyone please help me check what is the problem and why the data is not display in my footer raw?

Thank you so much for the help!

Please refer from Here[^]

Hi all,

Use the google graph API if you need any graph requirement in your application, its really good

See the example:

<html>
<head>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["piechart"]});
google.setOnLoadCallback(drawPieChart);
// google.load("visualization", "1", {packages:["barchart"]});
// google.setOnLoadCallback(drawBarChart);

function drawBarChart() {
// Create and populate the data table.
var data = new google.visualization.DataTable();
data.addColumn('string', 'Year');
data.addColumn('number', 'Sales');
data.addColumn('number', 'Expenses');
data.addColumn('number', 'Expenses1');
data.addColumn('number', 'Expenses2');
data.addColumn('number', 'Expenses3');
data.addColumn('number', 'Expenses4');
data.addColumn('number', 'Expenses5');
data.addColumn('number', 'Expenses6');
data.addColumn('number', 'Expenses7');
data.addColumn('number', 'Expenses8');
data.addColumn('number', 'Expenses9');

data.addRows(1);

data.setValue(0, 0, '');
data.setValue(0, 1, 1000);
data.setValue(0, 2, 400);
data.setValue(0, 3, 700);
data.setValue(0, 4, 40);
data.setValue(0, 5, 90);
data.setValue(0, 6, 480);
data.setValue(0, 7, 120);
data.setValue(0, 8, 100);
data.setValue(0, 9, 400);
data.setValue(0, 10, 200);
data.setValue(0, 11, 100);

new google.visualization.BarChart(document.getElementById('chart_div')).
draw(data, {width: 600, height: 440, is3D: true});
}

function drawPieChart() {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Expense Item');
data.addColumn('number', 'Expense');

data.addRows(8);

data.setValue(0, 0, 'Food');
data.setValue(0, 1, 11);
data.setValue(1, 0, 'Drinks');
data.setValue(1, 1, 2);
data.setValue(2, 0, 'Cinima');
data.setValue(2, 1, 2);
data.setValue(3, 0, 'party');
data.setValue(3, 1, 2);
data.setValue(4, 0, 'smoke');
data.setValue(4, 1, 7);
data.setValue(5, 0, 'smoke2');
data.setValue(5, 1, 7);
data.setValue(6, 0, 'smoke3');
data.setValue(6, 1, 7);

new google.visualization.PieChart(document.getElementById('chart_div')).
draw(data,{width: 600, height: 440, is3D: true});
}

</script>
</head>

<body>
<div id="chart_div"></div>
</body>
</html>

dhdh

Hey its nice. thank you. But can you give any URL for this.

Naina

No url available, actually it generate the graph from google server, just we need to create the java script dynamically depend on our data in database. then i will work.
Please refer this url for more info:
http://code.google.com/apis/ajax/playground/?type=visualization#bar_chart[^]

dhdh

This is Great!!

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Hi,

I want "Enter" Key press count fro .doc file. I am using ASCII value of "Enter" Key . But How can I find using stramreader while reading file.

Or any other Solution for that?

Thanks,
sjs

Well, it doesn't seems to be related to Asp.net.
I think C# forum will be more suitable for this question.

Anyways, streamReader may not work for this.
Read your word file text using Microsoft Word Object library,
and get the text in the string. After that you can easily find
"\r\n" characters in your text.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Hi,

on pressing enter button to submit the login details it is working in IE but it is not working in Firefox could anyone help iam using the javascript function

function doClick(buttonName,e)
{
//the purpose of this function is to allow the enter key to
//point to the correct button to click.
var key ;

if(window.event)
key = window.event.keyCode; //IE
else
key = e.which; //firefox

if (key == 13)
{
//Get the button the user wants to have clicked
var btn = document.getElementById(buttonName);
if (btn != null)
{ //If we find the button click it
btn.click();
event.keyCode = 0
}
}
}

Thanks & Regards,
Nath

I am newbie to webservices
I am trying to learn about them, but got struck in the first place itself. Please help me out.

My service.cs in the web service.
--------------------------------

using System;<br />
using System.Web;<br />
using System.Web.Services;<br />
using System.Web.Services.Protocols;<br />
<br />
[WebService(Namespace = "http://localhost:1458/forumservices/")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
public class Service : System.Web.Services.WebService<br />
{<br />
    public Service () {<br />
<br />
        //Uncomment the following line if using designed components <br />
        //InitializeComponent(); <br />
    }<br />
<br />
    <br />
    [WebMethod]<br />
    public string welcome(string name)<br />
    {<br />
        return "Welcome " + name;<br />
    }<br />
    <br />
}

now on a button click from another web page

protected void Button1_Click(object sender, EventArgs e)<br />
    {<br />
        <br />
        try<br />
        {<br />
            soapMessage =<br />
            @"<br />
<?xml version=""1.0"" encoding=""utf-8""?><br />
<soap12:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:soap12=""http://www.w3.org/2003/05/soap-envelope""><br />
  <soap12:Body><br />
    <welcome xmlns=""http://localhost:1458/forumservices/""><br />
      <name>Rajas</name><br />
    </welcome><br />
  </soap12:Body><br />
</soap12:Envelope>";<br />
<br />
            WebClient mClient = new WebClient();<br />
            <br />
            <br />
<br />
            Response.Write(System.Text.Encoding.ASCII.GetString(mClient.UploadData("http://localhost:1458/forumservices/Service.asmx", "POST", System.Text.Encoding.ASCII.GetBytes(soapMessage))));<br />
        }<br />
        catch (System.Net.WebException ex)<br />
        {<br />
            if (ex.Response != null)<br />
            {<br />
                Stream strm = ex.Response.GetResponseStream();<br />
                StreamReader sr = new StreamReader(strm);<br />
                Response.Write(sr.ReadToEnd());<br />
            }<br />
            else<br />
            {<br />
                Response.Write(ex.InnerException.ToString());<br />
            }<br />
        }<br />
<br />
    }

The compilation is fine, but i keep getting some errors as below
"The remote server returned an error: (500) Internal Server Error."

Please help me out

Jack Sparrow
--------------------------------------
Defeat is not the worst of failures. Not to have tried is the true failure.

According to me to consume webservice in you application you need to add webreferace of webservice in you application

than to call web service you need to create objct of that and than you can call webservice.

Check on following link which give you idea about how to consume website.
<a href="http://it.toolbox.com/wiki/index.php/Calling_a_web_service_from_Asp.net">http://it.toolbox.com/wiki/index.php/Calling_a_web_service_from_Asp.net</a>[<a href="http://it.toolbox.com/wiki/index.php/Calling_a_web_service_from_Asp.net" target="_blank" title="New Window">^</a>]

Your Coding looks odd to me ..!
I think you are not calling the web service method..!
try this link..!
http://www.codeproject.com/Messages/3359929/Re-web-service.aspx[^]

The Calling is Easy..!Its just like any method but little bit difference..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Sashi,

When I call it using web reference it is working fine.

But I have to manually call the web service using xml+soap. got any ideas

Jack Sparrow
--------------------------------------
Defeat is not the worst of failures. Not to have tried is the true failure.

No Brother..! D'Oh! | :doh:

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.