Re: I am confusing about professional - ASP.NET Discussion Boards

Imran Khan Pathan10-Jul-07 19:36

10-Jul-07 19:36

Use
gridview.PageIndex = e.NewPageIndex;

Best regard
Pathan

Plz vote if u got solution

-- modified at 1:51 Wednesday 11th July, 2007

GOD HELP THOSE WHO HELP THEMSELVES

Re: gridview paging

sidbaruah10-Jul-07 19:36

sidbaruah

10-Jul-07 19:36

ypki wrote:
i need the gridview with out binding datasource

wat do you mean by that?? Is it that you want to bind the grid with coding???

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

fill dataadpter with more then one table

$h@ma!|@10-Jul-07 18:16

$h@ma!|@

10-Jul-07 18:16

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!|@

Re: fill dataadpter with more then one table

$h@ma!|@10-Jul-07 19:02

$h@ma!|@

10-Jul-07 19:02

well leave it i did it....

$h@ma!|@

I am confusing about professional

mangrovecm10-Jul-07 18:11

mangrovecm

10-Jul-07 18:11

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

Re: I am confusing about professional

_AK_10-Jul-07 18:50

_AK_

10-Jul-07 18:50

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

Re: I am confusing about professional

mangrovecm10-Jul-07 21:11

mangrovecm

10-Jul-07 21:11

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

Re: I am confusing about professional

_AK_10-Jul-07 21:52

_AK_

10-Jul-07 21:52

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

Re: I am confusing about professional

mangrovecm10-Jul-07 21:11

mangrovecm

10-Jul-07 21:11

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

using embeded crystal in asp.net 2003..

moomoooomoo10-Jul-07 16:32

moomoooomoo

10-Jul-07 16:32

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......

asp.net database

mrwatson5410-Jul-07 11:25

mrwatson54

10-Jul-07 11:25

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? Cry | :((

regards
Max Smile | :)

Re: asp.net database

Michael Sync10-Jul-07 19:50

Michael Sync

10-Jul-07 19:50

What do you mean by ASP.NET database?
Database name should be something like MSSQL, MySQL or etc...

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: asp.net database

mrwatson5410-Jul-07 22:34

mrwatson54

10-Jul-07 22:34

It's an online database built using asp.net technology - cannot expand on this as that's all the developer said.

regards
Max Smile | :)

Re: asp.net database

Michael Sync10-Jul-07 22:46

Michael Sync

10-Jul-07 22:46

>>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.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

set an id of my website

miss khawaja10-Jul-07 9:34

miss khawaja

10-Jul-07 9:34

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 Frown | :(

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

Re: set an id of my website

eggsovereasy10-Jul-07 11:05

eggsovereasy

10-Jul-07 11:05

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.

Re: set an id of my website

Michael Sync10-Jul-07 19:45

Michael Sync

10-Jul-07 19:45

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)

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

return value from stored procedure problem

boyindie10-Jul-07 9:22

boyindie

10-Jul-07 9:22

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

Re: return value from stored procedure problem

Guffa10-Jul-07 9:54

Guffa

10-Jul-07 9:54

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;

Datalist control

DonVBguy10-Jul-07 9:08

DonVBguy

10-Jul-07 9:08

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!

CheckAll/Uncheck all

kibromg10-Jul-07 7:59

kibromg

10-Jul-07 7:59

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

Re: CheckAll/Uncheck all

sam#10-Jul-07 8:36

sam#

10-Jul-07 8:36

use javascript.
and performe your job in a java script function

Re: CheckAll/Uncheck all

sidbaruah10-Jul-07 19:30

sidbaruah

10-Jul-07 19:30

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!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Re: CheckAll/Uncheck all

kibromg10-Jul-07 23:36

kibromg

10-Jul-07 23:36

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

Re: CheckAll/Uncheck all

sidbaruah10-Jul-07 23:43

sidbaruah

10-Jul-07 23:43

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!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.