[microsoft:sql-server] Forum Topics

This is my code: Add_click [code] dbcmd = New SqlCommand("INSERT INTO dms(name, dept) VALUES (@name, @dept)", connection) 'Add Database Parameters dbcmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name.Text dbcmd.Parameters.Add("@dept", SqlDbType.VarChar).Value = dept.Text [/code] But I want to add the data in gridview [code] Dim record_series As String = DirectCast(GridView1.FindControl("Record_Series_Number"), Label).Text Dim doc_name As String …

Hi Everybody, I have a desktop application designed (VB.NET 2008 and SQL2005) which consists of user login and some access level for the users. The user class which i have classified are : 1. Administrator 2. Operator 3. Report User This user has got a few access in my application. …

Hi all, I hope anyone can give some pieces of advice on the following matter. I have developped internal server with a few DB in our company. Recently the system has been introduced to the all users, which willl acccess the data via Business intelijence SW (Business Objects in p[articular). …

Hi, Please me to do this. I have one Webapplication. its build on vs 2010 and back-end is MsSql server 2008 and create setup for installing in another Standalone PC. The Problem is I can't run Application without installing Vs? is there any solution? can I run setup without install …

hello all i am new to C# i want to enter a datetime value in table but when i give datetime datatype in insert statement it is not displaying any error while executing but when i see the inserted value in my table it shows 1900/01/01 i want to enter …

I have a SQL query where I need to pull email addresses if there is one associated with that row in my table. Depending on how many email addresses are returned could be 1 all the way up to 5 I need to send an email to each of those …

I am using VS2010 and SQL Server 2005. I have a query to search between dates. Depending on which date I select on the datetimepicker I get no results or limited results, but mostly not all the dates between the two dates I specify. For example, if i select 10/9/2010 …

hi, i'm getting error of [COLOR="Red"]data source object is invalid[/COLOR] when i try to load a transaction report from sql database. [COLOR="Red"]Error 4 Overload resolution failed because no accessible 'Fill' can be called with these arguments: 'Public Function Fill(startRecord As Integer, maxRecords As Integer, ParamArray dataTables() As System.Data.DataTable) As Integer': …

I'm trying to compile some code in Visual C# Express. Would someone please have a gander and help me out by giving me a brife explanation of why I'm getting an error "oleDbDataAdapter is not in the current context"? From my understanding (which must be wrong) oleDbDataAdapter is part of …

I'm rather new to this and really need some help. I know I'm close but I just can't get this to work. My omonth table has only 2 fields, id and month. I want a drop down to lists the months and I want the selected value to become a …

Hello...... i want to select from the drop down list ID then all information connecting to the ID will appear in the report , i wrote this SQL statement but only information related to the first ID appear each time when i select different ID from the drop down list …

I used VB a long time.. i never manipulate a Class.. I just want to know what is the concept in using a class.. because i already graduated in an IT course, and then im eventually working with VB with a back-end SQL Server 2000. when i look at their …

"SELECT * FROM customer where customer_ID LIKE '%" & Trim(TextBox1.Text) & "%'" good day everyone, im having a problem with querrying i want to query from the field customer_ID,customer_Name,customer_MI,customerLname and textbox 1, 2, 3 and 4 i already tried select * from customer where customer id like textbox1.text or customer_name …

[CODE]Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim conn As New SqlConnection Dim cmd As SqlCommand Dim dp As New SqlDataAdapter Dim ds As New DataSet Dim i As Integer Dim str As String = "UPDATE aspnet_Membership SET aspnet_Membership.Email='" & Email.Text & "' WHERE UserId='" …

Hi Friends. I have an project with vs2005 and sqlserver2005.There is a page contain a combobox , a text box and two button.The combox items are my cost list that maybe thems count increase by user.how can I manage it? more about it: if person clicks the add button we …

This is the error when i try to execute my code "Procedure or function 'Get Customer data' expects parameter '@Name', which was not supplied." [CODE]objCommand.CommandType = CommandType.StoredProcedure objCommand.CommandText = "GetCustomerData" Dim ObjParam1 As New SqlParameter("@Name", SqlDbType.VarChar, 2000) ObjParam1.Value = ID.ToString() Dim da As New SqlDataAdapter(objCommand) Dim dt As New DataTable …

hi i need an vb.net program for access database, in an sql query for append (single column) .txt file into existing .mdb table , i used this code but is not working [CODE] Pth2 = My.Application.Info.DirectoryPath STTConn2.ConnectionString = "Provider=Microsoft.jet.oledb.4.0; Data Source=" & Pth2 & "\LugatWordsOk.mdb; User Id=admin; Password=;" STTSql2 = …

CREATE procedure [dbo].[date_sp_new] ( @fromdate as varchar(50), @todate as varchar(50) ) AS declare @date1 as datetime declare @date2 as datetime select @date1 = convert(varchar(50), @fromdate,120) select @date2 = convert(varchar(50), @todate,120) begin if (@date1 = '' or @date2 = '') select * from mkt_contact else if(@date1 != ''and @date2 = '') …

pls,i need help in inserting a date from a text field using java, to mssql database. i am getting incorrect date for example when i insert 13/3/2010,i am getting the date 1/3/2011.i want a solution,i've searched a lot but useless.the problem is in mssql not java,so what i can do …

pls,i need help in inserting a date from a text field using java, to mssql database. i am getting incorrect date for example when i insert 13/3/2010,i am getting the date 1/3/2011.i want a solution,i've searched a lot but useless. the code is: [CODE] try{ java.util.Date d; String s; d …

Hi 1) I am using C# window application in that i have use one group box and in that i have put text boxes my first i visible and reset i have enabled to false i have insert one button in group box. [COLOR="Green"] I want that on the click …

hi, below is my code. i want to get grand total based on boothID but i seems my code does not functioning. I still get same GRANDTOTAL even i have different BoothId in the sql. How do i do that. Do i need to add something in my code. PLEASE …

hi.. How can we add list of items to Combo box which are in DB(SQL SERVER). is it necessary to write a STORED PROCEDURE

I can't figure out what I'm doing wrong here. I want to allow the user to name the database on their own. Can you use parameters in a situation where the command is simple like: [CODE=SQL]CREATE DATABASE @DatabaseName[/CODE] I've been trying forever and it just keeps creating a database called …

Hi, please help me to know how to backup and Restore the Database. I am newer in backup topics. please help me. thanks jack

Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND CityId IN (23,45,85,86)' …

I am using BIDS 2005 to write a report. The report takes a begin date, end date, and the parameter for salesperson names are filled by a query based on the date range entered. The report generates the stats for the salesperson when one is selected individually great. My task …

hi, I am a SQL Guy, I like reading SQL Server books, Please suggest me some books which teaches advanced topics in SQL Server not just teaching the known things.

pls let me know that do sql 2005 edition get installed on laptop with windows7 ultimate(32-bit),i3 processor??? reply early

1.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.Description,pos_cashreceiptpayment.ReceiptNo,SUM(TotalCost) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.Description LIKE 'Raw%' AND pos_cashreceiptdetail.LocationCode = pos_cashreceiptpayment.LocationCode AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' GROUP BY pos_cashreceiptpayment.ReceiptDate,pos_cashreceiptdetail.ReceiptNo[/CODE] 2.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.ShortDescription,pos_cashreceiptpayment.ReceiptNo,SUM(Totalprice) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.ShortDescription LIKE 'Food Stall%' AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptNo = pos_cashreceiptpayment.ReceiptNo AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' …

[CODE]using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string connectionString; connectionString =("Data Source=INTRANETSERVER1;User ID=sa;Initial Catalog=HrData"); SqlConnection myConnection = new SqlConnection(connectionString); SqlDataAdapter …

i have button add and the coding, but everytime 1 click the button, a messagebox said that syntax error INSERT INTO. all database column name and the textbox name is true. i checked many times. this is my code [CODE] Try 'add data inside the database con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data …

hi.... i've created one ssrs report it works good im my system.. i.e http://localhost/reportserver$sqlexpress but how should i execute in different system... if i enter the system name then it is showing page cannot be displayed.. i.e http://sys1/reportserver$sqlexspress (page cannot be found) please help me..

hi, how do i get latest transaction from sql database. All the records is saved in sql database and i use different application to grab the data from sql base on transaction. I use SELECT statement but i don't know how to make it unique variable/ID. 1st user might have …

I have been following this tutorial ([URL=http://msdn2.microsoft.com/en-us/library/ms233763(vs.80).aspx]http://msdn2.microsoft.com/en-us/library/ms233763(vs.80).aspx[/URL] ) and so far everything has gone well. I am running Visual Studio 2005 and SQL Server 2005. I can run queries just fine. However, when I try to update (insert a new row), my Customers table in my SampleDatabaseDataSet will not commit …

hi... to all the following code is to deploy the reports programatically... i've one problem .. by using the filestream it takes more time to load the reports.. hence burden on server.. is there any option or any solution to make less burden on server.... one more thing the records …

Found myself here while researching SQL triggers and their syntax. The forums seem to be a very helpful resource. Hopefully, I'll be able to contribute as much as I benefit from others. -Bill

Dear Friends, I devloped a web application in ASP.NET/ Sql Server 2008 and tested in development pc. It is working fine. But when it is deployed in Server running windows 2003/ IIS 6/ Sql Server 2005 and 2008, it is giving access error. "Error 26. Cannot access the database". I …

GOOD DAY! I am working with a project and i need to have a back up database feature. how can i do this? I've read a lot of forums and they suggest to use SQLDMO but when i test their codes its either generating error or does not create the …

hi... to all i've created ssrs reports local following is my code.. public void source(string tbname,string Rptname) { ReportViewer1.Visible = true; string myQuery = "select * from " + tbname; SqlConnection myConnection = new SqlConnection(ConnectionString); SqlCommand myCommand = new SqlCommand(myQuery, myConnection); myCommand.Connection.Open(); SqlDataAdapter da = new SqlDataAdapter(myCommand); DataSet dt = …

Hi all, I want to retrieve some data from the database and return as a datatable. However, it does not work. I tried both methods that I could find in the Internet, but it's not working. May I know what have I done wrong? The datatable is returned as null …

I'm really having a hard time to get the values of the checkedlistbox. Here it is. I will explain this. I have a database named "LibraryDB" which has three tables. Table 1: Book Columns: Book_ID, Book_Title, Call_Number, Accession_Number Table 2: Author Columns: Author_ID, Author_Name Table 3: Book_Author Columns: Book_Author_ID, Book_ID, …

I tried [CODE]DBCC CHECKIDENT('Customer', RESEED, 0)[/CODE] but there's an error. Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.

I am using a datagridview for the output of the results and I have made 4 combobox each have its condition, asceding and descending, starts and contains with, search from table.. I am writing this with lots of code, is there any way to make this short? [CODE] string bncw …

Hello, I have a lot of excel sheets which columns are slightly different, i want to import all of these sheets (one at a time) into ONE SQL TABLE. I'll give an example : Say ive written the required program and called it Excel2sql converter. So Excel2sql takes an excel …

I have a Fully Completed report in ms Excel. I want to change My Report using SSIS Pakage.. i realized that 'unpivot' and 'pivot' component will be needed.. so someone can help me to solve this matter.. thanks..

I have a table like below format. [CODE] CREATE TABLE Customer ( number VARCHAR(40) NOT NULL, --col 1 name VARCHAR(100) NOT NULL, --col 2 ssn VARCHAR(50) NOT NULL, --col 3 age INTEGER NOT NULL, --col 4 ) [/CODE] I want to add a new column in the table. If I …

Hello friends! I am creating a report, Abstract of Bid/Canvass, which will show all the supplier who bids. This also show what item is awarded to a certain supplier through showing the item row number and ranging it like 1-5. I've already created stored procedure that will show the range(s) …

i want to have 2 listbox. the first listbox is for the Main category and the other one is for the sub category. and by using sql 2005 for the database. help me plz. . . for example my main category for the 1st listbox is ADIDAS CONVERSE NIKE SKETCHERS …

hye fren...i'm using asp.net and sql express 2005 right now.....my problem is how i want to select 2 table from the database because i'm using a gridview......?anyone?thanks in advance.....