newMeg

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) ------------------------------------- 1. 6016-2880537 2. 6012-3137200 so there is about 400 records in the table …

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 do is. Get the result from the sql, convert …

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 [I][B]dropdownlist [/B][/I]value like [I][B]textfield [/B][/I]value this is my front end [CODE]<tr> <td style="height: 14px;background-color:#ffd6d6;"> <asp:Label …

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 listing all in a table. Can anyone help pls. …

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 now i need to add anew header to the report,so i changed to using table which seems as …

Hi I have 3 tables in my database. 1) [B]photo[/B] 2) [B]category[/B] 3) [B]subcategory[/B] 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 subcategoryname from subcategory table where photo.subcategoryid='1' and photoid='2'. I can actually …

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 enrolled in the system. And they are grouped by the weeks in a …

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 not sure if that was the correct way doing it coz i seem to have problem …

Hi, I am not sure if my question sounds silly. I have a [B][I]table[/I][/B] that has a few columns like [B]date[/B],[B]source[/B],[B]race[/B] and [B]state[/B]. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number …

Hi,I'm new to daniweb forum. I hope someone could help. I have a table called [I][B]Caller[/B][/I] which has a field called [I][B]Area[/B][/I]. I need to select the value of the record in this field that [B]repeats the most[/B]. For example [B]Area[/B] Sel KL Sel Sel Pen KL which means i …