ASP.NET

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

Matt Cavanagh

2-Jun-09 22:27

Custom provider maybe?

Re: Prefix the table names in aspnet membership roles management

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

Matt Cavanagh

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

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

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

Abhijit Jana2-Jun-09 21:16

2-Jun-09 21:16

Abhishek Sur wrote:
What are you doing.. you are placing dir.GetFiles in Quotations... Strange

I think his VS Debugger is not Working Roll eyes | :rolleyes:

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Abhishek Sur2-Jun-09 21:19

Abhishek Sur

2-Jun-09 21:19

Yes... Right. $Shucks | :-\$ $Shucks | :-\$

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Christian Graus2-Jun-09 21:14

Christian Graus

2-Jun-09 21:14

It's plain that you have absolutely no idea what you're doing. I suggest buying a book, and reading it. Before you post here again, try reading the guide on how to ask intelligent questions, also.

Herman<T>.Instance2-Jun-09 23:19

2-Jun-09 23:19

why you declare 'Dim myFileType As String' twice in your code?

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

Abhijit Jana3-Jun-09 0:02

3-Jun-09 0:02

digimanus wrote:
why you declare 'Dim myFileType As String' twice in your code?

Because he has no idea about what he is doing Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

display code component

taki said2-Jun-09 20:58

taki said

2-Jun-09 20:58

Hi,
everyone i'm working in e-learn website projet with asp.net and i would like to display this code in the end-user.

using System;<br />
using System.Collections.Generic;<br />
using System.Linq;<br />
using System.Text;<br />
<br />
namespace SiteIntranetMasterCCI.Models.Interface<br />
{<br />
    interface ICsharp<br />
    {<br />
        IQueryable<CoursCsharp> ListAll();<br />
        CoursCsharp GetCoursCsharp(int id);<br />
        void AddCsharp(CoursCsharp csharp);<br />
        void DeleteCsharp(CoursCsharp csharp);<br />
    }<br />
}

i try a listbox but it is not look well. Someone could help me how can i display the code in page aspx.
Thanks

Christian Graus2-Jun-09 21:16

Christian Graus

2-Jun-09 21:16

Are you asking for a syntax highlighting control ? If so, there's nothing built in, you need to write something for that.

Niladri_Biswas3-Jun-09 17:32

Niladri_Biswas

3-Jun-09 17:32

If it syntax highlighting, you have to write your own program.

Else if you want to display the code as it is just put it inside a string and display

e.g.

string strDisplayCode = "using System;" + Environment.Newline;

strDisplayCode += "using System.Collections.Generic;" + Environment.Newline;

..........
.........

strDisplayCode += "void DeleteCsharp(CoursCsharp csharp);}}";

hope it helps, though your question is not crystal clear
Smile | :)

Niladri Biswas

taki said3-Jun-09 21:27

taki said

3-Jun-09 21:27

Thanks for your help. so to display a code like in asp.net there is not a component. I have to write?