Comments by Mcbaloo (Top 30 by date)

I made a mistake while typing and i have modified the question. Kindly try run the query with CodeID = 'F01' and Status = 'FREE' but before then, change one of the 'FO1' to NOT FREE. I won't return zero. It would still return 1

i will bind them with values from database. i think i can find a way round binding values to the dropdown once i can create the dropdown control dynamically.

The number of dropdowns is dependent on the value assigned to each user in the database

something like <%:ResolveUrl("")%> . With the above code i dropped, if i navigate to another page in a different folder from my current page, i can't return back to the previous page because of Url issue..

External table is not in the expected format.. That is the error i got after printing it out to the screen

External table is not in the expected format.. That is the error i got after printing it out to the screen

Thanks for the suggestion. i missed that part. Will run it now and type the error when done

Thanks. With the above suggestion, i was able to get that i wanted. I worked

Thanks for the comment. The role is not a key for another table. I just intend to use the roleName of the user to get a specific information from the database. Is there a way i can get the users roleNAME from the returned array of string. For the design, users can only belong to just one role.

The links were a good but what i noticed is that the query string where encryted in the .cs file. The difference in all the solutions and what i am trying to do is that my query string is placed in and not within a button where i can use Response.Redirect.....

well, i'm developing an application that might have huge data saved in the database. i also want to know which(sever side, client side or both) would be suitable for efficiency. Also might need to simple example to help continue where i am currently stucked

I don't really use Angular and can't seems to write a controller since i'm not using MVC although, i'm still a rookie. I have used dataTable with gridView but i used a table format. Since i am using a repeater and a div this time around, i need a new way round it

You're very correct. That's the plugin i'm using. I was able to send data to it but it's display it as an array rather than display each data line by line . This is how the ouptut looks like {Inpatient, Outpatient, Surgery} etc Rather than Inpatient
Outpatient
Surgery

Done that. Honestly can't think of where to begin from that's why i didnt provide any code. Was told to make use of this approach for a project

Thanks man!!!

i think i'm some assembly reference in the class i created.

Worked perfectly. Thanks

Thanks for the answer. Didnt know i couldn't. Any other way round this?

Well, if i probably said something out of line here i'm sorry. i was only trying to explain my issues. Besides i'm just a rookie seeking for help. Would be glad if you can help with where i can start from.

of course i do know that there is a difference between sql sever and Mysql. I have been using Mysql for my asp.net projects for a while. For this issue, i just got the code and database from a co-worker that just left. All i did was to change the config file to ask to provide my own sql details then run the codes. I made use a one of the registered username and password and all i got was the error which i have written above

Thanks for the swift response. Exactly what i wanted to do.

Just needed to change it to if (!String.IsNullOrEmpty(myDataRowView["yourfieldnames"].ToString()))

it worked perfectly. i had to change my status.visible = false. It worked that way with the solution you provided

There is a bit of problem tho. The control is working in opposite way. For every field that is empty or null, the Button's visibility becomes false while for those if the field contains a value(the value is a datetime), the button appears. i have tried modifying the codes but still not working.

Thanks for the help. i edited your solution to carry out what i needed. The solution you gave was perfect. Code now working perfectly. thanks