[microsoft:sql-server] Forum Topics

i some help for my project... 1. I create a form..use web browser dan i call link.html...how can i make when i click link in html it will be show form2 2. How can i make datetimepicker get date from server 3. How can i make a dll file path …

I need to create a table to store matched pairs that I can query and get a count of how many times a particular matchup was entered. For example "5" might be paired with "6", but "6" might be also paired with "5". (Quotes are for clarity - not to …

Hello all, I want to create a custom login form for SQL Server 2005, which will have 2 textboxes(Username,Password). When the users clicks the submit button then i want to check the SQL Server users with that username and password,if exist. I need this to be answered asap! Thanks in …

Hi, First I wish to say that I have tried my best to think, but I still coudn't think "out of box". I want to perform a SQL statement base on the condition below: 1.) Table A consists of employee data (Emp_Id, Email, Sex, Address, race and nationality) We have …

Dear everybody hope someone can help me!! Im trying to SUM data from 2 different tabels without any ID connection between and I what to subtract the results from eachother afterwards.. how do i do that. lets say i have tabel1.costs and tabel2.profit I would like to SUM the data …

hi. i have to print the time table in database .. like rows and columns. for example like this 1 2 3 4 mon tue wed thu fri sat so ,how to write the query and how to insert the rows and columns .can u tell me the answer..

hi, i need to print the last row of the table in the data grid form .i am using the sql server and c#.net.. i want to print the recently inserted row of the table.. can u tell me the answer..

Hey guys need your help here. I will go ahead and describe my problem and what i intend and what i am getting. Platform for SQL Queries : MS Access There are 2 identical table in terms of table structure, they contain information ( RAW Data) about month, money i …

Can anybody recommend good online courses for SQL and/or data controls? (I guess I should master the regular data controls before going on to Silverlight, right?)

Hi, In the page I'm developing, I have a CheckBoxList which is populated based on what the user types in a TextBox (Similar to an AutoSuggest). The CheckBoxList is inside an UpdatePanel. When anything is typed, I'm settting the focus to the end of the word, otherwise the focus goes …

I am trying to populate a label using a T-Sql query to a SQL Server table upon a click event. I have the click event and linking to the SQL Server table working just fine. The process (below) returns "System.Windows.Forms.BindingSource" rather than any value from the table. My code is …

I am trying to do this with sql code without using a cursor. I have table A with two cols and no PK ID Data I have table B with three cols the first two make up the PK ID PK SEQ PK Data If I have the following data …

Hi Experts, I already have a database set up in SQL Server that I have used with vb.net in the past, and would like to use it with JSP. I just started JSP last week, and have no idea what I'm doing. I downloaded the sqljdbc driver from Microsoft's website …

I have a table with 2 fields category_ID Category_name 1 india 2 china 3 japan 4 africa 5 france I bind these data into grid in aspx page and in that i have given delete command and when i perform delete operation and if i delete china and japan i …

Hello, How can input number to database where my field in database data type money.. This is my code: [code] Private Sub SaveData() Try If adcLEDGER.State = ADODB.ObjectStateEnum.adStateOpen Then adcLEDGER.Close() adcLEDGER.ConnectionString = strCONNECT adcLEDGER.Open() Catch ex As Exception MsgBox(ex.Message) End Try Try Dim vANSWER vANSWER = vbYes modPY.LookUpST(adcLEDGER, "SELECT * …

Hi All, My name is Ron. I work for a PR company in their IT department as a report developer. Specifically, I am using SQL Server Reporting services and Crystal to develop reports for our company's intranet. I started at this company 2 1/2 years ago as a desktop support …

Hi i am wondering if anyone has a solution for sorting by postcode area. I wanted to be able to pick off either the First letter or first two letters and group by this. I have figured out how to group by the first to characters of the postcode using …

hi, how to auto increment the value in database table when the button clicks.i have created a table named register .when the user completes his registration we will generate the receipt based on the registration. so for every receipt we will generate the receipt no on that. when we click …

Hello Everyone, Please tell me, how to insert data into two tables with one SQL query?

Hi,:) I'm now doing a project on c# sql project.I have a database problem,:'( when a user gives the input dynamically through the front end ,the user data can be view through data grid view .but it is not getting stored in the original database.I have tried a lot to …

My manager has just asked me to research whether it would be possible to restore a previously fully backed up database into two or more filegroups, with each filegroup being on a separate drive using SQL Server 2008. I know that if I were backing up the database to begin …

Hello everyone. This is quite possibly not the place for this but it is more to do with SQL than the other things included so I apologise if I am wrong. I am looking for some help on a task I have been set. When I say help, what I …

hi, i need to get the column values from the table login.it contais two columns ,userid and password. i want to check the userid and password values when the user logged in.so i have to compare the entered textbox value with the saved value. i am using the code is …

I installed Visual Studio 2008 but when I creates any database it gives me error that" SQL server don't allow remote connection" & if i uninstalled only SQL Server & it'r related packeges like VSS Writer, setup support files etc. & I agian installed fresh copy of SQL server then …

Is there a way to upgrade SQL Server Express 2008 basic to Advanced Series without having to reinstall the whole thing?

Hello! I'd like to run mssql script (file with extension sql). I installed Microsoft SQL Server 2008 and run in Command Prompt: C:\Documents and Settings\useruser>osql -Usa -Ppassword -i "F:\Data\MyApplication\Scripts\CreateDb.sql" [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. [SQL Server Native Client 10.0]Login …

Hi, I've created a query that inner joins 4 tables. The tables have a common field CPname and CoverType. The query works and results are correct. However, when I use this query as my record source for a report, I came up with this error: "The specified field 'TblCover.CoverType' could …

Hi all... I'm beginner in c#, And I completed application on c#.net 2005 With SQL server. And run it on other computer(computer has): 1- .net framework 2.0 2- SQL server 2005 But I found big problem, Application show me this message: on this link: [url]http://img101.herosh.com/2009/08/18/894378274.jpg[/url] I don't know what is …

Hi Friends, I need a help, I am making a project where I have to update the class database all at once, I made a function where some values are passing to update, It is updating the Database as well, But the problem is all the database is updated with …

Hello, I've the following problem: I need to insert to a table the following customer data: Year No., Month No., CustomerName, CustomerID... The problem is with the Month No. (MonthNo is the table column name). I'm using the following command, in a stored procedure, after the insertion. [code=sql]SET @MonthNo = …

Hi Team! Anybody could help me with this hell query? I got 2 tables: Table: STUDENTS with only 1 field: [name] id1: jose id2: william id3: john id4: sandra Table: COURSES with 2 fields: [name], [course] id1: jose, saxo id2: william, cook id3: john, saxo id4: sandra, garden I wanna …

Hi guys.. I need help with selecting an item in a listbox which gets its items from a database table using While-Wend Loop. The listbox lists the table's contents properly. My problem is how will I add the item I selected in the listbox (e.g. John, Erick) in another table …

I used the GridView1_RowDeleting Event to delete from the gridview . [code] use sonia select * from Info1 drop table Info1 create table Info1(UID integer,FirstName Varchar(100),LastName varchar(100),EMail varchar(100),Address varchar(100),PhoneNo varchar(100)) Insert into Info1 values(1,'Sonia','Sardana','a@yahoo.com','FBD','2222') Insert into Info1 values(2,'Shouvik','Choudhary','b@yahoo.com','KolKatta','9848484474743') Insert into Info1 values(3,'A','Ad','ds@yahoo.com','qqwD','9444212270') [/code] Suppose I delete record that has UID …

I has a problem with MS Access queries: In SQL, if I want to include arabic word in the query where part, Simply I add '[COLOR="Red"]N[/COLOR]' before the arabic word. The question is what represents this character in MS Access query. Thanks in advance.

Hi, How to get MS SQL database size using API.

I am getting this exception when I run my code in a C# Web Server Application, but if I copy the same code to a C# console application, it works fine. [code] System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. [/code] And help would be …

Dear Friends, I would like to know how to find exact word from a text data available in SQL String. I mean, Suppose I have a string available in Table1; ie , "My latest activities" I want to search the word like test. Currently I am using query [code=sql]select * …

I am copying excel file to mssql database's table, problem is this : I have some informations in 4 rows but mssql database table has 13 rows. fisrt 4 rows has my information and 4-13 rows has null values. sbccm from 1 to 14. where is the problem I donw …

All, Have a frustrating report problem. Have code of:[code]Function RAmount() HrsAmt = DLookup("trp_ham", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) MilAmt = DLookup("trp_mam", "qryTIMshtS", "[trp_id]=" & Me![Row_ID]) RAmount = HrsAmt + MilAmt End Function Function RCount() RCount = DCount("trp_id", "qryTIMshtS") End Function Function RTotal() HrsTot = DSum("trp_ham", "qryTIMshtS") MilTot = DSum("trp_mam", "qryTIMshtS") RTotal …

Hi guys, I'm new here. I have a problem though. I can perform a bulk insert from .csv file to MS SQL Server 2005. My problem here is that there are foreign tables in the .csv file. What I want to happen is that these data should be replaced with …

Can someone please help me with the following problem. I currently have a datagrid linked to an sql database and in the grid I have a ckeckbox column. However, when I check the box in the current cell the checked box disappears when I click on another cell and only …

Hi guys here is my working sql query Select MAX(Hits)'Hits', SUM(Hits)'Total', UserID From sf_articles Group By UserID My problem is, when I want to select other columns as well as the current ones. It gives me a lovely error: Server: Msg 8120, Level 16, State 1, Line 1 Column 'sf_articles.ArtID' …

Hello fellow "Developers" I am trying to create the local search functionality for a website using C#/APS.Net going against a MSSQL Dbase. I'm not really sure where to start. I have uploaded an attachment of what I think needs to be done. If someone could have a look and point …

Dear Friends, I would like to know how to find exact word from a text data available in SQL String. I mean, Suppose I have a string available in Table1; ie , "My latest activities" I want to search the word like test. Currently I am using query select * …

I know mysql but I now have a job where mssql is needed. I am having a problem inerting multiple rows at once. MySQL Query: [code=mysql] INSERT INTO colours (ccode, cdesc) VALUES ('35', 'Green'), ('35', 'Turquoise') [/code] How do I get the same result with MSSQL? Thanks in advance.

Can anybody recommend good online courses for SQL and/or data controls? (I guess I should master the regular data controls before going on to Silverlight, right?)

In every asp.net webpage i am using more than one sql commands to get the data and store it in data set. after the execution of the front end asp.net is it possible to go back and open sql server and see in a window which all statements got executed …

I am filling a datagridview from a datatable which is filled from my database. I want to make a column a combobox column. That column is filled with name id's. How can i make it show the name so I can use the sql command builder to insert a new …

Hi, I'm trying to bind a DropDownList in the code behind using the following code: [CODE]Dim DatabaseConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("myServer").ConnectionString) Dim selectCMD As String = “SELECT name, id FROM Clients WHERE name LIKE @name + ‘%’” Dim selectCMD As New SqlCommand(selectSQL, DatabaseConnection) selectCMD.Parameters.Add(New SqlParameter("@name", SqlDbType.VarChar)) selectCMD.Parameters("@name").Value = name Dim adapter …

Hey Guys, I have a details view bounded with a sqldatasource. I want to calculate the the total no of entries in details view and show it to the user. Please tell me how to do this??