[microsoft:sql-server] Forum Topics

Hi I have a Formview that allows a user to update any combination of 80+ fields. I need a formView so that I have control over the position of the fields on the page. Regads updating, my idea was to get the NewValues (from FormViewUpdateEventArgs), then create an xml string …

[ATTACH]22040[/ATTACH] the following code displays output as in attachment.. it skips some of the value.. in the above output, am not getting group name for DTA. but if i add [CODE]where groupid='DTA' in query[/CODE], it displays groupname. what went wrong here? please help.. thanking in advance. [CODE] while($rowmain=mssql_fetch_array($resultmain)) { $course …

Hi Guys, There are unwanted character in my columns. this character is came from the bulk insert. How tdo i removed this character using scripts. Please see sample below. [CODE] ItemCode--Item Number ---------------------------------------------------------- 123--Phone power on but vibrate is too weak P300-3110-VX8575 124--place a test call. P300-1710-DROID 125--power issues.touchscreen not …

Whats the use of super keys and candidate keys when primary key can handle the entire thing in database?????

hi everyone .... how to graph data from MSSQL database using php? i research in google and i found phpgraphlib but it only graph the value of the array

Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes …

Greetings expert programmers, May i ask for a help on how to solve this error? " A network-related or instance specific error occured while establisihing a connection to sql server. The Server was not found or was not accessible. Verify that the instance name is correct and that SQl server …

how to create data grid table and how to link it to MS SQL Server 2005 Express database

Hi I am using the following to auto search db [CODE] Dim connString As String = My.Settings.strConn Dim conn As New SqlConnection(connString) Dim cmd As New SqlCommand("select firstName, existing from tenant Where (existing = 1)", conn) Dim da As New SqlDataAdapter(cmd) Dim ds As New DataSet Try conn.Open() da.Fill(ds, "List") …

I have a project where I need to retrieve data from MS SQL Server and format it into an Excel Spreadsheet. I am using the OfficePartner component to try and make this easier, but I'm having a hard time figuring out how to get the VB help and Excel Object …

Gi I have a DataGridView which populates from an SQL query just fine in default mode using these table names [CODE][firstName] [varchar](20) NOT NULL, [lastName] [varchar](20) NOT NULL, [rentpaid] [decimal](18, 0) NOT NULL, [datePaid] [date] NOT NULL, [propRef] [varchar](10) NOT NULL, [rentDue] [decimal](18, 0) NULL,[/CODE] I have edited the column …

Ok im not sure what it is I need. But I have a sort of fantasy baseball website that I want to add something to. I want to see what players have been on the most championship teams. I just don't know how to query the players against the results …

[CODE]select CS.Ref, CS.C, DT.ID, DT.Init, DT.Surname, 'C' [P], 'C' [A], 100 [M], case when Convert(Varchar(10),CA.A,120) is null then Convert(Varchar(10),CS.DC,120) else Convert(Varchar(10),CA.A,120) end, C.R, Convert(Varchar(10),C.CDate,120), Do.Outcome, CT.PhysicalOwner, Convert(Varchar(10),CS.CDate,120), Convert(decimal(8,2),CS.B, Convert(decimal(8,2),CS.CB), Convert(decimal(8,2),CS.IB), Convert(decimal(8,2),CS.Calance), Convert(money,SUM(dd.C)), Convert(money,SUM(cl.C)), CT.CID[Cust_ID], Convert(varchar(10),CS.JDate,120), CS.JCN, CO.C, Convert(varchar(10),CS.OD,120), CS.OCN, CO2.C from table1 CS inner join table2 DT on DT.DID = …

Hi I have a form which populates a TextBox I want to use the textBox.text to then load a gridView with the results something like [CODE]Private Sub TextBoxId_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBoxIdSearchExist.TextChanged Dim cmd As New SqlCommand("select * from pay Where t_id='" + tId.Text + …

Hi, Please help me out . I need to retrieve the records from 11th row onwards using select query. Please help me out . Its urgent. Thanks

hey how to answer to these questions Table: Sales(CustomerID , RepID , Area , SaleDate , ProductNo , Quantity , UnitPrice , ItemTotalPrice) a)considering the above table write a function to calculate the IemTotalPrice as ItemTotalPrice=Quantity*UnitPrice b)Write a SQL statement to create the above table (you must use the above …

Guys, I have records from table 1. the objective is to get the date from Table 2. when i try to use select statement to obtain the records it pull all itemnumber with the same item number in TABLE 2. is there any idea to to this using the result …

hi everyone i have this code(dont think its a code spam ..its a trick) which display the date(only): [CODE] <a href="index.php" STYLE="TEXT-DECORATION: NONE">&laquo;Back•</a> <br> <br> <hr width="200" align="left"> <br> <?php $conn=odbc_connect('datasourcegaby','',''); $search=mysql_escape_string($_POST['SEARCH']); if (!$conn) {exit("Connection Failed: " . $conn);} if($search==null){ header("location:index.php"); }else{ $sql="SELECT * from generators WHERE convert(datetime,convert(char(10),TIMESTOMPX,101))= '$search'"; }; …

Hello, Please help me with my problem, this is the simple select statement I have for target bid date: [CODE]ProjectOverview.[Target Event Date - Date] AS [Target Bid Date][/CODE]now, I want to ask how can I select the latest target event date and if value is null, put "no date" caption …

One slippy mistake that can occur with searching Text and Numeric field is that you have to carefully add the ( ' ) character enclosing the text searching string. For example : Text search: [CODE=sql]SELECT * FROM users_log WHERE user_name='Phillip'[/CODE] Numeric search: [CODE=sql]SELECT * FROM users_log WHERE user_age=>16[/CODE] In case …

Hi guys! I am at the very end of a 3 month project and have encountered an issue right at the last hurdle. I am using my companies content management system to display a web page. The web page is information regarding a certain species of animal, and the content …

Guys, I have a Date string. My objective is how to get the Datename. I got this Receivedate as string when I used the Bulk insert. i make the receiptdate as nvarchar because i got an error when i used the bulk insert. [CODE] Select ItemNumber, PurchasePrice, ReceivingPO, Cast(ReceivedDate as …

there a form which has two text box one for name and other for age and a table containing 20 records of names and ages i want whenever form load the first value of name in table should automatically come in textbox and when we enter age and save it …

How do i change the name of a table in my sql server 2005 express edition database using visual studio server explorer?

[CODE] Sub auto() c.con.Open() Dim j As Integer = 0 Dim cmd As New SqlCommand("select staffid from staff order by staffid", c.con) Dim dr As SqlDataReader() dr = cmd.ExecuteReader() While (dr.read()) txtstaff_id.Text = dr("staffid").ToString() End While j = Convert.ToInt32("txtstaff_id.text").ToString() j = j + 1 txtstaff_id.Text = j.ToString() dr.close() c.con.Close() End …

Right now the company I work for is using Microsoft enterprise library very extensively. From what I've found online recently, these database objects aren't intended for web (asp) usage, and are relatively bloated. I don't know how accurate my research is, but I do know we have optimization problems in …

I have the application In which i am ruuning the procedure which runs the Sql Job and at the other end i need to show the job history in grid whose query is [B]select job_id, step_id, step_name, message, run_date from sysjobhistory where run_date = replace(convert(varchar(10), getdate(), 121),'-','')[/B] the job which …

Hi I have [B]Windows 7 Home Premium SP-1, 64-bit[/B] version on my PC. I want to install SQL Server either 2oo5 or 2008. but i am unable to install this. Error: [I]OS Incompatibility[/I] Pls Reply: Thank U

I have the following stored procedure: [code] SELECT moncallAdd.FirstListing, DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899')) AS OnCallStart, DATEADD(MINUTE, mOnCallAdd.duration, DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899'))) AS OnCallEnd, 'Added' As Activity FROM mdr.dbo.mOnCallAdd WHERE DATEADD(MINUTE, mOnCallAdd.StartOnCallTime, DATEADD(DAY, mOnCallAdd.StartOnCallDate, '12/31/1899')) BETWEEN Convert(VARCHAR(10), GetDate(), 101) AND GetDate() and mOnCallAdd.SchedName = @schedname UNION SELECT moncallDelete.FirstListing, DATEADD(MINUTE, …

I have an application that I'm trying to finish in VBA, and as I've never written in it, it's a bit challenging to me. I've written some in VB but the syntax isn't the same between the two for some things. Essentially, here's the logic (or lack of) that I'm …

hi everyone i have a search page that will search base one date... but if i search with only date (9/27/2011 ) it will only display the data from database that has the same date and time but not the whole data in that specific date: example: in my database …

Hi all, In my table i have duplicate rows. i want to get distinct rows. select distinct * from table1 does not work. select distinct col1,col2,col3,col4 from table1 does not work. both say: The text data type cannot be selected as DISTINCT because it is not comparable. select distinct(col1) col2,col3,col4 …

Hi every1 I'm working on my first visual studio and c# app ..... I wanna deploy my winform app (which contains sql database) and sql server express as one bundle... 1. I did a backup for my database . how to insert it into my app ? and what do …

Greetings expert programmers, Can someone guide me on how i will connect my vb.net 2008 to ms sql 2008 r2? I already installed mssql 2008 r2, and when i try to add the connection it says i need to call the administator something like that even though i checked all …

Hello, I'm trying to do a very basic page that allows me to edit a single column in a MSSQL database. For whatever reason I can't figure it out and am hoping that you can help. Here is my front page (sorry about the silly names) [CODE]$ninja_conn = odbc_connect('XXXXX','XXXX','XXXX', SQL_CUR_USE_ODBC); …

I wrote the following code for inserting the value in table company_db & database is Company_DB but the value are not inserted into the table table shows null values the code is below: [CODE]Imports System.Data.OleDb Imports System.Data.OleDb.OleDbConnection Imports System.Data.OleDb.OleDbCommand Public Class Newcompany Inherits System.Windows.Forms.Form Private Sub Button1_Click(ByVal sender As System.Object, …

can you help me to code a vb.net program.. i want to have a button that if i click it will add a table in the sql server database.. tnx :)) i really really need this code i only have 1 week to finish dis project :))

Hi, I have a windowsform in visual studio 2008, I connect to a ms sql-server On my form I have a datagridview who I use to enter data etc and save them to the database. I then have textboxes who shows the sum of the columns etc in the table …

Hi all, I want to know how to assin a return value to a variable when calling a regex function. it always returns a bit type of value(its ok). i want that bit type of value tobe cheked whether it is '0' or '1' this is my C# code in …

hi everyone i want to create a search page in PHP... where i can search data from database by a specific date by using odbc command (since i use to connect the DB by odbc) ...can some one help me ...

I have the following connection string in a Excel VBA project: oCon.ConnectionString = "Driver={SQL Native Client};Server=SQL;Database=D1; Trusted_Connection=yes;" On my laptop this works perfectly. But when I try it out on another computer I get an error: I get this error when oCon.Open on debugging: Run-time error '-2147467259(80004005)': Automation error Unspecified …

Hello community, I wanted to see if the following scenario would be possible with VB. We have 13 different locations. What I want to do is open an access database. I want to open a table in access and sort it by a particular column by date. Once sorted I …

Here is my code: [CODE]Imports System.Data.SqlClient Public Class Form1 Dim iConnect As SqlConnection Dim iCmd As SqlCommand Dim iRdr As SqlDataReader Private Sub dologin() iConnect = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\UserData.mdf;Integrated Security=True;User Instance=True") iConnect.Open() Dim strLogin As String = "SELECT username, password FROM tableusername WHERE username = '" & userbox.Text & "' …

can one give me a link or code for forum. i am doing a project and i want to add a forum in my website so user can interact with other i want a perfect c#.net code and back end is sql server 2005 can any one help me pls?

Hi I am using the following code to populate text boxes based on a drop down list index change event [CODE] Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As WinControls.UI.Data.PositionChangedEventArgs) Handles DropDownList1.SelectedIndexChanged Dim connString As String = My.Settings.strConn Dim conn As New SqlConnection(connString) Try conn.Open() Dim qry As String …

Hi I was hoping someone might have a good approach on how to securely expose a IIS 6 intranet site to users outside company network. Building permanent external web infrastructure is not a viable option right now. The external parties are two companies that we do work for, and who …

Hi! I'm trying to send data from a mobile application written in Java ME, to an ASP.NET website connected to an SQL server. I tried to open an httpconnection output stream in the Java ME application, and send the data in a POST to the website. The problem is I …

Hi I have a 'add' hyper link by clicking the link it open a new window after selecting the data from right table to left table i clicked OK button, by clickig the button child window will closed , now if i click the same hyper link again the newly …

i am new with SQL server 2005 and visual studio 2008 please help me..how do i connect the forms and the tables in the database

can any one tell if there existing database administration tools like mysql workbench but for mssql i know about sql management studio, but there is other one who will manage mssql other than SSMS? I will appreciate for any help will come. thank you.