|
Probably by looking at tue referer url.
|
|
|
|
|
Cool, thanks alot. Will go play around
|
|
|
|
|
Hmmmm, ok this works great in the this scenario:
One user adds
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|