Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
D

DrukenProgrammer

@DrukenProgrammer
About
Posts
16
Topics
3
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Which one is good for Performance [modified]
    D DrukenProgrammer

    Never Add dlls when you can use it from the namespace

    Visual Basic json performance question

  • Enhance this query
    D DrukenProgrammer

    Thank you Mika, it works

    Database database question

  • Enhance this query
    D DrukenProgrammer

    SELECT DATEDIFF(minute, start.Date_TimeWorked, end.Date_TimeWorked) AS ElapsedMinutes FROM TableName start, TableName end WHERE start.ID = end.ID AND start.Status = 'Ready' AND end.Status = 'Completed' Ready-Complete ok, but I want one more condition added to it, I need time between Date_Timeworked when status is Ready and Rejected?

    Database database question

  • SQL Query to find Timedifference between 2 items whose ID is same but different Status
    D DrukenProgrammer

    Hello Mika, I need your help on this query, you suggested me SELECT DATEDIFF(minute, start.Date_TimeWorked, end.Date_TimeWorked) AS ElapsedMinutes FROM TableName start, TableName end WHERE start.ID = end.ID AND start.Status = 'Ready' AND end.Status = 'Completed' Ready-Complete ok, but I want one more condition added to it, I need time between Date_Timeworked when status is Ready and Rejected?

    Database database question

  • MS Excel "Database"
    D DrukenProgrammer

    Hello, You can use excel sheet as an Database, and you can also query it like regular Access or Sql Database.you can use oledb connection to excel file from your vb.net or c# application. Use the connection string below, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XLFile.XLS; Extended Properties="Excel 8.0; HDR=No;"

    Database database help csharp com xml

  • Importing XLS file to DataTable
    D DrukenProgrammer

    Dim connect As New OleDbConnection connect.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdatabase.mdb;Persist Security Info=True" connect.Open() your code and sql here.. connect.Close()

    Visual Basic database question learning

  • Excel Data to Sql Database
    D DrukenProgrammer

    I will try this in the morning tomorrow and let you know, can you type in 2 lines of code showing it with SqlDataAdapter? I am not sure of the properties of it. Thanks Mika!

    Visual Basic database tutorial question

  • please help me how can get online help in visual studio .net 2003 and 2005?and how can get online help in msdn?
    D DrukenProgrammer

    click help on the menu bar and select how do i, or else press ctrl+F1

    Visual Studio csharp visual-studio help question

  • Importing XLS file to DataTable
    D DrukenProgrammer

    access thing should work fine for you buddy, :) :)

    Visual Basic database question learning

  • Excel Data to Sql Database
    D DrukenProgrammer

    I tried sqlbulkcopy and doesnt look good for me...

    Visual Basic database tutorial question

  • Importing XLS file to DataTable
    D DrukenProgrammer

    Hello Friend, You can use excel sheet as database it self and can retrieve data using a oledb connection to it from your application, or Manually you can do it by ->Go to access ->Create a new blank database ->Now go to File, GetExternal Data, Import ->after clicking import you you will get file dialog open, just select your excel spreadsheet in it.. rest of things you can do it easily... call this acess database easily from your application if you feel it easy. Thanks

    Visual Basic database question learning

  • Excel Data to Sql Database
    D DrukenProgrammer

    Hello Experts!! I am creating 2 datasets after retreiving infromation from excel sheet, now i want to store these datasets in a sql database. any ideas how to get this done? Thanks in Advance!!

    Visual Basic database tutorial question

  • SQL Query to find Timedifference between 2 items whose ID is same but different Status
    D DrukenProgrammer

    Well I was playing with Excel sheets to database, so I was trying something on access database. and thank you for your reply, the query looks like it works.. but I got the idea which i was looking for, thanks :) :)

    Database database question

  • SQL Query to find Timedifference between 2 items whose ID is same but different Status
    D DrukenProgrammer

    I just created a simple access database for it and tried, but it is prompting me Minute.. Entere Parameter value. ID Fname Date_TimeWorked Status 1 MyName 2006-10-25 10:00:05 Ready 1 MYName 2006-10-25 11:00:05 Completed 1 MyName 2006-10-25 10:30:00 Cancled

    Database database question

  • SQL Query to find Timedifference between 2 items whose ID is same but different Status
    D DrukenProgrammer

    I have this in one table, what is TableName start,TableName end? Thank you

    Database database question

  • SQL Query to find Timedifference between 2 items whose ID is same but different Status
    D DrukenProgrammer

    Hello Experts, I have my data like below, ID Fname Date_TimeWorked Status 1 MyName 2006-10-25 10:00:05 Ready 1 MYName 2006-10-25 11:00:05 Completed 1 MyName 2006-10-25 10:30:00 I want to know the time difference Between Ready-completed, ready-canceled. How do I query this? Its urgent. Thanks in advance!!

    Database database question
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups