ASP.NET

2-Jun-09 22:25

better post this in the windows forms forum, not in the ASP forum

In Word you can only store 2 bytes. That is why I use Writer.

Re: sqlprofileprovider

Abhijit Jana2-Jun-09 22:43

2-Jun-09 22:43

anandhakrishnan wrote:
Pls give me some idea of how to use the sqlprofileprovider

Search Google!

anandhakrishnan wrote:
in windows forms applications

This is ASP.NET Forum!

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Best of both worlds? :-/

Matt Cavanagh2-Jun-09 22:02

2-Jun-09 22:02

Hi, I have an image uploading site. Once the user has uploaded the image they are given the direct link like: mysite.com/pics/myimg.jpg and they can direct link to that file from a forum or by just going to the link.
Now is it possible that when they go to the link(as in typing it in the address bar) it displays the picture and then some text content below it. BUT then when they link it like in a forum it still displays the picture fine?

I basically want comments or whatever for pictures but I dont want to have the user given 2 different links, one for hotlinking the other one not.

I have URL Rewriting in place so maybe I could do something with that?

Thanks for the help!

Uwe Keim2-Jun-09 22:16

Uwe Keim

2-Jun-09 22:16

Maybe you write yourself an ASHX handler [^] to server whatever you want to, i.e. once the image and once the text, depending on the context.

• My personal 24/7 webcam
• Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now!
• Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now!

Matt Cavanagh2-Jun-09 22:34

2-Jun-09 22:34

Is it possible to tell the difference between whether they are visiting the link or viewing it from an img tag?

Uwe Keim2-Jun-09 22:38

Uwe Keim

2-Jun-09 22:38

Probably by looking at tue referer url.

Matt Cavanagh2-Jun-09 22:40

2-Jun-09 22:40

Cool, thanks alot. Will go play around Smile | :)

Matt Cavanagh3-Jun-09 2:03

3-Jun-09 2:03

Hmmmm, ok this works great in the this scenario:
One user adds

sql view

jainiraj2-Jun-09 21:37

jainiraj

2-Jun-09 21:37

hi ..
I am creating view in sql server 2000 as-

CREATE VIEW vwSam
As
(select admin.*, cust.FirstName+' '+cust.LastName as CustName
from adminmsgrecieved as admin,custdetails as cust
where admin.AdminId='111' and cust.CustId=admin.FromCustId )

From this i am getting an error invalid object adminmsgrecieved.

But when i run select query only then it works fine.

what problem may be???
and what should i do?

plz help me..
Thanx in adv

Re: sql view

Herman<T>.Instance2-Jun-09 21:59

Prefix the table names in aspnet membership roles management

2-Jun-09 21:59

Would this help?
It is better to add all admin fields instead of using the * option. If someone else wants to look at the view he knows exactly which fields are in the view.

CREATE VIEW vwSam
As
(
	select admin.*, cust.FirstName+' '+cust.LastName as CustName
	from adminmsgrecieved as admin
		INNER JOIN custdetails as cust on cust.CustId=admin.FromCustId
	where admin.AdminId='111'  
)

Have you got a Primary Key on field CustID and has FromCustID a Foreign Key to the CustID field?

In Word you can only store 2 bytes. That is why I use Writer.

tonymathewt2-Jun-09 21:28

tonymathewt

2-Jun-09 21:28

I want to use aspnet membership and roles mananagement in a work I am currently about to do. But a problem I have is with the table names created/used by the roles and membership classes. I want it to be prefixed with "mdt". Is that possible?

Re: Prefix the table names in aspnet membership roles management

Herman<T>.Instance2-Jun-09 22:24

Re: Prefix the table names in aspnet membership roles management

2-Jun-09 22:24

better ask this question in the sql forum. It has to do with system tables to do an action you want.

In Word you can only store 2 bytes. That is why I use Writer.

Matt Cavanagh2-Jun-09 22:27

Re: Prefix the table names in aspnet membership roles management

2-Jun-09 22:27

Custom provider maybe?

tonymathewt3-Jun-09 0:02

tonymathewt

3-Jun-09 0:02

You mean to create the db ourselves?

How can I file upload to MSSQL??

lsh486love2-Jun-09 21:16

lsh486love

2-Jun-09 21:16

I'm using asp.net with C#.

and I would like to know how I can file upload to MSSQL.

Is there any sample source??

please let me know.

thank you..

Abhijit Jana2-Jun-09 21:24

2-Jun-09 21:24

lsh486love wrote:
and I would like to know how I can file upload to MSSQL.

Is there any sample source?

Did you Searched in Google Before post it over here?
One more think, which file do you want to upload in DB? I would suggest to store the path in DB and store the file in Hard Drive.
Thanks !

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Christian Graus2-Jun-09 21:27

Christian Graus

2-Jun-09 21:27

I recommend reading the link in my sig, it contains all the information you need.

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

Matt Cavanagh2-Jun-09 22:04

2-Jun-09 22:04

http://www.codeproject.com/KB/database/SqlFileStream.aspx
http://www.codeproject.com/KB/database/UploadPicturesSQLServer.aspx

Herman<T>.Instance2-Jun-09 22:14

2-Jun-09 22:14

well...if it is a file that contains data that should go into fields of a table. The fastest wat is to use bcp.exe, a commandline util of mssql server.

In Word you can only store 2 bytes. That is why I use Writer.

error in this code

jigneshp252-Jun-09 21:03

jigneshp25

2-Jun-09 21:03

Dim myFileType As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim myFileType As String
Dim dir As New DirectoryInfo(Server.MapPath("./js"))
Dim fiArr As New FileInfo("dir.GetFiles(myFileType)")
myFileType = "*.js"
Dim values As New ArrayList

For Each FileInfo As File In fiArr
values.Add(File.Name)
Next

extFile.DataSource = values
extFile.DataBind()

End Sub

Re: error in this code

Abhijit Jana2-Jun-09 21:09

2-Jun-09 21:09

Do you think some one do the debugging for you. You have to specify the What Error you are getting !

Thank You!

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: error in this code

Abhishek Sur2-Jun-09 21:13

Abhishek Sur

2-Jun-09 21:13

jigneshp25 wrote:
Dim fiArr As New FileInfo("dir.GetFiles(myFileType)")

What are you doing.. you are placing dir.GetFiles in Quotations... Strange WTF | :WTF:

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: error in this code

Abhijit Jana2-Jun-09 21:16