ASP.NET

Re: the two web services provided in the article of Sending messages in asp.net through we service ????

31-Aug-09 21:05

Wow. Why is it that this forum gets so terrible this time of day ?

What on earth makes you think that someone would find this article, work out why the code does not work for you, write new code, and send it to you ? How about you get a grip on reality. Do your own work, or pay someone to do it for you. If you have a question on an article, ask in the article. If you post in the forums, be clear what you want., and what you have tried. I am sure the code in the article works, you just don't know how to use it.

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.

Arun Jacob31-Aug-09 21:24

Arun Jacob

31-Aug-09 21:24

Christian Graus wrote:
Why is it that this forum gets so terrible this time of day ?

Arun Jacob
http://codepronet.blogspot.com/

onscroll event not fire in IE 6 with select box i need to call Javascript on onscroll event

anish27patel31-Aug-09 20:48

anish27patel

31-Aug-09 20:48

Hello All,

I have one select box in Html and i want to call javascript when scroll down event in IE 6.0
that is working with firefox as well as in IE 7.0

below call work in IE 7.0 but not workin IE 6.0

function first()
{
alert('scrolldown');
}

please help me out how can i solved above issue

Thanks in advance,

Anish Patel

How to retrieving the binary data from the database?

abglorie31-Aug-09 20:25

abglorie

31-Aug-09 20:25

Please help me.

Now I want to store the (text and image) combined to store in one field as
binary format. In later we want to retrieving the binary data from the database and display a IE page.

How it is possible?

Can you give a solution in VB.net

Thanking you,
abglorie

Re: How to retrieving the binary data from the database?

Christian Graus31-Aug-09 20:30

31-Aug-09 20:30

The only way to store two pieces of data in one field, is to combine them, for example, in a zip. If you were to store them in two fields, then it would be a lot easier. How do you do it ? With SQL, it's got to be one of the most answered questions on the web, and if you bothered to google it, you'd get far more in depth examples and answers than you'll ever get in a forum reply

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.

update database

mylogics31-Aug-09 20:20

mylogics

31-Aug-09 20:20

hii
m trying to update the column ProductID of table Product.db
i have written the following code on pageload but its giving error:
syntax error in update statement.where m i wrong.plz guide.
the code is:

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            String str2 = "Select PID From Product Where(ProductID='PID1')";
            OleDbCommand cmd = new OleDbCommand(str2, conn);
            conn.Open();
            string m = cmd.ExecuteScalar().ToString();
            m = "PID" + m;
            conn.Close();
            string str3 = "Update Product Set(ProductID='" + m + "')Where(ProductID='PID1')";
            cmd = new OleDbCommand(str3, conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            populateddl1();
            populateddl2();
        }
    }

Christian Graus31-Aug-09 20:34

31-Aug-09 20:34

Well, the brackets in your SQL are at a mininum, superfluous. Why would you change all product IDs from a known value to the new one ?

This code is an utter disaster, but I think it should work. However, I don't think this is what's blowing up. Are you sure this is the issue, because ASP.NET will only identify an 'update statement', if you try to use one of it's nasty, SQL holding controls that tries to update things for you. I think you've got the code there to use an updating control, and not the code in that control to do the update as it expects.

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.

mylogics31-Aug-09 20:47

mylogics

31-Aug-09 20:47

Actually i want to insert data in Product.db table
it has columns named:
PID: which is auto number
ProductID:Which is Primary key
and others columnss are:ProductName,ProductDescription,ProductPrice,VendorID;
i want the entries in ProductID table like when PID value is 1
ProductID value becomes PID1.in have written code for this on button click.but the Promblem occurs that when somebody deletes the rows of
the table the new PID Value doesnt start from 1.it start from last deleted value of PID.Now i want that ProductID value gets update according to the PID value.the code at button click is:

string str1 = "Select MAX(PID) From Product";
       OleDbCommand cmd = new OleDbCommand(str1, conn);
       conn.Open();
       string max= cmd.ExecuteScalar().ToString();
       if (max == "")
       {
           max = "PID" + 1;
       }
       else
       {
       int i= Convert.ToInt32(max) + 1;
       string s1=Convert.ToString(i);
       max = "PID" + s1;
       }
       conn.Close();
       string str = "Insert Into Product(ProductID,ProductName,ProductDescription,ProductPrice)Values('"+max+"','" + txtprdtname.Text + "','" + txtprdtdescrp.Text + "','" + txtprdtprice.Text + "')";
       cmd = new OleDbCommand(str, conn);
       conn.Open();
       cmd.ExecuteNonQuery();
       conn.Close();
       str = "Select * From Product";
       cmd = new OleDbCommand(str, conn);
       OleDbDataReader dr1 = null;
       conn.Open();
       dr1 = cmd.ExecuteReader();
       DropDownList2.DataSource = dr1;
       DropDownList2.DataTextField = "ProductID";
       DropDownList2.DataValueField = "ProductID";
       DropDownList2.DataBind();
       conn.Close();

so m trying to update the ProductID value AS i have default inserted
PID1 when the first row is inserted in Product table.

Coding C#31-Aug-09 20:57

Coding C#

31-Aug-09 20:57

Why you are repeating the post??

This should be your answer
http://www.codeproject.com/Messages/3179523/access.aspx

Coding C#

ExciteTemplate

mylogics31-Aug-09 21:03

mylogics

31-Aug-09 21:03

m not insertin PID in Product table but m inserting ProductID value and it is
necessary as it is primary key and cannot be null.

Christian Graus31-Aug-09 21:07

31-Aug-09 21:07

If it's the primary key, why not make it an identity ? Either way, why not write a data layer, or at least write code to a semi professional standard ?

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.

Christian Graus31-Aug-09 21:03

31-Aug-09 21:03

Well, this code is excrable. Why would you assume that any postback is a new row ? Why would you not do all your code for an insertion inside your event ? Why would you not have a data layer ?

Everything about this code is terrible. You should buy a book on ASP.NET and one on ADO.NET, and read them before writing any code. I assume no-one is paying for this code, if they are, you are a liar and a thief.

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.

Greg Chelstowski31-Aug-09 21:33

Greg Chelstowski

31-Aug-09 21:33

Christian Graus wrote:
I assume no-one is paying for this code, if they are, you are a liar and a thief.

Depends on how much they pay for it Christian ;>

var question = (_2b || !(_2b));

Christian Graus1-Sep-09 12:16

1-Sep-09 12:16

Well, I am sure they know their website would cost $12000 to write in the US, and believe that the $50 they are paying this guy will get the same result. They probably deserve each other.

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.

OnClientClick Event

KhandelwalA31-Aug-09 20:19

KhandelwalA

31-Aug-09 20:19

Is it possible to call onClientClick event on a specific condition at server side.....I mean i m entering prodcut reviews from user and it is necessary for user to login and for that i m using animation extender on click event i want to check whether logged in or not if yes then save the reviews else show animation window for login........i created animation extender at desing view ....plz guide me a bit..... Smile | :)

Re: OnClientClick Event

Christian Graus31-Aug-09 20:35

Deployment of project in asp.net

31-Aug-09 20:35

KhandelwalA wrote:
Is it possible to call onClientClick event on a specific condition at server side.....

Not without the code in question making an AJAX call to check the status on the server side, or the status on the server being passed to the client beforehand.

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.

Re: OnClientClick Event

Vimalsoft(Pty) Ltd31-Aug-09 21:24

Vimalsoft(Pty) Ltd

31-Aug-09 21:24

If you are using Sessions to check if the user is logged in then it can be done on the server side by check the null for the session. or you can still do it on the client site.

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

ritasaumya31-Aug-09 20:05

ritasaumya

31-Aug-09 20:05

Is it necessary to install asp.net on that computer on which a deploy project of asp.net is installed.and if it is a web application then how we get domain for it and a perticuler site name.

sashidhar31-Aug-09 20:11

sashidhar

31-Aug-09 20:11

Yes You Need To Install all the features of asp.net in which u r using for the local system i.e. for example u r using chart control for the chart control u have dowload chart control in local system .The same control should be daowloade at the client system

They Are So many domain providers in which u need to pay amount depending upon the capacity for example godaddy is one of the provider

Christian Graus31-Aug-09 20:15

31-Aug-09 20:15

It seems to me that you are a very poor candidate for the person to deploy ( or write ) an ASP.NET site, if you're asking this. Perhaps you need a book ?

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.

Vimalsoft(Pty) Ltd31-Aug-09 21:27

Vimalsoft(Pty) Ltd

31-Aug-09 21:27

Oops you really need to buy a Book. This is Basic knowledge. anyone who write asp.net apps must know this