Click here to Skip to main content
15,900,110 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: ASP .NET mail sending without password of the sender Pin
Arindam Tewary6-Dec-06 22:24
professionalArindam Tewary6-Dec-06 22:24 
GeneralRe: ASP .NET mail sending without password of the sender Pin
szukuro7-Dec-06 1:37
szukuro7-Dec-06 1:37 
AnswerRe: ASP .NET mail sending without password of the sender Pin
Kapil Thakur6-Dec-06 20:11
Kapil Thakur6-Dec-06 20:11 
QuestionObject Pooling Pin
aaraaayen6-Dec-06 18:41
aaraaayen6-Dec-06 18:41 
AnswerRe: Object Pooling Pin
Saqib Raja6-Dec-06 23:38
Saqib Raja6-Dec-06 23:38 
Questionimplementation of storedprocedures Pin
chinnivinay6-Dec-06 17:51
chinnivinay6-Dec-06 17:51 
AnswerRe: implementation of storedprocedures Pin
Christian Graus6-Dec-06 19:12
protectorChristian Graus6-Dec-06 19:12 
AnswerRe: implementation of storedprocedures Pin
Ritika S6-Dec-06 23:58
Ritika S6-Dec-06 23:58 
Hi,

u can use this as an example which returns integer as output value

Public Function GetMailSent(ByVal CaseId As String) As Integer
Dim objConn As New SqlConnection
Dim objDB As New clsCommon
Dim objDS As New DataSet
Dim objCommand As New SqlCommand
Dim objDA As New SqlDataAdapter
Dim param As New SqlParameter
Dim intMailSent As Integer
Try
objConn = objDB.GetDatabaseConnection
objCommand.CommandType = CommandType.StoredProcedure
objCommand.CommandText = "spGetMailSent"
objCommand.Connection = objConn
objDA.SelectCommand = objCommand
objCommand.Parameters.Add("@CaseID", SqlDbType.VarChar).Value = IIf(IsDBNull(CaseId), DBNull.Value, CaseId)

param = objCommand.Parameters.Add("@retval", SqlDbType.Int)
param.Value = Decimal.Zero
param.Direction = ParameterDirection.Output

intMailSent = objCommand.ExecuteNonQuery()
GetMailSent = objCommand.Parameters("@retval").Value
Finally
'objDB.CloseDatabaseConnection()
End Try
End Function

Regards,

Ritika

QuestionDatagrid binding Pin
miniThomas6-Dec-06 17:44
miniThomas6-Dec-06 17:44 
AnswerRe: Datagrid binding Pin
Saqib Raja7-Dec-06 0:40
Saqib Raja7-Dec-06 0:40 
Questionpopulating datas from sql db and displaying it inTEXTformat - VERY VERY URGENT Pin
saravanan056-Dec-06 13:12
saravanan056-Dec-06 13:12 
AnswerRe: populating datas from sql db and displaying it inTEXTformat - VERY VERY URGENT Pin
Christian Graus6-Dec-06 14:10
protectorChristian Graus6-Dec-06 14:10 
QuestionRg:Style sheet in Child master page Pin
nzsatish6-Dec-06 12:01
nzsatish6-Dec-06 12:01 
AnswerRe: Rg:Style sheet in Child master page Pin
Saqib Raja7-Dec-06 0:09
Saqib Raja7-Dec-06 0:09 
GeneralRe: Rg:Style sheet in Child master page Pin
nzsatish7-Dec-06 9:20
nzsatish7-Dec-06 9:20 
Questionproblem exporting to excel Pin
swissmiss866-Dec-06 10:54
swissmiss866-Dec-06 10:54 
AnswerRe: problem exporting to excel Pin
Saqib Raja6-Dec-06 23:55
Saqib Raja6-Dec-06 23:55 
QuestionAnyone using IIS7 successfully ? Pin
Christian Graus6-Dec-06 9:05
protectorChristian Graus6-Dec-06 9:05 
AnswerRe: Anyone using IIS7 successfully ? Pin
User 17164926-Dec-06 13:52
professionalUser 17164926-Dec-06 13:52 
GeneralRe: Anyone using IIS7 successfully ? Pin
Christian Graus6-Dec-06 14:04
protectorChristian Graus6-Dec-06 14:04 
AnswerRe: Anyone using IIS7 successfully ? Pin
Rama Krishna Vavilala6-Dec-06 14:06
Rama Krishna Vavilala6-Dec-06 14:06 
GeneralRe: Anyone using IIS7 successfully ? Pin
Christian Graus6-Dec-06 14:12
protectorChristian Graus6-Dec-06 14:12 
GeneralRe: Anyone using IIS7 successfully ? Pin
Rama Krishna Vavilala6-Dec-06 14:23
Rama Krishna Vavilala6-Dec-06 14:23 
GeneralRe: Anyone using IIS7 successfully ? Pin
Christian Graus6-Dec-06 19:18
protectorChristian Graus6-Dec-06 19:18 
QuestionExport to Excel. Pin
deepaks36-Dec-06 8:21
deepaks36-Dec-06 8:21 

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.