Search results for query: *

Hello, I'm a .NET programmer helping someone with PDF creation in PB 10. We ran into a roadblock using the GhostScript technique of PDF writing as we are not allowed to have kernel-mode drivers on our server (it is not an option on this production server ie because of company policy). I don't...

Sirius - I have a local DB, but I want the local DB's data to be queryable by the public. I could expose the local DB to the internet, but I do not want to and I'm also trying to figure out a way to do this if the client has a dial-up connection. I'm trying to find out the best practice for...

The reason this discussion came up is because my bank's site has the following security blurb: <------ Network Security The second facet of our security is protection of the Credit Union's internal network and member information from access by unauthorized internet users. (Host to server is...

What do you do if you have a desktop app that uses a locally-housed DB on a local server, but you also have a website that would also like to use the local DB's data? A good example is a scheduling application: Your desktop app handles scheduling and you'd like customers to be able to schedule...

Vary helpfull i'm looking to activex dll for guptura? C++ is not on my computer ill try look for a programer software. good too know visual basics net won"t go. much thank!

mrdenny - That's a good idea. My question would be, would you do it in an SP? If you did, how do you get the values to the stored proc? For instance, I can create a CSV list from an array, etc, but I'm not sure how to do it. I don't need actual code, just some concepts.. Here's one idea...

I've searched but have been unable to find info on this operation: I have data that looks like this: Row_ID | Value --------------- 10 | 8273 15 | 211 23 | 214 28 | 4432 31 | 232 I need to update a table with this info. where the Row_Id corresponds to a Row_ID in table...

I have some files stored in folders. I have the path & file name in a DB. I'd like to let people download the files (each record has one or more files) in the DB / folder as a ZIP. Does anyone recommend a good ZIP component? I'm messing with SharpZipLib now...

Oh boy - This is the second time I'd figured out how to do something right after I'd posted it.. I'd remembered that if I wanted to add HTML or text to a TableCell, I'd do myCell.Controls.Add(New LiteralControl("MY TEXT")) Ahh - So that works for the page also... So to do what I wanted to do...

Hello - I have 2 tables that I creat @ run time in my application and I make them appear by doing Page.Controls.Add(myTable) This works great, but since I am adding 2 tables, I am unable to get a <BR> (line break) between them. So, by adding them at runtime I'm unable to format the space...

Got it.. For x = 0 To (dr.FieldCount - 1) (insert code here) Next The field count messed me up for a second. Thanks anyways, all!

Hello - I'm trying to figure out how to step through the DataReader when building a "confirmation page" for my app. Basically - I'd like to see code to Response.Write the Column Name and the Value of that column.. This record set is only one record, with about 8 columns. In long hand, it...

I'm sorry.. I searched improperly for what I was looking for.. I found it.. http://www.tek-tips.com/viewthread.cfm?qid=747849 Or like: SELECT (CASE WHEN MyField = 1 'YES' ELSE 'NO') as MyOutput THanks though for the board!!

Hello - Is there an easy way to do a T-SQL SELECT statement and have the results return the word "YES" for 1 and "NO" for 0 for a BIT datatype column? REPLACE can do one part of it, I think.. But, I'm not sure of how to do it for YES and NO. Sample data: ------------------ 1 0 0 1 0 Sample...

I just did a comp-up in access then pshopped it to make it look like the sample and output data. Used the [IMG] tag of TGML to actually place them in post.

Thank you! Wouldn't have known about that function!! Going to try it in my solution now. Thanks for the prompt response!

I have 2 columns: Title_A and Title_B In each row, Title_A or Title_B may be NULL, but both columns will never have NULL on the same row. How can I return a singular "Title" column in a SQL Server 2K Stored Procedure? Sample of table data: Sample of desired output: Proper normalization...

PS - Custom, I just Reread your post more clearly - The connection MUST be open for the datareader to work and killing the datareader will KILL any connection object used to open it. I totally understand now. I think there's another Data Something that can work with a closed connection and...

Custom24: Thanks for you info - Yes - I was able to get my thing working after doing what you said. Dim dr As SqlDataReader = FillForm(Customer_Id,Request.QueryString("action")) Do While dr.Read Response.Write(dr.Item("Title")) Loop That worked to get me the stuff I need.. Here's...

Thanks Veep - I actually found exactly what I was looking for: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp Microsoft Patterns and Practices: Data Access This is what I have been looking for but didn't really look for "patterns". That MSDN section...