Comments by mani.kishore.asp.net (Top 28 by date)

i have 3 columns

names english marks maths marks

if both names are same like

a 20 marks 30 marks
a 15 marks 10 marks

i am trying for output to be like
35 marks 40 marks at bottom of their respective columns.

how to display at bottom of the column..

i am trying for

http://www.gregorylane.com/article.aspx?ID=1

but unable to get the out put

i.e please see the subtotal
every column has it's own total at bottom cell

same way i was trying

below link gives output

http://blog.codovations.com/2009_05_01_archive.html

but it's providing subtotal in merged way

i tried but it says

{"Input string was not in a correct format."}

without ajax...

thanks for that but my sql while reader

also iterates through all the rows, please suggest for the if condition inside while reader.

i have used it , they work fine...

what you actually require?

can you make it short?

which?

inside the function

e.CommandArgument is specified which is not a member of system.eventargs

trying to include the proxy but does not work

Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Data
Imports System.Configuration
Imports System.Xml.Linq
Imports System.Net
Imports System.Net.Mail
Imports System.Data.SqlClient
Imports System.IO
Imports System.Globalization

'''

''' Summary description for smsapi
'''

Public Class smsapi

Public Function SendEnglishSMS(ByVal mobilno As String, ByVal msgcontent As String) As Boolean


Dim res As String = String.Empty
Try

res = apicall("http://............................................")
Catch ex As Exception
End Try


If Not res.StartsWith("Wrong Username or Password") Then

Return True
Else
'message not sent successfully................
Return False
End If

End Function

Public Function apicall(ByVal url As String) As String


Dim httpreq As HttpWebRequest = DirectCast(WebRequest.Create(url), HttpWebRequest)
Try

Dim myProxy As New Net.WebProxy("ip address", 80)
myProxy.BypassProxyOnLocal = True
myProxy.Credentials = New NetworkCredential("username", "password")
httpreq.Proxy = myProxy


Dim httpres As HttpWebResponse = DirectCast(httpreq.GetResponse(), HttpWebResponse)

Dim sr As New StreamReader(httpres.GetResponseStream())




Dim results As String = sr.ReadToEnd()
sr.Close()
Return results
Catch ex As Exception
Return "0"
End Try

End Function
End Class

all are varchar

still same error





Dim myConnection As New SqlConnection(Utility.CurrentConnectionString)
myConnection.Open()
Try
If Page.IsValid Then
Dim myCommand As SqlCommand = New SqlCommand
Dim mycommand1 As SqlCommand = New SqlCommand
myCommand.Connection = myConnection
myCommand.CommandText = update command................;
myCommand.ExecuteNonQuery()
myCommand.Parameters.Clear()
myCommand1.Connection = myConnection

myCommand1.CommandText = insert command................;


mycommand1.ExecuteNonQuery()

submitbtn.Enabled = False
End If

NO IMAGE BUTTON

Dim sqlselect As String
sqlselect = " SELECT trpbus_seatno FROM trpbus_bookdata where trpbus_date='" & textbox_date.Text & "' and trpbus_time = '" & Label_deptime.Text & "'"


Dim myConnection As New SqlConnection(Utility.CurrentConnectionString)
Dim myCommand As New SqlCommand(sqlselect, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
If myReader.HasRows Then
While myReader.Read()
Dim seat As String = (myReader("seat")).ToString()
If seat = "S-1" Then
ImageButton_seat_1.ImageUrl = seatno_booked
ElseIf seat = "S-2" Then
ImageButton_seat_2.ImageUrl = seatno_booked
ElseIf seat = "S-3" Then
ImageButton_seat_3.ImageUrl = seatno_booked
ElseIf seat = "S-4" Then
ImageButton_seat_4.ImageUrl = seatno_booked
End If

End While
End If
myReader.Close()

my data base structure is like this

emp_no int
date varchar
time varchar
seat_1 bit
seat_2 bit
seat_3 bit
.
.
.
.
seat_50 bit


asp code is

seat_1 imageurl=".....jpg"

seat_1_onclick
imageurl=".....jpg"

1) saving the list box data to sql
2) retreving the data from sql where seat_1 of a particular table value is 1 then imageurl="...........jpg"
for all buttons

my data base structure is like this

emp_no int
date varchar
time varchar
seat_1 bit
seat_2 bit
seat_3 bit
.
.
.
.
seat_50 bit


asp code is

seat_1 imageurl=".....jpg"

seat_1_onclick
imageurl=".....jpg"

1) saving the list box data to sql
2) retreving the data from sql where seat_1 of a particular table value is 1 then imageurl="...........jpg"
for all buttons

1) saving the list box data to sql
2) retreving the data from sql where seat_1 of a particular table value is 1 then imageurl="...........jpg"
for all buttons

i have just created a webform

and i have a excel files 3 of them

i have inserted resuired data to sql using the web form

i have created a dataview and a where condition to that which connecting to data base
to retrieve data

now how to get the textbox data to excel files all 3

in different cells
and how to auto mail using mail button

automail as atachment?

i apolozie as i have just code for saving the data

if you want that i can put

but for going from textbox to excel i have no code
and even that code for auto mail
but i require your help please. help.

i have just created a webform

and i have a excel files 3 of them

i have inserted resuired data to sql using the web form

i have created a dataview and a where condition to that which connecting to data base
to retrieve data

now how to get the textbox data to excel files all 3

in different cells
and how to auto mail using mail button

no please provide some more
best solution

please , it's urgent