Can someone help me??

How to retrive image from MySQL(not MS_SQL) and show into my <asp:Image> control using c#

Lets said my table on have a field as following:

"SELECT pic FROM image"
...

Problem solved !!

I just need to change the "@pic" to "?" ...

OdbcCommand cmd = new OdbcCommand("INSERT INTO picture " + "(Picture) VALUES (@pic)", cnn);

and
...

Here is my code:


override protected void OnInit(EventArgs e)
{

InitializeComponent();
base.OnInit(e);
}

On my attachment have the table

I want to know how to make the comparison like:

DUE_DATE_TIME + DURATION(in hours) <= OVER_DUE_DATE_TIME

If the above statement is wrong then must prompt out...

Hi sbv,

Actually my code is something as below:


<asp:TemplateField HeaderText="AREA_BUCKET" SortExpression="AREA_BUCKET">
<EditItemTemplate>
...

Hi sbv,

this seem not like c# code, can you show in c# !!
Thanks

Hi sbv,

I had problem again, can you show me the code in the step 1??

Thanks

Hi ericstenson,

Can you how me the code in C# instead of vb??

and my db format for this field is DateTime so cannot convert STRING to DateTime format.

what should I do

Thanks

I'm having a problem to inserting date/time in my database..

In my database have ONE column that consists of DATE and TIME

I want use separate dropdownlist for the HOUR, MINUTE, SECOND and I...

Thanks all

I had solve my problem. Yours are right.
Thats all is my mistake


Thanks very very much

Hi sbv,

Can you explain more clearly about it because I still confuse about it.

-I retrieve the tbl_abc from sqlDatabase
-I using SqlDataSource(is it needed??)
-I using <asp:Label> for the...

Hi,

-May I know that this code only can retrieve the selected value in DropDown to the Label right???

-Actually is my misunderstanding or yours not clear about my requirement??

-the data...

Hi sbv,

If I follow the your statement then I only can get the drop down list value and add into the label but what I want is not this.

I want is like this that I mentioned above:
-If I choose...

My problem is I want to add in a value to a LABEL based on selected value in the DropDownList !!


Example:

tbl_abc

ID Sequence Name...

Hi,

May I know how to make the following comparison:

A(Date/Time) + B(Integer, in HOUR) <= C.



if after A+B is next day of the date A then is should be increase one day then only compare...

I want the Duration in Hours.

If the DUE_DATE_TIME(the time) + the DURATION is next day then the DUE_DATE_TIME should be increase one day and then compare to the OVER_DUE_DATE_TIME.

Example:

I have a table name A and have three column name OVER_DUE_DATE_TIME(date/time), DUE_DATE_TIME(date/time) and DURATION(Integer, in hours).

I need to do this validation: DUE_DATE_TIME +...