|
I am not sure, you'll have to experiment. Those options go in the aspx usually, I'd try to see if they can be added in code, so you can do it conditionally.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
You put the "me.textbox1.readonly=true" in the .aspx.cs.
(I'm not sure of the C# syntax, my code behind is in VB)
|
|
|
|
|
If you are now developing an ASP.NET page, you can set the controls property, READONLY, to either true or false depending on the user's security.
For example:
If (user is admin) then
Me.Textbox1.Readonly = False
else
Me.Textbox1.Readonly = True
end if
The other thing you can do is group the fields on a page inside a "Panel" and set it's Visible property to True/False. This will effectively remove the fields from the page.
david
|
|
|
|
|
The problem is I have a GridView, with Insert, Delete and Edit options, (on TemplateFields) so I dont want these operations available for all users... just that.
|
|
|
|
|
Hi,
You can use this (as David above mentioned):
<asp:Panel runat="server" ID="pnlAdmin">
… my admin section
</asp:Panel>
<asp:Panel runat="server" ID="pnlUser">
… my common user section
</asp:Panel>
If (user is admin)
pnlAdmin.Visible = true;
else if (user is user) {
pnlUser.Visible = true;
pnlAdmin.Visible = false;
}
It’s easy but it’s not so excellent. Consider to read this article to get more info: http://ryangaraygay.com/blog/post/2008/04/PlaceHolder-and-Panel-Visibility-and-ViewState.aspx[^]
Petr Pechovic
|
|
|
|
|
Thank you very much to all
Thanks for your pacience, I'm iniciating ASP.NET and there's a lot of things to learn so sometimes I know I could be a little so please be pacience, I'm trying.
|
|
|
|
|
I have to load .txt data to sql table. Im doing this:
string path = "E:\\fich.txt";
string query;
query = "LOAD DATA INFILE '" + path + "'";
query += " INTO TABLE Filmes";
SqlCommand com = new SqlCommand(query, Conn);
string q;
q = (string)com.ExecuteScalar();
But getting error: incorrect syntax near E:\fich.txt
Any ideas? What am I doing wrong?
modified on Wednesday, November 11, 2009 3:43 PM
|
|
|
|
|
Maxdd 7 wrote: StreamReader sr = File.OpenText("E:\\fich.txt");
Why would you open the file in a stream that you never use ? I'd suspect that is locking the file. Unless the file contains single quotes ( which you can fix with a string.Replace call ), I'd be more inclined to use File.ReadAllText and just do a normal insert of that text.
Are you sure that execute scalar would return a string in this instance ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Ups, I forgot to delete that line in this post.
I really would like to use Load Data Infile, just have sintax problems, cant you help me?
|
|
|
|
|
Did you try without that line and still got the error ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Yes.
Still having incorrect syntax near 'e:\fich.txt'
|
|
|
|
|
I am reading the books online, where are you getting the documentation that makes you think this will work at all ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
There isnt documentation that makes me think this will work. I used LOAD DATA INFILE a lot of times, and it works perfectly.
The problem is, I never used with ASP.NET C# coding, but MS SQL is MS SQL I just need to make the syntax right.
http://dev.mysql.com/doc/refman/5.1/en/load-data.html[^]
|
|
|
|
|
That's documentation for MySQL. My google search turned that up, too. MS SQL is NOT My SQL. I can find NO docs for INFILE in the docs that come with SQL Server, or on the web.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
My mistake.
Probably you are right. My apologies. I was seeing that like a horse with closed eyes
I already starting working on natural solution but having another problem now:
My file is for example:
field1,field2,field3
anotherfield1,anotherfield2,anotherfield3
Just works for first line. I'm really amateur on C#, how can I do read all other lines? (having also triplicated data because the use of for instead foreach, but I will solve this problem later)
string MystringLine;
string[] MystringArray;
char[] charArray = new char[] { ',' };
FileStream MyFileStrema = new FileStream("E:\\fich1.txt", FileMode.Open);
StreamReader MyStreamReader = new StreamReader(MyFileStrema);
MystringLine = MyStreamReader.ReadLine();
MystringArray = MystringLine.Split(charArray);
int tamanho;
tamanho = MystringArray.Length;
for (int i = 0; i < tamanho; i++)
{
string query;
query = "INSERT INTO Filmes(Name, Genre, Year)";
query += " VALUES ('" + MystringArray[0] + "','" + MystringArray[1] + "','" + MystringArray[2] + "')";
SqlCommand com = new SqlCommand(query, Conn);
SqlDataReader datareader = com.ExecuteReader();
datareader.Close();
}
|
|
|
|
|
If the file is well structured, perhaps you could try issuing a BULK INSERT statement to MS SQL server?
I just hit a problem where I needed to push > 200k records in multiple tables, worked in under a couple of minutes.
10110011001111101010101000001000001101001010001010100000100000101000001000111100010110001011001011
|
|
|
|
|
How do you ignore one specific field?
Christian Graus, thank you.
|
|
|
|
|
This is too much code.
string[] datum = File.ReadAllLines("E:\\fich1.txt");
foreach(string data in datum)
{
string [] MystringArray = data.Split(new char[] {','} );
}
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I'm reading the SQL Server books online and INFILE is not in the help. Are you sure it's supported by SQL Server ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi guys,
I've just deployed a website to a live server and i've noticed something strange is happening to the URL....
/customerportal/(S(vhjbjm55k0tuec45obi3c2am))/login.aspx
What is all the random garbage its putting in the middle?? can I turn this off?
Cheers guys!
Will
|
|
|
|
|
|
|
hi
I have this error :
Compiler Error Message: CS0118: 'System.Web.Script.Services' is a 'namespace' but is used like a 'type'
I have used a webservice for searchwebservice.and for this code htat error is shown :
Line 46: public virtual System.Web.Script.Services SearchWebService {
Line 47: get {
Line 48: return ((System.Web.Script.Services)(this.GetPropertyValue("SearchWebService")));
and don't allowed me any page runing.
please help me for solving this error is very Important.thx a lot
|
|
|
|
|
The compiler is giving you a very clear message. You are trying to use System.Web.Script.Services like a type which it is actually not. It is a namespace that contains other types.
Are you trying to use any type that is defined within that namespace ?
|
|
|
|
|