ASP.NET

Re: asp.net global functions

10-Sep-07 1:58

SHatchard wrote:
This can be achieved by using a static class, for example named Utilities like below

Why you are so specific on Static class ?

My Website | Ask smart questions

N a v a n e e t h10-Sep-07 1:56

Get Click event of flash object.

10-Sep-07 1:56

abglorie wrote:
Now I write a same function into every form.

But I need the particular function using different form
without writing a same coding.

Create a base class and inherit this base class in all the pages. Write common function in Base class. By default you will see all the ASPX pages are inherited by Page class. You have to remove this and write your base class and your base class should inherit from Page class.

My Website | Ask smart questions

How to redirect

bhattiprolu10-Sep-07 1:33

bhattiprolu

10-Sep-07 1:33

AFter successfully achieved form authentication how to redirect the page to the corresponding next page?

Re: How to redirect

abglorie10-Sep-07 1:38

abglorie

10-Sep-07 1:38

Call the next page. using following coding

Response.Redirect("NextPage.aspx")

Re: How to redirect

Vasudevan Deepak Kumar10-Sep-07 2:07

Vasudevan Deepak Kumar

10-Sep-07 2:07

There is also a specific redirect with FormsAuthentication. However, check out this URL:

http://www.webmasterworld.com/forum47/2725.htm[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

mmSoni10-Sep-07 1:26

mmSoni

10-Sep-07 1:26

Can anyone tell me how to get click event of Flash Object?
I have to redirect to some page on click of the flash object. I have tried Onactivate event of the object, and its working fine in IE but not working in FireFox and Safari browser

asp dot net - session state

abglorie10-Sep-07 1:20

abglorie

10-Sep-07 1:20

Now I need a help from you quite urgent.

I read a data from DataSet as EmpID.
Display the EmpID in form1.aspx using Label control.
Data Enter in textbox controll like salary.
Now click a submit button.

The form refresh and update the salary respective EmpID.

Next we want the empID move to next employee.

How to apply the above task.

I try to session state but not working. my form was developed following method.

form.aspx

<asp:label id="Mylabel" text="<%Session(" ds")("empid")%="">" runat="server">
<asp:textbox id="MyText" runat="server">
<asp:button id="Submit" text="Submit" runat="server">

form.aspx.vb

dim cmd as new sqlcommand("Select EmpID from MyTable", connection)
dim adp as new sqldataadapter(cmd)
dim ds as new DataSet()
Try
connection.open()
adp.fill(ds,"MyTable")
session("ds") = ds.tables("MyTable")
catch
finally
connection.close()
end try

abglorie

Re: asp dot net - session state

oceanexplorer10-Sep-07 2:36

oceanexplorer

10-Sep-07 2:36

Hi,

You may want to look more into using a datareader for this type of usuage if your wanting to cycle through a record at a time.

An SqlDataReader sits in the System.Data.SqlClient namespace.

You call a read by something like this (this isn't perfect code as I work in c#!)

SqlConnectionconnection = newSqlConnection("myconnectionstringhere")
Dim command As SqlCommand = newSqlCommand("SELECT * FROM Customers", connection)
connection.Open()
Dim data As SqlDataReader = command.ExecuteReader()
data.read()

The Data.Read method will advance and retrieve the next record. Remember to close the connection once your done with it.

Do a search on google for SqlDateReader and you will get information on it's usage back.

Regards

Paul

Iframe

kmanisha10-Sep-07 1:12

kmanisha

10-Sep-07 1:12

hi friends
in my application i am using Iframe
i have three form 1) checkout.aspx 2) frameurl.aspx 3) abc.aspx
from checkout.aspx i redirect to frameurl.a
on frameurl i have one Iframe Iframe's src is abc.aspx
abc.aspx is outside url
which shows in Iframe control
I enter some key here
When i Enter key and press 'Submit' button
i want to redirect to Checkout.aspx
my problem is it redirects to Checkout.aspx
but shows in same Iframe means IE's url doesn't change

Thanks

Re: Iframe

N a v a n e e t h10-Sep-07 1:53

image on right side treeview

10-Sep-07 1:53

kmanisha wrote:
my problem is it redirects to Checkout.aspx
but shows in same Iframe means IE's url doesn't change

Specify target=_self or _blank

My Website | Ask smart questions

red27man10-Sep-07 1:03

red27man

10-Sep-07 1:03

i was trying to display a image on the right side of the node.....

any help is appreciated

Doubt in Dataview filter options

jayarajmrj10-Sep-07 0:43

jayarajmrj

10-Sep-07 0:43

I have two dataset. Each datasets contain one table .

Dataset1.Tables[0];
----------------------------
Id Description

100 Raja
101 Jayaraj
102 Ramesh
103 Mani
104 kavitha

Dataset2.Tables[0]
-----------------------------
Id UpdatedWhen

100 05/06/07
104 01/09/00

How can i filter the above datasets columns by using DataView?

The result should be like this

Id Description

101 Jayaraj
102 Ramesh
103 Mani

The result going to bind in DropDownList , like this

Jayaraj
Ramesh
Mani

Pls give the code ASAP

Re: Doubt in Dataview filter options

John-ph10-Sep-07 1:45

10-Sep-07 1:45

Navigate through the Dataset2.Tables[0] records and have the collection of ID in a string.
write something similar to this...

For Each drow In Dataset2.Tables(0).Rows<br />
   Str = Str + drow("ID") + ","<br />
Next<br />
str.Remove(lstr.Length - 1, 1)<br />

To filter the records

Dim dv As DataView<br />
dv = Dataset1.Tables[0].DefaultView<br />
dv.RowFilter = "ID NOT IN (" + str + ")"

Regards
J O H N

"Even eagles need a push." David McNally

popup window

saravanan0510-Sep-07 0:43

saravanan05

10-Sep-07 0:43

hi friends

i have class name as class1.cs.
how to create the javascript popup window in class.
i got the window in aspx page,but class page shown error.

regards
saravanan

Re: popup window

John-ph10-Sep-07 1:13

10-Sep-07 1:13

saravanan05 wrote:
javascript popup window

window.open('PagePath','WindowName','WindowAttributes');

Regards
J O H N

"Even eagles need a push." David McNally

Re: popup window

N a v a n e e t h10-Sep-07 1:51

How to insert HTML string (with tags) in word and display as html

10-Sep-07 1:51

saravanan05 wrote:
i got the window in aspx page,but class page shown error.

In class, Response/Page object won't be available. So you need to pass these objects manually when your class is initializing. You can pass through constructor like

class1 c1 = new class1(this.Page) / class1 c1 = new class1(this.Response)

In your class take these variables and do as usual you do in ASPX page.

class class1
{
   private Page CurrentPage = null;   //This will be used in entire class
   public class1(Page p)
   {
       CurrentPage  = p;  //Assigning page object passed 
   }
}

My Website | Ask smart questions

here2learn10-Sep-07 0:33

here2learn

10-Sep-07 0:33

Hi all,

i am working on a web application which reads html data saved into the database and displays it to a newly opened word file.
here HTML contain is one html file saved into the database as simple string.
i am able to read these contents and write to word file, but problem is that it is writing as simple characters only, it's not writing it as html like if this is the line in content my content
after writing it is coming as my content
only, all html contents are apparing and all other html data is also coming as text.

can anybody help me how can i write these html contents so they appear as html on word file...

People often say that motivation doesn't last. Well, neither does bathing - that's why we recommend it daily
Akhilesh Singh

how do i store news articles?

marvc19-Sep-07 23:46

marvc1

9-Sep-07 23:46

Hi,

This is my situation, I have a ASP.NET website that has a mysql database behind it.

I can't work out how to store news articles.

Basically my news articles are written in MS word and saved as web pages, then changed to .txt files to give me the html code that will display the text the same as it is diplayed in the original word file.

But I can't store this html string in my mysql database using a gridview insert command to insert it. It doesn't like special characters. The mysql field type is text.

At the moment I am getting around it by just storing the .txt file name in the database, then finding it, and using StreamReader to read the html code. This works fine, but it means every news article has to be stored as a .txt file in the server file. I won't to be able to save this data in the database.

I don't won't to open a new page to display the news article.

Am I going about this the wrong way, is there a better way to store news articles?
Is there a way to insert the special characters into the mysql database using gridview?

previous page is error but still work..

hardyyanto9-Sep-07 23:39

Re: previous page is error but still work..

9-Sep-07 23:39

hello all....,

i have a error, but it's can working.. i have post this in forum 4 thread and codeproject 3 thread, but they give answer can not working... so, pls... help...
i have 2 page like default.aspx and cart.aspx.
this is my code:

default.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<title>Untitled Page

<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:GAMESConnectionString %>"
="" selectcommand="SELECT * FROM [items]">

<asp:repeater id="Repeater1" runat="server" datasourceid="SqlDataSource1">
<headertemplate>

<itemtemplate>
<asp:label id="kode" runat="server" text="<%#Eval("Kode") %>">
<asp:label id="name" runat="server" text="<%#Eval("Name") %>">

<asp:label id="cost" runat="server" text="<%#Eval("cost","{0:n}") %>">

<asp:textbox id="total" text="1" runat="server" width="24px">
<asp:button id="addtocart" runat="server" commandname="buy" text="add to cart" postbackurl="~/cart.aspx?from=default">

<footertemplate>

default.aspx.vb

Partial Class _Default
Inherits System.Web.UI.Page
Private kode As String = ""
Private name As String = ""
Private total As Integer = 0
Private cost As Double = 0
Public Function dataList() As ArrayList
Dim itemselecting As ArrayList = New ArrayList
itemselecting.Add(kode)
itemselecting.Add(name)
itemselecting.Add(total)
itemselecting.Add(cost)
dataList = itemselecting
End Function

Protected Sub Repeater1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles Repeater1.ItemCommand
kode = CType(Repeater1.Items(e.Item.ItemIndex).FindControl("kode"), Label).Text
name = CType(Repeater1.Items(e.Item.ItemIndex).FindControl("name"), Label).Text
total = CInt(CType(Repeater1.Items(e.Item.ItemIndex).FindControl("total"), TextBox).Text)
cost = CType(Repeater1.Items(e.Item.ItemIndex).FindControl("cost"), Label).Text

End Sub
End Class

cart.aspx

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="cart.aspx.vb" Inherits="cart" %>

<title>Untitled Page

<asp:repeater id="Repeater1" runat="server">
<itemtemplate>

kode	name	total	cost	subtotal
<asp:label id="label1" runat="server" text="<%#DataBinder.eval(Container.DataItem,"Kode") %>">	<asp:label id="label2" runat="server" text="<%#DataBinder.eval(Container.DataItem,"Name") %>">	<asp:textbox id="txttotal" runat="server" text="<%#DataBinder.eval(Container.DataItem,"total") %>" ="" width="20px">	<asp:label id="label3" runat="server" text="<%#DataBinder.eval(Container.DataItem,"cost") %>">	<asp:label id="label4" runat="server" text="<%#DataBinder.eval(Container.DataItem,"subTotal") %>">
grand total:		<asp:label id="total" runat="server" text="0">		<asp:label id="subtotal" runat="server" text="0">

<asp:button id="Button1" runat="server" text="update">

cart.aspx.vb

Partial Class cart
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not PreviousPage Is Nothing AndAlso PreviousPage.IsCrossPagePostBack Then
Dim itembuy As Integer
Dim itemselecting As ArrayList = New ArrayList
If (Request.QueryString("from") = "default") Then
itemselecting = CType(Me.PreviousPage, _default).datalist()
End If
itembuy = Session("Itembuy")
If Not checksameitem(itemselecting(0)) Then
Session("Kode_" & itembuy) = itemselecting(0)
Session("Name_" & itembuy) = itemselecting(1)
Session("total_" & itembuy) = itemselecting(2)
Session("cost_" & itembuy) = itemselecting(3)
Session("subtotal_" & itembuy) = itemselecting(2) * itemselecting(3)
itembuy += 1
Session("itembuy") = itembuy
End If
displayData()
End If
If Not IsPostBack Then
Me.displayData()
End If
End Sub
Private Sub displayData()
Dim a As ArrayList = New ArrayList()
Dim itembuy As Integer
Dim i As Integer
Dim totalItem As Integer = 0
Dim totalcost As Double = 0
itembuy = Session("itembuy")
For i = 0 To itembuy - 1
a.Add(New DataKasir(Session("Kode_" & i), Session("Name_" & i), Session("total_" & i), Session("cost_" & i), Session("subtotal_" & i)))
totalItem += Session("total_" & i)
totalcost += Session("subTotal_" & i)
Next
Me.total.Text = totalItem
Me.subtotal.Text = Format(totalcost, "#,##0.00")
Repeater1.DataSource = a
Repeater1.DataBind()
End Sub
Private Function checksameitem(ByVal kode As String) As Boolean
Dim totalItem As Integer = Session("itembuy")
Dim i As Integer
For i = 0 To totalItem
If (Session("Kode_" & i) = kode) Then
checksameitem = True
End If
Next
End Function
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim totItem As Integer = Repeater1.Items.Count
Dim total As Integer
Dim cost As Double
Dim i As Integer
For i = 0 To totItem - 1
total = IIf(CType(Repeater1.Items(i).FindControl("txttotal"), TextBox).Text = "", 0, _
CType(Repeater1.Items(i).FindControl("txttotal"), TextBox).Text)
cost = CDbl(Session("cost_" & i))
Session("total_" & i) = total
Session("subtotal_" & i) = total * cost
Next
displayData()
End Sub

End Class
Public Class DataKasir
Private myKode As String
Private myName As String
Private mytotal As Integer
Private mycost As Double
Private mysubtotal As Double
Public Sub New(ByVal nKode As String, ByVal nName As String, ByVal ntotal As Integer, ByVal ncost As Double, ByVal nsubTotal As Double)
Me.myKode = nKode
Me.myName = nName
Me.mytotal = ntotal
Me.mycost = ncost
Me.mysubtotal = nsubTotal
End Sub
Public ReadOnly Property Kode() As String
Get
Return myKode
End Get
End Property
Public ReadOnly Property Name() As String
Get
Return myName
End Get
End Property
Public ReadOnly Property total() As Integer
Get
Return mytotal
End Get
End Property
Public ReadOnly Property cost() As Double
Get
Return mycost
End Get
End Property
Public ReadOnly Property subTotal() As Double
Get
Return mysubtotal
End Get
End Property
End Class

my error is in the cart.aspx.vb like the command:

If (Request.QueryString("from") = "default") Then
itemselecting = CType(Me.PreviousPage, _default).datalist()

the error is" type _default is not defined" .. i have no idea to solve this... it can work properly.. but this error can active if there is a some error or warning in the page.
if page not have any errors or warning, this error can not active,but sometimes can error..
so i want to this error resolved, i want _default can be defined...

plz... helppp.....

thx......

John-ph10-Sep-07 0:37

Re: previous page is error but still work..

10-Sep-07 0:37

hardyyanto wrote:
i have a error

can you explain the error and show the code that is specific to the error?

Regards
J O H N

"Even eagles need a push." David McNally

hardyyanto10-Sep-07 5:03

excel not working uniformly across machines with same os

10-Sep-07 5:03

yes.., in the cart.aspx.vb:
itemPilihan = CType(Me.PreviousPage,_default).datalist()

my errors is _default ("type _default is not defined").
i want to take class _default from default.aspx.vb. but the cart.aspx.vb can not detect the class _default.
if i debug program, it can detect, but sometimes can not detect, so, i rebuild website, it can detect, but sometimes not again, so i rebuild again..again..
that datalist is not type, but is name of function in default.aspx.vb.
pls, copy default.aspx,default.aspx.vb, cart.aspx,cart.aspx.vb to your computer.
and try it..my table is only one like items(kode(varchar),name(varchar),cost(money)).
many member that answer my question are not try my data, they only reading that page, then answer it, so it can not work...

pls...thx...

S Palip9-Sep-07 23:11

S Palip

9-Sep-07 23:11

Hi,

The code below works in one of my xp pro machine and fails to compile in another machine with same os. I'm referring excel 11.0 in my application and i have installed Excel 2003(11.8146.8132) SP2 in my machine.

Can any one help with this.

string strSavePath = Server.MapPath(".") + "\\";
strSavePath += "Emb.xls";

// Application ExcelApp = null;
//_Workbook ExcelWorkbook = null;
//_Worksheet ExcelWorkSheet = null;

Excel.Application ExcelApp = null;
Excel.Workbook ExcelWorkbook = null;
Excel.Worksheet ExcelWorkSheet = null;

if (ExcelWorkSheet != null)
ExcelWorkSheet = null;
if (ExcelWorkbook != null)
ExcelWorkbook = null;
if (ExcelApp != null)
ExcelApp.Quit();

//ExcelApp = new Application();
//ExcelWorkbook = (_Workbook)(ExcelApp.Workbooks.Add(Type.Missing));
//ExcelWorkSheet = (_Worksheet)ExcelWorkbook.Sheets["Sheet1"];

ExcelApp = new Excel.Application();
ExcelWorkbook = (Excel.Workbook)(ExcelApp.Workbooks.Add(Type.Missing));
ExcelWorkSheet = (Excel.Worksheet)ExcelWorkbook.Sheets["Sheet1"];

ExcelWorkSheet.get_Range("A3", "E41").EntireColumn.AutoFit();
ExcelApp.Visible = true;
ExcelApp.DisplayFullScreen = false;

What should i do to make it work in all the machines.

Kindly help me.

Thanks and Regards,

PLS

make procedure to check balance > or < totalcost

hardyyanto9-Sep-07 23:03

Re: make procedure to check balance > or < totalcost

9-Sep-07 23:03

helo all...,

i have create procedure can decrease totalcost from order table(database:games.dbo) with balance in bill table(database:bank.dbo). my 2 database in same server is name "boy"

i have 2 database like: bank.dbo and games.dbo

in games.dbo, have a table name is order(user_id,no_order,date,totalcost)

in bank.dbo, have a table name like is bill(no_bill,balance)

this is a list of bill table

no_bill balance

111222 200$

222444 10$

this is a list of order table

user_id no_order date totalcost

a 1 1/1/07 50$

when customer insert no_bill(111222) in page and click a button, then bill table became

no_bill balance

111222 150$

222444 10$

when customer insert no_bill(222444) in page and click a button, then message "sorry, your balance is not enough"

mystore procedure like:

ALTER PROCEDURE [dbo].[pay]
(
@no_bill AS INT,
@no_order AS int,
@totalcost AS money
)
AS
BEGIN
BEGIN TRANSACTION

DECLARE @balanc AS money

SET @balanc= (SELECT [balance] FROM Bank.dbo.bill WHERE [no_bill] = @no_bill)

UPDATE [bank.dbo.bill]
SET
[balance] = @balanc - @totalcost
WHERE
[no_bill] = @no_bill

COMMIT TRANSACTION
END

it can decrease money in bank, but i want it ceck money if balance > totalcost, so balance-totalcost,

if balance<totalcost,so error="" message"sorry,="" your="" balance="" is="" not="" enough"
when="" i="" execute="" store="" procedure="" pay,="" insert="" no_bill,no_order,totalcost.
i="" want="" if="" totalcost="" that=""> balance, it display message"sorry, your balance is not enough"
is it can make in procedure?

thx...

John-ph10-Sep-07 1:27

Re: make procedure to check balance > or < totalcost

10-Sep-07 1:27

Include a IF condition in the procedure that checks whether the Acc.Balance is greater than the TotalCost. If yes Update the Balance and Commit transaction else Raise error and rollback transaction.

Regards
J O H N

"Even eagles need a push." David McNally

hardyyanto10-Sep-07 5:27