|
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.
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
|
You mean to create the db ourselves?
|
|
|
|
|
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..
|
|
|
|
|
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 !
|
|
|
|
|
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.
|
|
|
|
|
http://www.codeproject.com/KB/database/SqlFileStream.aspx
http://www.codeproject.com/KB/database/UploadPicturesSQLServer.aspx
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Do you think some one do the debugging for you. You have to specify the What Error you are getting !
Thank You!
|
|
|
|
|
jigneshp25 wrote:
Dim fiArr As New FileInfo("dir.GetFiles(myFileType)")
What are you doing.. you are placing dir.GetFiles in Quotations... Strange
|
|
|
|
|
Abhishek Sur wrote: What are you doing.. you are placing dir.GetFiles in Quotations... Strange
I think his VS Debugger is not Working
|
|
|
|
|
Yes... Right.
|
|
|
|
|
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.
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.
|
|
|
|
|
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.
|
|
|
|
|
digimanus wrote: why you declare 'Dim myFileType As String' twice in your code?
Because he has no idea about what he is doing
|
|
|
|
|
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
|
|
|
|
|
Are you asking for a syntax highlighting control ? If so, there's nothing built in, you need to write something for that.
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.
|
|
|
|
|
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
Niladri Biswas
|
|
|
|
|
Thanks for your help. so to display a code like in asp.net there is not a component. I have to write?
|
|
|
|
|
You can use
a) textarea [ textmode = multiline] ,
b)div tag
c) Html Table
d) Span tag
e) Image etc. for that
Search in google for any in built component.
Niladri Biswas
|
|
|
|
|
I am facing a problem with crystal report preview in acrobat from the client's computer.
I have a webproject published on the server and
i am able to access required page from the client
but when i click on the print then i am getting a runtime error.
I tried to access the same project from the server from IIS but there also it gives me an error
"Error in File C:\DOCUME~1\FILE-S~1\ASPNET\LOCALS~1\Temp\AziziaSearchReport {90CA8B07-D69F-4614-87B4-15A6B50B1D3D}.rpt:
The request could not be submitted for background processing. "
The rpt is in the same folder as the project.i have put it in a separate folder in the project.
Acrobat is installed on the server and on the client machine.
The same goes if i try with PrintToPrinter Method.
teh code works fine from the source but trouble starts when i publish it on my server.Teh serve has XP Professional version and IIS installed in it.
Please help
|
|
|
|
|
does your website has the rights to acces that path that is given in the error?
Check for the rights of asp_Net user and of NetworkService- user.
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|