Re: views in stored procedure - ASP.NET Discussion Boards

kimo code2-Oct-07 1:03

2-Oct-07 1:03

hi all

when i use Asp configuration site to create user or group there is a database created in my site
in this path App_Data>>ASPNETDB.MDF
can i put this database in my sql server not in the site in the previous path
because i want to use and link user with some action in my application
thaks all

Kareem Elhosseny

google search

venky4561-Oct-07 23:30

venky456

1-Oct-07 23:30

i want to display google search results in asp page.here i displayed google results by using html,java script.but i run another result display time also displays.
so plz send code in c# to display google results in our page

venkat

Re: google search

Christian Graus2-Oct-07 0:06

Christian Graus

2-Oct-07 0:06

Well, all you need to do is form a google search URL including the search terms and pass it to your browser.

venky456 wrote:
but i run another result display time also displays.

I can't work out what this bit means ?

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 )

Re: google search

venky4562-Oct-07 20:15

venky456

2-Oct-07 20:15

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

views in stored procedure

Sonia Gupta1-Oct-07 23:06

Sonia Gupta

1-Oct-07 23:06

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

Re: views in stored procedure

John-ph2-Oct-07 0:28

John-ph

2-Oct-07 0:28

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

Re: views in stored procedure

Sonia Gupta2-Oct-07 0:30

Sonia Gupta

2-Oct-07 0:30

in stored procedure i am calling the views.
i am not writing the sql statements there.

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: views in stored procedure

John-ph2-Oct-07 0:35

John-ph

2-Oct-07 0:35

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

Re: views in stored procedure

sepel2-Oct-07 0:53

sepel

2-Oct-07 0:53

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

Re: views in stored procedure

Sonia Gupta2-Oct-07 1:12

Sonia Gupta

2-Oct-07 1:12

ThanQ

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Loop through a dataset

Sebastian T Xavier1-Oct-07 23:04

Sebastian T Xavier

1-Oct-07 23:04

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

Re: Loop through a dataset

John-ph1-Oct-07 23:45

John-ph

1-Oct-07 23:45

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

Re: Loop through a dataset

Sebastian T Xavier1-Oct-07 23:57

Sebastian T Xavier

1-Oct-07 23:57

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

Re: Loop through a dataset

John-ph2-Oct-07 0:09

John-ph

2-Oct-07 0:09

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

Re: Loop through a dataset

Sebastian T Xavier2-Oct-07 1:00

Sebastian T Xavier

2-Oct-07 1:00

Thanks

Sebastian

how can i attach ASPNETDB to sql server?

kimo code1-Oct-07 22:41

kimo code

1-Oct-07 22:41

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

RSS feed

jegastar1-Oct-07 22:26

jegastar

1-Oct-07 22:26

Hi all,
Can anyone tell me How can we acheive RSS feed through ASP.net ?

Advance thanks

By Jegastar.

Re: RSS feed

Guffa1-Oct-07 23:26

Guffa

1-Oct-07 23:26

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

Piyush Vardhan Singh1-Oct-07 22:10

Piyush Vardhan Singh

1-Oct-07 22:10

how to save any file in access database please help

Piyush Vardhan Singh
Senior Software Engineer
TAS NewDelhi
India

Re: how to save any file in access

Christian Graus1-Oct-07 22:31

Christian Graus

1-Oct-07 22:31

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 )

Re: how to save any file in access

Piyush Vardhan Singh1-Oct-07 22:37

Piyush Vardhan Singh

1-Oct-07 22:37

i want to store any file(.jpj,.txt,.doc)in access database

Piyush Vardhan Singh
Senior Software Engineer
TAS NewDelhi
India

Re: how to save any file in access

Christian Graus2-Oct-07 0:05

Christian Graus

2-Oct-07 0:05

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 )

Re: how to save any file in access

Guffa1-Oct-07 23:24

Guffa

1-Oct-07 23:24

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;

Re: how to save any file in access

Piyush Vardhan Singh2-Oct-07 0:13

Piyush Vardhan Singh

2-Oct-07 0:13

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

Re: how to save any file in access

Guffa2-Oct-07 3:46

Guffa

2-Oct-07 3:46

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;

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.