I have my select staement which produce Opening stock/value for the upcoming months.. what i need here is it would automatic execute my mssql command everymonth last dare @12
View 6 RepliesI am trying to insert a new record via a SPROC in sql . In my date columns I check for nulls being passed to the SPROC this way Dim BirthDateParam As SqlParameter = New SqlParameter("@DOB", SqlDbType.DateTime) If estateRec.BirthDate Is Nothing Then BirthDateParam.Value = DBNull.Value InsertCommand.Parameters.Add(BirthDateParam) Else BirthDateParam.Value = estateRec.BirthDate InsertCommand.Parameters.Add(BirthDateParam) End If But I am getting an overflow error message about dates, SQL Stack Overflow Isn't this way correct
View 2 RepliesI want to click on a date in the calendar and use that date in an insert command.
I have inserted a Calendar in Visual Web Developer and cannot figure out how to get the date so i can use it when inserting a new entry in my table... how do i "catch" the date and how to insert it as date.
I have the insert command working with dummy fields...
I am using a gridview in (Visual Studio 2010) to display records from a SQL 2005 database. I can filter my date range successfully but it does not include the end date. I have tried using the between expression as well as >= <= to return the dates from the beginning and end dates. I have search and found that this is due to the time portion of my datstamp in the SQL column (02/19/11 01:03:36 PM) where I am filtering by short date (02/19/11); therefore leaving the end date out of the records returned.
Now the solution I have read is to add a day onto the endate like this: 02/19/11 + 1 but I get a conversion error returned from the SQL server. I have tried to use convert in this matter to convert the textbox.text in the selectcommand to datetime 101 formats to overcome this but I must still be missing something because it comes back with another SQL error unable to convert nvchar to datetime.
In the end I would like to have my two textboxes StartDate - EndDate filter the dateStamp column in my Transactions table and if both textboxes have the same date return records for that date only and include the EndDate if the range is more than one day.
I have tried many different variations of the below code using $,#,+ and & symbols to encapsulate the EndDate controlparameter to add a day to the EndDate and have failed at all attempts.
This my markup that filters fine excluding the EndDate;
[Code]....
I have tried using this as well and work excluding the EndDate:
[Code]....
selectcommand="Select * from Transactions where DateStamp Between @StartDate and @EndDate">
How to create Jobs, I am using SQL 2005, i need a query which should get current date and compare current date with date in table and Send Email according to Job scheduled.
View 4 Replies How to get the date at which a record is created in SQL?..i.e, if i add a record to a database table db1 at 8/10/2010 11:30, I want to get the datetime, i.e 8/10/2010 11:30..;.Also let me know how to compare datetime values..
if(8/10/2010 11:30 >8/10/2010 10:30) will work or not?
i have the following query.
[code]....
but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.
hitdate hitsperday
2010-10-07 2
2010-10-06 58
2010-10-04 1645
2010-10-03 1192
what i need to return is this:
hitdate hitsperday
2010-10-08 0
2010-10-07 2
2010-10-06 58
2010-10-05 0
2010-10-04 1645
2010-10-03 1192
I am storing date data in sql server as varchar but I want to make comaparisons on this field in where clause- like this field from 2 days before or after etc
View 3 RepliesI have a start date and end date parameters.
i need to throw an error when the user enter a ' start date' which is more than 'end date' and an 'end date' which is less than a 'start date' .
the error should be displayed whent he user click the run button
This is House_info table in database
Id
Name
Expiredate
date
in admin.aspx page I have register button
I want when users click on button In Table in Expiredate column insert current date+1year
I mean if today is 2013-1-3Â in Expiredate column insert 2014-1-3
for this what should I wrote in SP?
I want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?
View 2 RepliesI am working with odbcCommand class, in one case I got error that QueryTimeout Expired. Even though this SP is taking only 3-4 secs in DB to execute these specific values, When I set the CommandTimeout=0, then it worked fine.
1)Is it necessary to always use this property while working with Command Class.
2)If it is not suggested to use, but still if I use it then how it will impact the performance.
Below is my code sample.
OdbcConnection conObj;
OdbcCommand cmdObj;
OdbcDataAdapter daObj = new OdbcDataAdapter();
public DataTable GetIFAContractNoteData(string RecipientIDIFACN, DateTime BatchDateIFACN, int TransmittalReportIDIFACN) {
conObj = new OdbcConnection(GlobalVariables.strDsnName + ";" + GlobalVariables.strDsnDataBase + ";" + GlobalVariables.strDsnUserID + ";" + GlobalVariables.strDsnPassword);
[code]....
[Code]....
Using above code, I got succeeded in printing PDF file through command line. But it runs the Acrobat Reader and opens Save dialog box.
In my case, I want to suppress Save dialog box and save the file on other location using c# coding. I mean I want to save a PDF file behind the scene.
How can i connect add all the below in one SQL command SEP + WPP ...
SFP
SFP.Category + SFP.Purpose + SFP.Question + SFP.Resources
WPP
WPP.InvestigativeQuestion + WPP.Hypothesis + WPP.StatementOnHypothesis + WPP.Procedures + WPP.IdentifyTheControl + WPP.IdentifyTheVariable + WPP.SampleData + WPP.BrainstormIdeas
NoteBook
SUM(NoteBook.OnTime + NoteBook.Organization + NoteBook.QuestionPurposeStatementHypothesis + NoteBook.MaterialsMethodSketchesCompleteness + NoteBook.DailyLogCompleteness + NoteBook.DataChartsCompleteness + NoteBook.Graphs + NoteBook.ValueOfResearch + NoteBook.OriginalityOfIdea + NoteBook.Conclusions) * 15 / 100
ScientificPaper
SUM(ScientificPaper.OnTime + ScientificPaper.TableOfContents + ScientificPaper.InvestigativeQuestion + ScientificPaper.CompletenessOfMaterials + ScientificPaper.ResultsTablesGraphs + ScientificPaper.DataChartsCompleteness + ScientificPaper.ConclusionsSummary + ScientificPaper.OriginalityOfIdea + ScientificPaper.Acknowledgements) * 30 / 100
DisplayGrade
SUM(DisplayGrade.Judge1 + DisplayGrade.Judge2 + DisplayGrade.Judge3 + DisplayGrade.Judge4 + DisplayGrade.Judge5 + DisplayGrade.Judge6) / 6 * 0.25
RubricPerJudge
SUM(RubricPerJudge.Judge1 + RubricPerJudge.Judge2 + RubricPerJudge.Judge3 + RubricPerJudge.Judge4 + RubricPerJudge.Judge5 + RubricPerJudge.Judge6) / 6
I cannot find where the sqlcmd is? i just want the prompt.
View 1 Replies My stored proc execution runs perfectly on local developement environment, but in QA environment it just returns an error after 5 min.s(My stored proc. takes arround 15 min.s to complete), when i run my Stored proc from query analyzer it runs perfectly in 15 min.s.
I tried to debug the code by pointing my local code to QA database, but that didn't give any error and ran perfectly. So i suspect there is something like commandtimeout happening in QA environment. Then i went on to check code at QA environment, it passes commandtimeout = 0 to the command object which means infinite.
I have this gridview, that works perfectly when running in local computer. Platform is VWD 2010 - Sql Server
[code]....
Browser fire the confirmation question, but after hittting YES, nothing happens.
It works fine in my computer, nothing happens in the hosting server.
Is it possible to have multiple conditions in an SQL select command. I have an SQL Table with the follwing filds.
Image1
Image1Approved
Image2
Image2Approved
Etc
Image1 is a varchar(50) and stroes the picture name. Image1Approved is a tinyint (0 = Pending, 1 = Declined & 2 = Approved) I am using the following to query the SQL database.
SelectCommand="SELECT Image1, Image1Approved, Image2, Image2Approved, Image3, Image3Approved FROM UserProfiles WHERE (UserId = @UserId)"
The part that I am stuck on is only returning the images that have there associated approved condition set. I know how to do this with a seperate select command for each image but can this be done for all image files in one statement.
using System.Data.SqlClient;
using System.Data;
public static SqlDataReader GetCategories()
{
SqlDataReader reader;
string sql = "SELECT * FROM CATEGORIES";
using (SqlCommand command = new SqlCommand(sql, ConnectionManager.GetConnection())); //possible //mistaken empty statement
{
reader = command.ExecuteReader(CommandBehavior.SingleResult | CommandBehavior.CloseConnection);
}
}
I am getting a couple of errors in this code that I can't figure out. One is regarding the empty statment next to the comments above and the other one is regarding reader=command, it says command does not exist in the current context.
I have a table that is not getting updated. My insert command is working fine. Here is the update code from business logic area and stored prodecure. The SP works fine when I execute it from sql mgmt studio and updates the table:
[Code]....
I've recently started working in ASP.NET and RDBMS.I'm making a test form where I can do basic add,update,delete operations.I'm using OracleDataClient to do the DB operations.I was able to populate a listbox using OracleDataAdapter.
Now after clicking on update button,I intend to Update in DB.I've Dataadapter with it's update property.But the update query is not happening.The examples I saw over net all have Select command before Update.Is it actually like that or am I missing some point.
How does Oracle DataClient work with Insert,Update,Delete Commands.
[Code]....
why I am not getting the desired result. I want to retrieve records in DataReader and still I am not getting any result.
I'm developing a web application in asp.net using C# and need to access the command prompt of the server computer.
After accessing it I need to run a "ABC.bat" file in the server computer which is in folder "E:Test".
The absolute path of the server is "\MyServer"
PS: I need to run the ABC.bat file on the server machine as the bat file runs couple of more applications which are licensed to that server machine.
Is there anyways to launch Cassini web server from a command line? The exe appears to be in this path, C:Program Files (x86)Common Filesmicrosoft sharedDevServer10.0
View 1 Repliesasp.net 2.0 MSVS2005 vb.net
I do this..I pull up a SQL multi view SELECT query (thats a stored proc with 3 SELECT statements in it).
[Code]....
I then run thru dr and dr.nextresult and populate controls with it.
The above is fast.
QUESTION : Can I cache at the SQLcommand level in the above code ?
NOTE: I can NOT use SQL dependency as my query doesnt fit the rules