Hi,

I'm stuck in a gridview operation. Baiscally i have an sql that select filesize from database. I need to convert the file ti Giga byte. So i cant find a method to do it in sql, what i plan to...

Hi Kusno, Thanks for the reply,
Actually i did solve it by rebinding GridView using SQLDataSource again at the page load. Then it solved my problem. Thank you very much

Please can anyone help me out here. Thank you.:( :(

Hi,

Im new to .net programming,I have been stuck with a dynamic search form. I have a dropdownlist and a text box. The dropdownlist actually hold the filed name where when i search is "where...

Hi, Thanks for the reply. I did an inner join and i'm still not getting the result. Nothing is queried out because of the c.CreatedBy = '2418' which doesnt exist for the identifier...

Hi,
I need help on this sql. I have a table a and b and i need to select where a.id=b.id and b.mid=1 and few hardcoded a.id which does't exist in table b. i used left outer join but its still...

Hi I have 3 tables in my database.
1) photo
2) category
3) subcategory

in my photo table i save my subcategoryid which is tied to the category table.

What i need to do is get the all the...

Hi David,

Thanks for the reply. But I was wondering why do we use date part as datepart function is to get the date different either in weeks or days or months right?

From the sql u just...

Hi David,

Still Stuck on the SQl. Let me explain, I have table fields called doctor d,clinic c,pmr pmr,patient p,course cor
Patient contains patientID,which is a primary key and it appears as...

Hi David,

Im not sure if i got the last part right. For my report Could u explain how i can do it ..i mean creating the new table. Based on wat i see, do i have to create two fields in the new...

Hi,
I'm a bit stuck. I've been breaking my head quite long figuring how to do this.
I need to generate areport that is grouped by week.

i need to display total number of patients who are...

Hi hollystyles ,

you are always a great help. sorry for the late reply.the query example u said works great and solved my problem.

thanks again and sorry for th elate response.

Hi,

I have a table in which there is a field for mobile no. Currently the data in the field has been entered with a dash(-) after the code.

eg-

MobileNo (this is the field name)...

Hi, thanks a lot for the reply. But i dont actually get wat u mean. I really need to solve this if by at least changing the sql and not changing the table structure as i will need to change my codes...

Hi,

I have two tables that stores product details which is carinfo and products.I did it in 2 separate tables as the products are by diffrent category and therefore the fields are different. I'm...

Hi im developing an asp.net report using vb language. I created the report previously using datagrid,which works well when i click the export button. It downloads the datagrid to excel format. But...

Hi Hollystyles,

You have been a great help. Thanx alot. I'll sign up to the forum you suggested. Can u explain about the example you gave in the last post. I dont really understand the example...

Hi hollystyles (http://www.daniweb.com/techtalkforums/member29709.html),

Thanx for the reply.it works great.But I have some columns in the table where the values are unpredictable,which means...

Hi,

I am not sure if my question sounds silly. I have a table that has a few columns like date,source,race and state. I need to generate a report. The table stores the details of callers...

Hi hollystyles,

thanx for the great help.It works.

Hi,I'm new to daniweb forum. I hope someone could help.

I have a table called Caller which has a field called Area. I need to select the value of the record in this field that repeats the most....