|
i am dispaying google search results with code project code.whisi was usd by twohiddenfields and javascript.it displays results well.the problem is it was used in indexing server .when i use radiobutton1 checked then my site search results.if i set radiobutton2 then google results displayed.it write under button control.
if once i choose google results if next i choose mysite results .then also displaying google& mysite results.
Here script run at each page load time.display results of google.for ur understanding see google co-operative search results in code project.
plz send code for this asap
thanks
venkat
|
|
|
|
|
i am using the view in stored procedure.
I the view i am using a query like
select * from t whee id=2
this view i being used in the stored procedure
can i pass the parameterin the stored procedure for the id.i mean id i already mentioned in the view, i want to mention this id in stored procedure as a parameter .how can i do that
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
you should have posted this question in the SQL forum.
Sonia Gupta wrote: can i pass the parameterin the stored procedure for the id.
There are no restrictions imposed on sql server to pass parameter (ID) to the stored procedure.
Sonia Gupta wrote: how can i do that
Create Procedure [ProcedureName]<br />
@Parameter datatype<br />
AS<br />
[Sqlstatements...]<br />
GO
Regards J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
in stored procedure i am calling the views.
i am not writing the sql statements there.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: in stored procedure i am calling the views.
i am not writing the sql statements there.
calling the View? I have not heard about it. All that I know is to USE the View. View is a Virtual Table. It provide's an alternative way to look at the Actual table.
And Inorder to Use the View in the stored procedure you have to write an Sql statement.
Can we have this disscussion in the Sql Forum?
Regards J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
hi
you want to select an special row of view from storepeocedur ?
just pass the parameter to storeprocedure and then in storprocedure
call the view with a select .. where ..
sepel
|
|
|
|
|
ThanQ
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
All,
Can i loop through a dataset using my client side script(Javascript). Actually i am trying to implement a search, a particular view of dataset is bound to a datagrid. if the keyword in not in the grid, i have to extend the search to the whole dataset. Please provide some clue...
any suggection would be appreciated.........
Thanks for your time
Sebastian
|
|
|
|
|
Sebastian T Xavier wrote: Can i loop through a dataset using my client side script(Javascript).
No.You can't. There is no Dataset object in Javascript and the Dataset which you are talking is not accessible on the client-side.
Sebastian T Xavier wrote: Actually i am trying to implement a search, a particular view of dataset is bound to a datagrid. if the keyword in not in the grid, i have to extend the search to the whole dataset. Please provide some clue...
DataGrid is rendered to the client as a HTML Table. Through Javascript You can loop the items of the table...
Regards J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
Hi John,
Thanks for the reply.
The whole dataset is not bound to the grid, (if it was , i could have search it cool) , only a particular view (say data with the location id 7) is bound to the grid. I have to search for a keyword (say asp) in the grid & if it is not in the grid , i have to search in the whole dataset.
Thats the scenario....will you be able to give more sparkles.....
Thanks once again
Sebastian
|
|
|
|
|
Sebastian T Xavier wrote: if it is not in the grid , i have to search in the whole dataset.
you have to do this on the server-side. Instead of searching the Dataset, you can search in the Database and get the result. Because when you do a post-back for a search, you need to query the Database again to fill the Dataset, right? I suggest you to write a stored proc on the database side which will return the search result.
Regards J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
|
Hi All ;
in Asp.net 2 u can add user or role and all of them saved in the database named ASPNETDB in appdata folder u can see it
my case
iam adding user and role programatically can i take this database and attach it into sql server
Kareem Elhosseny
|
|
|
|
|
Hi all,
Can anyone tell me How can we acheive RSS feed through ASP.net ?
Advance thanks
By Jegastar.
|
|
|
|
|
You just make a page that gives an XML document as response. The XML document should follow one of the RSS[^] specifications.
---
single minded; short sighted; long gone;
|
|
|
|
|
how to save any file in access database please help
Piyush Vardhan Singh
Senior Software Engineer
TAS NewDelhi
India
|
|
|
|
|
This question has nothing to do with ASP.NET.
What do you mean by 'any file'. What do you hope to do with these files ? Why do you want to store them in an access DB ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i want to store any file(.jpj,.txt,.doc)in access database
Piyush Vardhan Singh
Senior Software Engineer
TAS NewDelhi
India
|
|
|
|
|
You didn't answer my question. Why do you want to do that ? What do you want to do with the files ?
Odds are, you'll find it works better to store the files on the file system, and store their paths in your DB. Especially if it's access ( not exactly a real database at the best of times )
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
You use the Image data type. The name of the data type may be confusing, as it doesn't have to contain data that represents a picture, but can contain any data.
Now that you know exactly what to use, you should be able to find plenty of examples on how to do it.
---
single minded; short sighted; long gone;
|
|
|
|
|
thanks ok i have done
con = New OleDbConnection(connectionString)
' con.Open()
adp = New OleDbDataAdapter(str1, con)
Dim ds As New DataSet()
Dim cb As New OleDb.OleDbCommandBuilder(adp)
Dim row As DataRow
adp.Fill(ds)
Dim SourceLoc As String = "c:/india.bmp"
'Dim DestinationLoc As String = "c:/Images/TestImage.jpg"
Dim Fs As FileStream = New FileStream(SourceLoc, FileMode.Open, FileAccess.Read)
' Create a byte array of file stream length
Dim ImageData As Byte()
ReDim ImageData(Fs.Length)
Fs.Read(ImageData, 0, System.Convert.ToInt32(Fs.Length))
'Close the File Stream
Fs.Close()
row = ds.Tables(0).NewRow
row.Item(0) = ImageData
ds.Tables(0).Rows.Add(row)
adp.Update(ds)
Piyush Vardhan Singh
Senior Software Engineer
TAS NewDelhi
India
|
|
|
|
|
Piyush Vardhan Singh wrote: Dim Fs As FileStream = New FileStream(SourceLoc, FileMode.Open, FileAccess.Read)
' Create a byte array of file stream length
Dim ImageData As Byte()
ReDim ImageData(Fs.Length)
Fs.Read(ImageData, 0, System.Convert.ToInt32(Fs.Length))
'Close the File Stream
Fs.Close()
If you are using framework 2, you can replace this with:
Dim ImageData as Byte() = File.ReadAllBytes(SourceLoc)
---
single minded; short sighted; long gone;
|
|
|
|
|
Piyush Vardhan Singh wrote: Piyush Vardhan Singh
Senior Software Engineer
I am really surprised about how you became Senior Software Engineer ? Or you only decided that you are senior ?
|
|
|
|
|
hello
imagine there are 2 columns in a database like A & B and you'd like to sort the records by A/B
does anyone know what is the select statement?
thank you
|
|
|
|
|
If you mean to sort first by column A then B you can use:
SELECT * FROM tbl ORDER BY A, B ASC
|
|
|
|