Excel like Grid in ASP.NET 2.0 ... - ASP.NET Discussion Boards

Navi1521-Aug-06 21:34

21-Aug-06 21:34

1.create a function which takes values to be inserted as arguments in databse to insert rows, and call that function.

*2. create a function which takes a string as argument and decodes that string into individual set of values to be inserted into the table.

(ex)if the table has 2 columns
'column1 value',column2 value'|'column1 value',column2 value'|'column1 value',column2 value'|'column1 value',column2 value'.......

in the sp get the substring seperated by | and insert into the table in a loop.

this method is recomented as it will reduce the number of calls to the databse(we only call the SP once)

Navi

Re: question on for loop

Ramasubramaniam22-Aug-06 5:36

Ramasubramaniam

22-Aug-06 5:36

Hi,

1) Construct an XML file from the front end (ASP.NET).
2) Pass the XML file as a parameter to an Stored Procedure.
3) Write an SP to read the Values from the XML and insert into table.

Sample Insert query to read from xml in SP
Insert into table1(field1,field2,field3,....,field75)
Select * from OpenXml(@intPointer,'/XML1/XML2',2)
With (field1 char(6),field2 char(3),field3 char(15),......,field75 char (8) )

Advantages:
==========
1) No need to create 75 parameters.
2) SP creation is very simple and easy to maintain.

Ram

Error ---> Unable to send to all recipients.

DotnetRafi21-Aug-06 20:45

DotnetRafi

21-Aug-06 20:45

i have write the following code for send the mail

but i get the Error

Unable to send to all recipients.
what is the solution for the peried

try
{
MailAddress fromAddress = new MailAddress("mrafi@mydomain.com");
smtpClient.Host = "localhost";
smtpClient.Port = 25;
message.From = fromAddress;
message.To.Add("ggajjar@mydomain.com");
message.Subject = "Feedback";
message.CC.Add("amajumdar@mydomain.com");
message.IsBodyHtml = false;
message.Body = "Test Mail";
smtpClient.Send(message);
}
catch (Exception ex)
{
Response.Write("Send Email Failed." + ex.Message);
}

mohamad rafi

Re: Error ---> Unable to send to all recipients.

Suresh Pirsquare22-Aug-06 0:06

Suresh Pirsquare

22-Aug-06 0:06

Here is a simple way of Sending eMails

Imports System.Web.Mail

Try
Dim objEmail As New MailMessage
objEmail.To = txtto.Text
objEmail.Bcc = txtcc.Text
objEmail.From = txtfrom.Text
objEmail.Subject = txtsubject.Text 'your subject
objEmail.Body = txtbody.Text 'your message
objEmail.BodyFormat = MailFormat.Text
SmtpMail.SmtpServer = "144.163.1.33" 'Smtp Server domain name
SmtpMail.Send(objEmail)
lblexception.Text = "Message Sent Successfully"
Catch ex As Exception
lblexception.Text = ex.Message
End Try

Thanks & Regards,
Suresh Dayma

Communication between two machine with aspx page

prabhakar dwivedi21-Aug-06 20:23

prabhakar dwivedi

21-Aug-06 20:23

i am having lan connection there are two-ten machine avalable i want to access my application on different machine for this purpose how can i configure IIS,Please give me detail information about that as soon as

thanks

prabhakar dwivedi

Re: Communication between two machine with aspx page

coolestCoder21-Aug-06 20:30

coolestCoder

21-Aug-06 20:30

Hi,
If you mean to publish your application then make a computer in ur LAN, the server. Publish your application there and then you can access this application accross ur LAN by using an IP address of that machine or the name of the machine like this ---

http://192.168.1.1/WebAppName/
http://ServerName/WebAppName/

Hope i got your point !

<marquee>"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

Anant Y. Kulkarni

skmMenu--Anyother menu option in asp.net 1.1

Vsree21-Aug-06 20:11

Vsree

21-Aug-06 20:11

Hi,

Am using skmMenu to create Menu in my page.
But i couldnt succeed in displaying it in the screen.

Am not getting any error.
But the menu couldnt be seen in the form.
Do i have to change any property either in form or in menu control?
The code i used for binidng is:

[Code]
private void Page_Load(object sender, System.EventArgs e)
{
Menu1.DataSource = Server.MapPath("menu.xml");
Menu1.DataBind();
}
[Code]

and in design,
<skmmenu:menu id="Menu1" runat="server" tooltip="Menus" borderstyle="Dashed" width="88px" itemspacing="1"
="" itempadding="1" cellspacing="1" menufadedelay="1" font-names="Verdana" font-size="10px" cursor="Pointer" height="40px" clicktoopen="True" highlighttopmenu="True" layout="Horizontal">
<unselectedmenuitemstyle font-size="10px" font-names="Verdana" backcolor="Red">
<selectedmenuitemstyle font-size="10px" font-names="Verdana" height="28px" forecolor="Blue" borderstyle="None"
="" width="75px" verticalalign="Middle" backcolor="#404040">

Can anyone please help me in resolving it or anyother solution for making a menu?

Excel like Grid in ASP.NET 2.0 ...

Haridas.R21-Aug-06 20:04

Haridas.R

21-Aug-06 20:04

Dear Friends,,

Please help me

How we can make Excel like Grid in ASP.NEt 2.0 ?

Please Help me..................

Haridas.R
harisofttech@gmail.com
harisofttech@hotmail.com (online)
harizeenet@yahoo.co.in(online)

"Achievement is not a destination, its a journey "

Re: Excel like Grid in ASP.NET 2.0 ...

Suelinda_W7-Sep-06 10:44

Suelinda_W

7-Sep-06 10:44

Hello Haridas,

ComponentOne has a grid, WebGrid, for ASP.NET 2.0. Our 2.0 WebGrid even has AJAX support. I you think you may be interested, you can download a fully functional evaluation, which has many samples to get you started. For more information, please visit http://www.componentone.com/ProductMain.aspx?ItemType=1&PanelIndex=6[^]. There is also an AJAX feature tour site to show you some of the things that you can do with WebGrid for ASP.NET 2.0 here http://www.componentone.com/C1WebDemo2/WebForms/C1WebGrid/Sorting.aspx[^].

Suelinda W
Customer Engagement, ComponentOne LLC

Word Doc from Database

NinaWilliam21-Aug-06 18:02

NinaWilliam

21-Aug-06 18:02

Word Doc from Database

Hi i am creating an application that help the user to upload his word documents to an sql server database
i want to bind a datagrid to the database so the user can see what he uploaded. also, when the user clicks on the document title it will load it in Microsoft Word so he can read it.

any idea how to bind the datagrid to the documents stored in the databse and how to load a document into Microsoft word?

Nina

Re: Word Doc from Database

Andrei_KS21-Aug-06 18:32

Andrei_KS

21-Aug-06 18:32

Hi,
I appologise for my knowledge of English. I think you be able use table in data base - Name(char(50)), Data(text). Name for document title and Data for Ms Word document. For load document you be able use ASP.NET web handler's. Web handlers are software modules that handle raw HTTP requests received by ASP.NET. I be able send you sample use this handler's.

Re: Word Doc from Database

Ramasubramaniam22-Aug-06 5:39

Ramasubramaniam

22-Aug-06 5:39

Hi,

This is very simple.
1) You store the word document in a specific folder on the server.
2) Store the filename and path details to a database table.
3) Select the files information and assign to a datagrid, on the datagrid make the file name as a hyperlink.
4) onclick of the link open the file by changing the content type.

Ram

Re: Word Doc from Database

NinaWilliam22-Aug-06 18:32

NinaWilliam

22-Aug-06 18:32

can you show me a code sample of changing the content type?? and downloading the file?

Re: Word Doc from Database

Ramasubramaniam23-Aug-06 3:37

Ramasubramaniam

23-Aug-06 3:37

Onclick event of an linkbuttton (which has file name as text) write this code(change variable names etc...)

sFullFilePath is the file path (Retrieved from database table)

System.IO.FileInfo oFileInfo = new System.IO.FileInfo(sFullFilePath);

if(oFileInfo.Exists)
{
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" +
sOrigFilename);
Response.AddHeader("Content-Length", oFileInfo.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.WriteFile(sFullFilePath);
Response.End();
}
else
{
lblMessage.Text = "The file cannot be found.";
}

Ram

Item data bound question ..

cheeken2u21-Aug-06 18:00

cheeken2u

21-Aug-06 18:00

in code behind pages, and inside ItemDataBound , how i get the data if the datagrid mode is edit mode, that means..

dim a as string

a = xxxxxxxxx

xxxxxxx is the coding to reterive the data from the selected row inside datagrid in edit mode ?

how i write tis xxxxxxxxx code ?

Best regards,

Chee ken

Re: Item data bound question ..

postmaster@programmingknowledge.com21-Aug-06 18:06

postmaster@programmingknowledge.com

21-Aug-06 18:06

   Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand <br />
<br />
        Dim ID As Int32 <br />
<br />
        ID = Convert.ToInt32(e.Item.Cells(0).Text)

There is an example at:
http://www.programmingknowledge.com/simpleDataGrid.aspx[^]

Re: Item data bound question ..

_AK_21-Aug-06 18:07

_AK_

21-Aug-06 18:07

If you want to check the edit mode then you can put this check for that;
if(e.Item.ItemType==ListItemType.EditItem)

Best Regards,
Apurva Kaushal

Re: Item data bound question ..

cheeken2u21-Aug-06 20:22

cheeken2u

21-Aug-06 20:22

if(e.Item.ItemType==ListItemType.EditItem)

this code put inside ItemDataBound or Editcommand ?

Best regards,

Chee ken

Re: Item data bound question ..

_AK_21-Aug-06 20:25

_AK_

21-Aug-06 20:25

This has to be put in the OnItemDataBound. So this code(under this condition) will get executed for the which is in edit mode.

Best Regards,
Apurva Kaushal

Re: Item data bound question ..

cheeken2u22-Aug-06 17:22

cheeken2u

22-Aug-06 17:22

Thanks for your help.

Best regards,

Chee ken

Re: Item data bound question ..

_AK_22-Aug-06 18:14

_AK_

22-Aug-06 18:14

always welcome.. Smile | :)

Best Regards,
Apurva Kaushal

Anyone who knows how to read error?

blurMember21-Aug-06 17:33

blurMember

21-Aug-06 17:33

I was trying to export my gridview to excel.

    protected void btnExcel_Click1(object sender, EventArgs e)<br />
    {<br />
        Response.Clear();<br />
        Response.Buffer = true;<br />
        Response.ContentType = "application/vnd.xls";<br />
        Response.Charset = "";<br />
<br />
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();<br />
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);<br />
<br />
        dgDisplay.RenderControl(oHtmlTextWriter);<br />
        Response.Write(oStringWriter.ToString());<br />
        Response.End();<br />
     <br />
    }<br />
public override void VerifyRenderingInServerForm(Control control)<br />
    {<br />
        //base.VerifyRenderingInServerForm(control);<br />
    }<br />
<br />