|
comm.Parameters["@str1"].Value = txusername.Text;
comm.Parameters["@str2"].Value = txemail.Text;
comm.CommandText = "SELECT username,email FROM tableex WHERE username='@str1' OR email='@str2'";
comm.Connection.Open();
string strmessage = txusername.Text + " ID already exists";
string strmessage1 = " Already a registered user with this emailID";
object val = comm.ExecuteScalar();
if(val != null)
{
RegisterStartupScript("startupScript","alert('" + strmessage + "');");
}----------------------------------------------------
Now the problem is that..I would like to execute ExecuteScalar separately...First on button click my form first should check whether username exists and also sametime whether already given email is present in database...
How to check whether both exist in the database with select commands...
-
-lehya
|
|
|
|
|
comm.CommandText = "SELECT username,email FROM tableex WHERE username='" +txusername.Text +"' and email ='" + txemail.Text +"'";
|
|
|
|
|
ExecuteScalar will return an obj value..We will check it out like
object val = comm.ExecuteScalar();
if(val != null)
{
//alert message goes here
}
So, when both username and email are correct then only it will return..But i want to check for username separately and email too..someone can enter a different username for an exisiting email address in database..so i want to check either username as well email address is already present...If username is present then it will alert already username exists and email address already registered...then no need of registering once again...This is the idea behind my topic.
|
|
|
|
|
comm.CommandText = "SELECT username,email FROM tableex WHERE username='" +txusername.Text +"'; SELECT username,email FROM tableex WHERE email='" + txemail.Text +"'";
in one query i used two select command
first check for the username seperatly from email
second check for email seperatly from username
username and email are both in one table tableex
|
|
|
|
|
I'm making first, last, next, prev buttons outside of the datagrid. The labels/buttons that are assigned value/commands respectively based on which row of the datagrid is selected (which only needs to have dataBind on the first page load). Then, if the button outside the datagrid is pushed, I want it to go to the correct row of the datagrid and display a hidden cell of the datagrid in a label field. What is the correct syntax for pulling a datagrid's hidden column based on a button click outside of the datagrid? If you look at the code below, the correct row in the datagrid is highlighted when I push the next button, but I can't get the syntax right to have the lblPgTitle (outside the datagrid) display the hidden cell of the datagrid. (datagrid cell specifically is DataField="pgTitle")
sub pgNext(sender as object, e as eventArgs)
dim n as integer=cint(lblNext.text)
dgNavList.selectedIndex=n
lblPgTitle.text=dgNavList.item.cells(1).text
end sub
Tried another tack going through the onSelectedItemChanged in the datagrid
withcoe below but get an error of identifer expected.
Sub navNav(Sender as object, e as eventArgs)
Dim itemTitle As TableCell =
dgNavList.Items[dgNavList.SelectedIndex].Cells(1)
lblPgTitle.text=convert.toString(itemTitle.text)
End sub
Any ideas? There's got to be a way to reference it.
Janet
|
|
|
|
|
For anybody else out there, here's what worked - did not involve viewState and did not involve onSelectedIndexChanged by the event method of the button:
sub pgNext(sender as object, e as eventArgs)
dim n as integer=cint(lblNext.text)
dgNavList.selectedIndex=n
Dim itemTitle As TableCell = dgNavList.Items(n).Cells(1) lblPgTitle.text=convert.toString(itemTitle.text)
end sub
|
|
|
|
|
I'm looking for some code I can drop in to allow users ( a very select, authorized set of users ) to browse for files on the server and use them to dynamically create web pages.
Does anyone have a link to stand-alone code for doing this? I've found code here bundled into projects that does way more than what I need (I'd trim it down but it's hard to tell what is required and what isn't). If you have a link to something clean and concise I'd appreciate it.
- Rex
The enemy's gate is down.
Welcome to CP in your language. Post the unicode version in My CP Blog [ ^ ] now.
People who don't understand how awesome Firefox is have never used CPhog. The act of using CPhog alone doesn't make Firefox cool. It opens your eyes to the possibilities and then you start looking for other things like CPhog and your eyes are suddenly open to all sorts of useful things all through Firefox. - (Self Quote)
|
|
|
|
|
|
|
Oops  ! I misunderstood what you need, I just thought that you might be talking about something that prevents the unauthorised user from browsing (accessing) your web pages (files), sorry Rex  .
|
|
|
|
|
I have a HttpHandler that does that. However I would have to modify it for you to add the users allow to do so. Let me know and I can make it work for you.
Al
My eMail control
My Blog
|
|
|
|
|
The users can only access the entire management tool from a certain machine. If they are not on that machine nothing works. Once they are in the system no authentication is required.
I only added that part about security to avoid a bunch of people telling me I had a bad idea or whatever. I just need some code to browse for files on the server. 
- Rex
The enemy's gate is down.
Welcome to CP in your language. Post the unicode version in My CP Blog [ ^ ] now.
People who don't understand how awesome Firefox is have never used CPhog. The act of using CPhog alone doesn't make Firefox cool. It opens your eyes to the possibilities and then you start looking for other things like CPhog and your eyes are suddenly open to all sorts of useful things all through Firefox. - (Self Quote)
|
|
|
|
|
good evening.. can anybody give me an idea (or the code itself) on how to save images in my ACCESS DATABASE?? i really don't know where to start this code.. im new to ASP.NET and im really having a hard time doing it.. can anybody help me?? here's the situation..
i have a datagrid which contains the ff:
filename
image
i have displayed the filename in my datagrid properly and i have saved it in my database but the problem is that i can't display the image in my datagrid as well as i can't save the image itself to my database.. can anybody help me?? also, i need help on how to retrieve the image and display the image back to my datagrid.. please help me.. i really don't know what to do.. im in a big problem now.. i'm having a useless 2 weeks in making that yet i don't have any developments at all.. please help me.. its urgent.. please..
illa_santos2006@yahoo.com
|
|
|
|
|
|
i have seen that article but what i'm trying to do is to save the image.. i have a datagrid which contains only the filename of the image.. how will i save it to my database? how will i save the image itself from my database? tht's my problem.. i really don't have any ideas at all.. i don't know how to use the source you have given in connection to my work.. please help.. thanks..
hi..
|
|
|
|
|
Are you viray?
Well, the article shows you the way of using ADO.NET to save the image binary data to DB. Have you seen that? The article also gives you the sample code to pull the image from DB and display on the web page.
|
|
|
|
|
In an asp.net 2.0 GridView, as well as the fields from a database, there are columns for edit, select, delete.
How is it possible to enable/disable the columns such as edit or delete in the datagrid?
The reason I would like this is so that an Admin will be able to edit or delete but a normal uses will not be able to.
Thanks
|
|
|
|
|
In design mode, disable edit or delete column in your gridview. After that, in your code (in Page_Load), add these code:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && userType == UserType.Admin)
{
//Enable Delete
CommandField deleteField = new CommandField();
deleteField.ShowDeleteButton = true;
this.GridView1.Columns.Insert(0, deleteField);
//Enable Edit
CommandField editField = new CommandField();
editField.ShowEditButton = true;
this.GridView1.Columns.Insert(0,editField);
}
}
Hope this help.
|
|
|
|
|
If you use the CommandField in the GridView control, then this field supports a couple of properties, for example ShowEditButton, ShowDeleteButton which you can use to set based on the user is currently accessing the web page. In addition, you can also use the TemplateField to contain the Edit/Delete button controls, and you simply set the Visible property of the controls depending on the user type. For more information, you can see MSDN[^]MSDN.
|
|
|
|
|
How about using something like
grid.column(5).visible=false based on the logged in user ?
Thanks
|
|
|
|
|
This way is also an option if you want to hide the entire column.
|
|
|
|
|
|
Hi
I am using StreamReader to read a text file. It works fine when I used to read file from my local system.
But when I mention a Text File's URL which resides on a Web Server then it does not accept path in URI form.
Please let me know how to read text file which does not resides on local machine
Thanks
Lets work it Out.........!
|
|
|
|
|
StramReader sreader = new StramReader(Server.Mappath(@"textfile.txt"));
|
|
|
|
|
Hello Friends,
I am really sorry for this stupid question. But I really have to solve this question:
I want to execute an INSERT command via my save button on my webform.
The procedure like below:
----------------------------------------------------------
string strSQL="INSERT INTO SupplierOperations VALUES (" +
txtOrderNum.Text + ",'" + txtModelNum.Text + "','" +
TextBox1.Text + "," +
.
.
.
.
-----------------------------------------------------------
How can I convert TextBox.Text value to SMALLDATETIME
I have tried Convert.ToDateTime(TextBox1.Text)....But did not work!!
I also copied this code part and tried to run it on to Sql Server Query analyzer and did not work..
Please help...really urgent situation
-- modified at 7:45 Thursday 11th May, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
