Search Results - VBForums

Search:

Type: Posts; User: Serge

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    4
    Views
    719

    VS 2012 Re: creating layout using css

    Based on the picture, this should be something like this:



    <style type="text/css">
    html, body
    {
    height: 100%;
    }
    .container
  2. Re: Looking to implement live chat option on website

    Or you can use FREE SignalR library (created by 2 clever guys from Microsoft)
    http://www.asp.net/signalr

    They have a FREE (open source) CHAT (with file uploads, avatars etc)...
  3. Re: Blurring Image while Creating Image from Screen Capture

    I would recommend using ImageResizer free library (you can get it from NuGet). This library does a great job of resizing (or keeping it original size) but the quality is extremely good.
    ...
  4. Replies
    3
    Views
    545

    Re: Working with data question

    Visual Basic is not a database engine, so the question should really be: does "this particular type of database engine" have this function?
    For SQL Server, you really have 2 options.

    1. Use...
  5. Re: increase the size of file upload (Windows 2008+IIS7)

    Use <httpRuntime> tag instead to define your upload limits, e.g:

    <httpRuntime executionTimeout="183900" maxRequestLength="100000000" />
  6. Re: How to go to another view by clicking the label

    Look up model binding. Visual Studio has built-in templates for View, Edit, Create etc. Try creating a new View and and in the "VIEW CONTENT" dropbox, select LIST. VS will generate a list of items...
  7. Re: How can I display another view by clicking "@Html.displayfor()" tag in asp.net ?

    DispalyFor is used to bind your model values to certain types. Personally I think its an overkill on MS part. EditorFor is another story. If you need to include a "reusable" piece of html in your...
  8. Replies
    12
    Views
    930

    Re: Optimize very slow UPDATE

    Run your SELECT separately and take a look at the execution plan. The execution plan will give you a hint where your bottleneck is. Once you find your bottleneck, you will most likely add another...
  9. VS 2005 Re: Where are these strange characters coming from?

    These weird 3 characters are the UTF-8 BOM, which is actually discouraged by the Unicode standard. You may disable it using:



    var sw = new IO.StreamWriter(path, new...
  10. Re: Using NOT-IN, NOT EXISTS, LEFT JOIN-IS NULL clauses in Sql Select Statement

    Actually NOT IN clause is the slowest because it doesn't use indexes. Left join will not use indexes ONLY if the records don't match which should be faster because you are matching a "subset" of...
  11. Replies
    18
    Views
    1,231

    Re: Windows 7: As a 'back-up' database server?

    You can setup a mirror using SQL Management Studio (although you can also do it through T-SQL). Every db administrator absolutely MUST backup a transaction log as well as database itself. Log grows,...
  12. Replies
    150
    Views
    18,840

    Re: Alternative to VB.net ?

    I know this is a fairly old thread but I wanted to drop a few words about mobile OS'. People who don't see "mobile" apps replacing desktop don't realize that ONE of every SEVEN people on the planet...
  13. Replies
    4
    Views
    806

    Re: Logo as an .EPS file

    Instead of saving the file as JPG, have them save the file in loseless PNG. PNG supports alpha channel (transparency) and all browsers support png files. Besides, according to web design, all...
  14. Replies
    6
    Views
    599

    Re: Creating a Music Storage Network Database?

    I wouldn't recommend storing files as a FILESTREAM unless you are planning on "searching" through contents. Filestream was created to help people to have ability to search contents of files. In the...
  15. Replies
    18
    Views
    1,231

    Re: Windows 7: As a 'back-up' database server?

    I would recommend setting up a second (windows 7) sql server as a mirror instead of replication. With mirrored sql server, you will automatically be connected to the "windows7" if the main db server...
  16. Replies
    23
    Views
    1,546

    Re: About Insert Into...Select Query

    I wonder why nobody mentioned that you CANNOT get a recordset by INSERTING records into a table. You first insert records then read them into your recordset.

    This code ->


    set rs =...
  17. Re: Getting this error while trying to Update a table in SQL Server 2008?

    That means your subquery (select TestID from CalibrationTest.dbo.Main) returns NULL. Check your Main table to see if oldTestID is there.
  18. Replies
    16
    Views
    1,537

    Re: Timezones and Time Comparisons

    If you store your timeoffset in positive number but sure that they should be negative, you have 2 options:

    1. Replace timeoffset value in the DB to have correct values (i.e -4 to -10), you can run...
  19. Replies
    16
    Views
    1,537

    Re: Timezones and Time Comparisons

    Do you need to find out if your "db" time in the "allowed" time frame of the client's "local" time?
  20. Replies
    16
    Views
    1,537

    Re: Timezones and Time Comparisons

    It's a lot simpler :) Just convert your timezones to UTC, then do DateAdd function (in DB) or DateTimeVariable.AddHours(Timeoffset) to convert it to your CLIENT's time. Then check between allowed...
  21. Re: How to get the directories and paths using C#

    You can just use Application.ExecutablePath to get the directory of your application.
  22. Replies
    2
    Views
    951

    Re: client/server datetime

    If you need to have a database that will display local datetime to clients then you need to ALWAYS save the date in UTC format. Each client will have a timeoffset that you will have to calculate...
  23. Replies
    17
    Views
    889

    Re: Difference where query executes

    Indexes are also used in ORDER BY clause. Since he is using 1 column in WHERE and another in ORDER BY, he should have a composite index on both columns. When indexing column(s) you also specify...
  24. Replies
    17
    Views
    889

    Re: Difference where query executes

    How big is your table? Do you have indexes setup? According to your query, you should have a composite index on 2 fileds (APHFChkNo, APHFSeqNo desc).
  25. Re: How to find a word or number throughout the tables?

    Database is really not designed that way. All the data is separated by tables. Unless you have some cleaver UNIONs setup (making sure the shape of your table fields are the same), there is really no...
  26. Replies
    6
    Views
    877

    VS 2010 Re: mobile friendly web

    I'm not sure about WebForms but with MVC it is incredibly easy to create Mobile views, they live directly in your application. Mobile API will recognize devices and switch to mobile views instead of...
  27. Re: asp.net performance, profiling memory issues etc.

    If you don't mind spending money, Ants Profiler is the king in this area. It can pin point your memory problems, code problems (pointing to an exact line of code that takes long(er) etc). They have a...
  28. Replies
    9
    Views
    3,392

    VS 2012 Re: SignalR and VB/Asp.Net

    Weather you use VB or C# is irrelevant, you would still have to use javascript/jquery in your page. Javascript is required to communicate with the SignalR hub (if you are using hubs).
  29. Replies
    2
    Views
    1,132

    Re: use filestream or not?

    How are you going to use those files in DB? Are you going to search by file contents or just search by their filenames? If you want to search by file contents then yes, filestream makes sense. If you...
  30. Replies
    7
    Views
    1,170

    Re: EF or NHirbernate?

    If you need a Document database (NoSQL), I would chose MongoDB over RavenDB, besides MongoDB is free.
  31. Replies
    4
    Views
    861

    Re: Upsize Access DB to SQL Server 2008

    You can also do a straight through IMPORT into SQL Server. Select Access as your source. Then write a t-sql script to change each table to use identity. You can query sys.tables, loop through them...
  32. Replies
    150
    Views
    18,840

    Re: Alternative to VB.net ?

    The reason a lot of people are having a tough time moving from VB6 to .NET is because VB6 (and early) was never an object oriented language, more like Object Based. VB6 has lots of static function...
  33. VS 2012 Re: FormAuthentication Signout when browser close

    You can try to use body.onblur event and do a location.href = '/account/logoff' (but it will not work 100%). Also you can specify a small timeout in your web.config (default is 30 minutes).

    ...
  34. Replies
    7
    Views
    1,170

    Re: EF or NHirbernate?

    My personal view on EF is that if my application has many concurrent users, I would never ever use EF. It's the slowest framework there is. Although MS has optimized it a bit in 4.5, its still slow...
  35. Re: How to send JQuery function value to @html.actionlink method

    You should assign a function call in your A tag, then change location.href to your ActionResult. Do not use void. You don't have to use an HTML helper because you don't really need your URL to go...
  36. Replies
    4
    Views
    798

    Re: Searching via IN clause

    Or you can just execute a dynamic sql passing your variable with "IN" values.
  37. Re: Determine where the records of an RDL comes from?

    Run a SQL Server PROFILE and monitor your sql statements. Navigate to the page/form where you expect to have that SP to run, check back in the profiler which SP was ran.
  38. Replies
    4
    Views
    861

    Re: Upsize Access DB to SQL Server 2008

    You can accomplish it in 2 ways:

    1. Export data to SQL Server and then manually change the NUMBER field to include identity.
    2. Create a table that already defines that field as identity, enable...
  39. Replies
    14
    Views
    8,615

    Re: MVC 4 using Stored Procedure to display view

    The reason it worked with a ViewBag is because you explicitly assigned value to it.
    This code:


    var viewModel = db.stp_getEmployees(0, 1, null, "", "[Name]");
    ViewBag.Employees =...
  40. Replies
    8
    Views
    926

    Re: SQL Backup

    You cannot copy those 2 files while the database is attached and live. SQL Server has it's own format to store both database and the log in 1 file (unless you want it in .sql file as an export).
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.