|
i want to fill dataadapter with more then one table what will be the syntax for it and binding more then one datamembers(tables) with grid
$h@ma!|@
|
|
|
|
|
well leave it i did it....
$h@ma!|@
|
|
|
|
|
Dear,
I have a shopping cart. There are very customer orders. Should i delete a product? Because if i deleted a product, the Orders will not show items which bought the customer before. or Should i inactive the out of product?
Thank in advance,
Kiet
vtkiet05
|
|
|
|
|
What exactly do you want? Do want to inactivate the product which customer has already selected in that case you need to store the productID in session and don't display the same.
Apurva Kaushal
|
|
|
|
|
I have more experiences. I would to get your ideas.
Do you allow admin of site delete or inactive product?
I assume that you allow admin delte product. what does it happen if product has already in Order?
Thank in advance
vtkiet05
|
|
|
|
|
That depends on the requirement. I don't think admin should not be allowed to delete the product which is already been used in some order. But in case if the product is not supposed to be displayed to the user then it can be deactivated and thus the product will be available for your records and will not be available for the customers to select.
vtkiet05@hotmail.com wrote: I have more experiences.
Apurva Kaushal
|
|
|
|
|
I have more experiences. I would like to get your ideas.
Do you allow admin of site delete or inactive product?
I assume that you allow admin delte product. what does it happen if product has already in Order?
Thank in advance
vtkiet05
|
|
|
|
|
greetings to you all...
i need help, on how to make the use of the embeded export control on crytal report viewer in asp.net 2003..
my problem is everytime i click export, yes it give me a page to choose in which format but when im going to save or open, it does not show the correct content of the report...
someone pls i need your help very badly... sample codes or link sites is very highly appreciated thank you...
start a new beginning in every ending; thats what life for......
|
|
|
|
|
I have an ASP.NET database that lives online. I would really love to be able to run a local version and do "batch updates" or to synchronise them daily, but our developer says it's in the too hard basket?
regards
Max 
|
|
|
|
|
What do you mean by ASP.NET database?
Database name should be something like MSSQL, MySQL or etc...
|
|
|
|
|
It's an online database built using asp.net technology - cannot expand on this as that's all the developer said.
regards
Max
|
|
|
|
|
>>It's an online database built using asp.net technolog
ASP.NET is a programming language for developing Web Application on Microsoft Platform.
Okay. Anyways..
Let's say you have MSSQL database which is hosted on Live Server. You also have another database in local machine.Your goal is that you wanna do synchronization or batch-update from Local Database to Live Database. You wanna know whether it's easy to achieve this goal or not.
The answer is that it's not that difficult if you have reliable and high-speed internet connection. There are some build-in features for this purpose in the most of databases. But you have to think about security issue very seriously.
|
|
|
|
|
Hi,
I am a student and making a final project on web development, my project is on House decoration but my problem is i want my website to have its own amail id like info@housedecoration.com, so that if the company wants to send any newsletter or and reply of the request made by the user he can.
My supervisor is out of country and i need an help I am using ASP.NET and VB.NET for my project. Now plz can anyone help me in giving code that how can i implement it
Regards,
fiaz_khawaja@hotmail.com
Khawaja
|
|
|
|
|
So you want someone to write an SMTP server and give you the code? Wow.
See if your hosting provides email boxes, otherwise you need a server with MS Exchange, postfix, or some other SMTP server on it.
|
|
|
|
|
It's not about programming languages (eg: VB.NET or ASP.NET). AFAIK, you can only have that kinda Email Id when you owned this domain..
For example, I owned one domain name called "http://michaelsync.net". So, I can create any Email address like info@michaelsync.net or blabla@michaelsync.net.
So, If you are sure that you own this website "http://housedecoration", you can create the id that (info@housedecoration.com) you want.
Only thing you need to do is that you need to buy this domain. Then, you can use Google Application (http://google.com/a/) to host your email. Plus, you need to configure MX record in your domain in order to use Google Application as Email hosting..
Hope it helps.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
|
|
|
|
|
Hi
I have writing the following login screen in asp.net which uses an stored procedure, which if the login credentials equal whats returned from the select statement it should return a 1
I am having problems getting my asp page to grab the value which is returned from the stored procedure
for some reason this code sets the return value to 6, wether its right or wrong!
here is my stored procedure code
CREATE DEFINER=`jshort`@`localhost` PROCEDURE `sp_userlogin`(IN p_UserName VARCHAR(50), IN p_Password VARCHAR(50))
BEGIN
IF EXISTS(SELECT * FROM Users WHERE UserName = p_UserName AND PASSWORD = p_Password) THEN
SELECT 1;
ELSE
SELECT 0;
END IF;
END
and my code for the asp page is as follows
Sub sendData(ByVal sender As Object, ByVal e As EventArgs)
Dim litErr As New LiteralControl
'Create connection string to pass database, string holds login information to mySQL,
Dim connectionString As String
connectionString = "Server=localhost; uid=; pwd=;database=ftp1;"
'Builds .net mysql connection and passes connection string into method
Dim connection As New MySqlConnection(connectionString)
'Create mySql command string for passing query or SPROC(Stored Procedure)
Dim cmdString As New MySqlCommand
'Set Command to equal mySql connection,t so can pass SQL query
cmdString.Connection = connection
Try
'Set command string to equal SPROC
cmdString.CommandText = "sp_userlogin"
'ONLY PLACE THIS IF SPROC, sets the command to a SPROC
cmdString.CommandType = CommandType.StoredProcedure
Dim param As New MySqlParameter
param = cmdString.Parameters.Add("?p_username", MySqlDbType.VarChar)
param.Direction = ParameterDirection.Input
param.Value = txtUserName.Text
param = cmdString.Parameters.Add("?p_password", MySqlDbType.VarChar)
param.Direction = ParameterDirection.Input
param.Value = txtPassword.Text
param = cmdString.Parameters.Add("return", MySqlDbType.Int32)
param.Direction = ParameterDirection.Input
param.Value = ParameterDirection.ReturnValue
'Executes stored procedure
connection.Open()
cmdString.ExecuteNonQuery()
connection.Close()
Catch ex As Exception
'Returns error message
litErr.Text = ex.Message
MsgBox(ex.Message)
End Try
Dim validation As Object = cmdString.Parameters("return").Value
If validation = 0 Then
MsgBox("user login not valid")
Else
Response.Redirect("userhome.aspx")
End If
|
|
|
|
|
boyindie wrote: I am having problems getting my asp page to grab the value which is returned from the stored procedure
No wonder, as your procedure isn't returning any value.
As your procedure is sending a result (using a select query), you have to use ExecuteReader or ExecutScalar instead of ExecuteNonQuery to get the result.
---
single minded; short sighted; long gone;
|
|
|
|
|
can we hide (set visible = false) of an item inside the datalist? Note: this item is NOT a server control like asp:label or asp:button, etc so it does not have an ID. This item is just a link that is executed on clientside.
I would appreciate your help very much!
|
|
|
|
|
I have a gridview that contains a checkbox for a user to select his choice.
I want a code that enables user to check all and uncheck the check box at ones
I am using ASP.net and C_sharp.And this should be done with out postback.
Please advice
|
|
|
|
|
use javascript.
and performe your job in a java script function
|
|
|
|
|
javascript will solve it!!
but one thing,the id of the controls inside the gridview is different from the server controls!!!!
In the page check the id of the checkboxes with viewsource of the page!!!
Write the javascript accordingly!!!!
Hope itll help!!!
I was born dumb!!
 Programming made me laugh !!!
--sid--
|
|
|
|
|
Could you give me a code in javascript and how to incorporate in in to my ASP.net,C sharp?
I havent used Javascript before.
Thanks for your help
|
|
|
|
|
FUNCTION FUNC_NAME()
{
VAR CHK=DOCUMENT.GETELEMENTBYID("CHECK BOX NAME");
VAR COUNT="COUNT_OF_CHECKBOXES";
WHILE(COUNT>0)
{
IF(CHK.CHECKED==TRUE)
{
CHK1.CHECKED=TRUE;
}
ELSE
{
CHK1.CHECKED=FALSE;
}
}
IN THE CODE
CHECK_ALL_CHECK_BOX.ATTRIBUTES.ADD("ONCLICK","RETURN FUNC_NAME();");
HOPE IT HELPS!!!!
I was born dumb!!
Programming made me laugh !!!
--sid--
|
|
|
|
|
Thanks very much.Where will i put the code in the (.aspx) for the page together with the HTML. or somewhere else...
Please advice
Thanks for your time
|
|
|
|
|
I need to check enable and disable (using Javascript code) value of following steps:
Tools->Internet Options->Security->LocalIntranet->Custom Level->initialize and script activeX controls not marked as safe for scripting
I need to change values in registy of Enabling and Disabling using Javascript code.
If my question was not good defined plz ask.
I Love SQL
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
