|
i read somewhere two lines in the stored procedure.
@companyname varchar(120),
declare @companyname varchar(120),
What is the differnce between them?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
In short, the first would be used to specify a parameter to the proc. The second would be to declare a variable to use with the proc
only two letters away from being an asset
|
|
|
|
|
@companyname varchar(120) is the parameter which value will be sent by the user input.
declare @companyname varchar(120) is the variable declared inside the procedure.
if you are passing some arguments in the procedure, then you will never
needed it to redeclare.
All The Best
Sathesh Pandian
|
|
|
|
|
thanks..
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
(@companyname varchar(120),) its declare to takes parameter for storprocr
(declare @companyname varchar(120),) not take parameter
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
BY declare @companyname varchar(120)
Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values with either a SET or SELECT statement.
While @companyname varchar(120)
When we pass parameter in Procedure Then we stored them that parameter through Addparameter function.
Raghvendra Kumar Roy
|
|
|
|
|
u have not given my answer yaar which i previews asked
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
Hi All,
I have a Master Page view LoginView Control on it, in LoginView I have <loggedintemplate> tags and whole site (HTML, Controls, ...) is place between this tags. But the problem is that I cant reach non of them from the code. For example: I have menu with id "Menu1" adn when I type
Menu1.
and press CRTL+SPACE nothing happends at all, only control which is visible from master page is LoginView.
How to make other to be reachable too?
Tenx
|
|
|
|
|
is there any sql query that implements the next and previous records.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
i think it should n0t possible in sql query.it possible in ui
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
can u tell me how it possible :- friendship is love and love is friendship
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
|
|
No it is not possible
Raghvendra Kumar Roy
|
|
|
|
|
You mean this won't work
SELECT Description, Date<br />
FROM (SELECT ROW_NUMBER() OVER (ORDER BY Date DESC)<br />
AS Row, Description, Date FROM LOG)<br />
AS LogWithRowNumbers<br />
WHERE Row >= 1 AND Row <= 10
Guess I have a unique build of SQL Server 2005.
See the links in my post.
only two letters away from being an asset
|
|
|
|
|
Hi, In my application i have a gridview for whose columns i'm using templatefields
<asp:TemplateField HeaderStyle-CssClass="templateHeaderStyle" HeaderText="<%$ Resources:Resource, AT_JobID_Text %>" SortExpression="JOB_OID" >
here if i give 'SortExpression', then the column header gets underlined...I dont want it like that, the underline must be seen on hover of the mouse on the header...the sorting is also required...
how to accomplish this..
could anyone please tell me?
thanks
|
|
|
|
|
Use styleSheet class for headerTemplate
Best Regard
Pathan
GOD HELP THOSE WHO HELP THEMSELVES
|
|
|
|
|
hi,
i have stylesheet for it:
.templateHeaderStyle
{
font-family:Arial;font-size:small; font-weight:normal;padding-left: 0.5em; text-decoration:none;
}
If i remove 'SortExpression' from:
<asp:TemplateField HeaderStyle-CssClass="templateHeaderStyle" HeaderText="<%$ Resources:Resource, AT_JobID_Text %>" SortExpression="JOB_OID" >
then the underline for column header doesn't come...but then sorting doesn't work....
i need it to sort the column based on "JOB_ID"...how do i do it?
kindly do guide me..thanks
|
|
|
|
|
which SQL query will be used to display the last added 4 or values, i want the recent values to b displaed into datagrid as the database i updated daily
|
|
|
|
|
SELECT TOP # [fields] FROM [table]
Replace # with the maximum number of records to return...
|
|
|
|
|
sir,
i think top # will give the first-n entries.
but the question was the last 4 addded records.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
Sir,
I think you need to invert the order of your result set then...
ORDER BY Fieldname DESC
This will make sql sort the result set descending on field Fieldname and then pick the top 5 (which is then the latest 5)
|
|
|
|
|
Post your Question in the Suitable Forum.
SSK.
|
|
|
|
|
select top 5 * from table
use above query .it will work...
Mohammad Mustafa
|
|
|
|
|
hi friends
this is my stored procedure
CREATE procedure dbo.sp_ins_logo
@companyname varchar(120),
@country varchar(80),
@url varchar(150),
@category varchar(80),
@description varchar(250),
@picturepath varchar(80),
@picturetype char(5),
@status int,
@ins_status varchar(10) output,
@lcode varchar(10) output
as
set nocount on
begin transaction
declare @logo_rowid decimal
declare @logo_code varchar(10)
declare @logo_rowcount decimal
declare @max_logoid decimal
declare @logo_codepfix char(3)
set @logo_codepfix='LGO'
select @logo_rowcount= (select count(*) from dbo.tbladdlogos1)
if @logo_rowcount = 0
begin
select @logo_rowid = 1
select @logo_code = @logo_codepfix + convert(varchar(5),@logo_rowid)
end
else
begin
select @max_logoid = (select max(row_id) from dbo.tbladdlogos1)
set @logo_rowid = @max_logoid + 1
set @logo_code = @logo_codepfix + convert(varchar(5),@logo_rowid)
end
declare @file_name varchar(80)
set @file_name = @picturepath + @logo_code + '.' + @picturetype
if not exists (select companyname from dbo.tbladdlogos1 where url = @url)
begin
if not exists (select companyname from dbo.tbladdlogos1 where companyname = @companyname)
begin
insert into dbo.tbladdlogos1 values(@logo_rowid,@logo_code,@companyname,@country,@url,@category,@description,@file_name,@status)
declare @ER as int
select @ER = @@error
if @ER <> 0
begin
set @ins_status='Failure'
set @lcode=@logo_code
end
else
begin
set @ins_status='Success'
set @lcode=@logo_code
end
end
end
commit
GO
this is my codebehind
Try
Dim companyName, categoryName, countryName As String
Dim url, description, other, inFilename, fileType, path, ccategory As String
Dim status As Integer
companyName = txtcompany.Text
ccategory = txtcategory.Text
countryName = ddcountry.SelectedItem.Text
status = 0
url = txturl.Text
description = txtdescrip.Text
path = "images\logos\country\"
inFilename = myFile.PostedFile.FileName
fileType = inFilename.Substring((inFilename.IndexOf(".")) + 1, ((Len(inFilename)) - inFilename.IndexOf(".")) - 1)
strConnString = obj.GetConnectionString()
conn = obj.GetDbConnection(strConnString)
' create a sql comman using the query string and the DBconnection
myCommand = New SqlCommand("sp_ins_logo", conn)
myCommand.CommandType = CommandType.StoredProcedure
Dim objParam As SqlParameter
objParam = myCommand.Parameters.Add("@companyname", SqlDbType.VarChar, 120)
objParam.Direction = ParameterDirection.Input
objParam.Value = companyName
objParam = myCommand.Parameters.Add("@country", SqlDbType.VarChar, 80)
objParam.Direction = ParameterDirection.Input
objParam.Value = countryName
objParam = myCommand.Parameters.Add("@url", SqlDbType.VarChar, 150)
objParam.Direction = ParameterDirection.Input
objParam.Value = url
objParam = myCommand.Parameters.Add("@category", SqlDbType.VarChar, 80)
objParam.Direction = ParameterDirection.Input
objParam.Value = ccategory
objParam = myCommand.Parameters.Add("@description", SqlDbType.VarChar, 250)
objParam.Direction = ParameterDirection.Input
objParam.Value = description
objParam = myCommand.Parameters.Add("@picturepath", SqlDbType.VarChar, 80)
objParam.Direction = ParameterDirection.Input
objParam.Value = path
objParam = myCommand.Parameters.Add("@picturetype", SqlDbType.Char, 5)
objParam.Direction = ParameterDirection.Input
objParam.Value = fileType
objParam = myCommand.Parameters.Add("@status", SqlDbType.Int)
objParam.Direction = ParameterDirection.Input
objParam.Value = status
objParam = myCommand.Parameters.Add("@ins_status", SqlDbType.VarChar, 10)
objParam.Direction = ParameterDirection.Output
objParam = myCommand.Parameters.Add("@lcode", SqlDbType.VarChar, 10)
objParam.Direction = ParameterDirection.Output
myCommand.ExecuteNonQuery()
Dim insStatus, insCode As String
insStatus = myCommand.Parameters("@ins_status").Value
insCode = myCommand.Parameters("@lcode").Value
If insStatus = "Success" Then
Dim statusOutput As String
If statusOutput = "Success" Then
lblMsg.Visible = True
lblMsg.ForeColor = Color.DarkGreen
lblMsg.Text = "Your Logo was uploaded successfully."
Else
Dim delQuery As String
delQuery = "delete from tbladdlogos1 where logo_code='" & insCode & "'"
myCommand = New SqlCommand(delQuery, conn)
myCommand.ExecuteNonQuery()
lblMsg.ForeColor = Color.Red
lblMsg.Text = statusOutput
End If
ElseIf insStatus = Nothing Then
lblMsg.ForeColor = Color.Red
lblMsg.Text = "Problem in uploadig your Logo, Please Try again Later..!"
Else
lblMsg.ForeColor = Color.Red
lblMsg.Text = "you have already uploaded the logo for this comapny"
End If
Catch ex As Exception
Response.Write(ex.Message)
Finally
If (Not conn Is Nothing) Then
' objCsDataBase.CloseDbConnection(conn)
End If
End Try
End Sub
my problem is:
I have four texboxs
1.company name
2.url
3.category
4.description
5.fileupload
here ,i wrote the storedprocdure the users entered the company one time only
next time he entered same comapany the "you have already uploaded the logo for this comapny" this text is displayed
but i entered next time i got error like this
"Cast from type 'DBNull' to type 'String' is not valid"
plz help me
regards
saravanan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
