9,022 Topics
Hi, I've imported a Visual FoxPro database to MS SQL Server 2008 and had a couple of queries; The VFP tables used Numeric(5,0) for the Index fields, but I'm thinking of converting them to Integers in SQL Server. Is there any issues I should be aware of? A co-worker keeps …
We have an SBS Server as PDC, exchange server & SQL server. It is old and in need of upgrading. We have an office nearing the limit of SBS. So, we bought a new non-SBS server as well as exchange & SQL. Now the question is how to best go …
i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line. dataset: a b c …
Hi, I have an app that gets data out of the database. This data is updated via a separate application. At the moment the first application has to check every x seconds if there is any new data. I seem to remember reading a while ago something about subscribing to …
Good Day all i have created a Global Variable as depicted in the following Pic [URL="http://www.tiyaneproperties.co.za/SSIS/pic1.JPG"]http://www.tiyaneproperties.co.za/SSIS/pic1.JPG[/URL] The Following Screen-shot shows how i created my Variable and its Properties [URL="http://www.tiyaneproperties.co.za/SSIS/pic2.JPG"]http://www.tiyaneproperties.co.za/SSIS/pic2.JPG [/URL] and the Following Screen-shot shows the Script Editor Properties [URL="http://www.tiyaneproperties.co.za/SSIS/pic3.JPG"] http://www.tiyaneproperties.co.za/SSIS/pic3.JPG[/URL] and the Last pic is the code that write …
Hello all, my first post. I have identical tables in my db. Is there a way to create a view with dynamic query to combine/union all the identical tables into one view? dbo.table.x-1 dbo.table.x-2 dbo.table.x-3 dbo.table.x-{n}
how to insert system current date by using sql query in SQL SERVER 2005
danni web has been a great help to me i want just one more help i am able to connect to MSSQL present in my localhost using wamp but i am unable to connect to my MSSQL running in a pc with ip 123.xxx.xxx.xxx can u guide me on how …
Hi to all, May I ask any help for a code in VB6 in saving images in either SQL server or MS Access databases? Please give me some idea thanks a lot in advance.
Dear All I am new in ADO.Net and i am using C#. My problem is I want to execute one trigger in my program I am having name of student in my student table now from my C# program I will pass any name which is in table from textbox …
Good Day All I have the Following Query [CODE] DECLARE @CurrentTime DATETIME SET @CurrentTime = CURRENT_TIMESTAMP select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description], convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time], convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time], tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr on tb.resources = tr.id inner join tbl_user tu on tu.id = …
Hi! I'm a beginner to VB.NET. I'm working on an application which is created using VB.NET 2005 and the DB is created in SQL server 2005. I'm able to delete a record from a table when it is not used in another table as a Foreign Key. For eg. If …
Hi There I am new to c#. I am using SqlDataReader to read database records(using c#).I have found lots of way to do it,but for performance i have found that ordinal reading is fast. Now I want to read a guid field ,as we know that with ordinal reading we …
Hello everyone, I searched extensively but was unable to find a solution to this problem. I'm attempting to generate the CREATE STATISTICS statement that was used to create an already existing statistics in an MSSQL db from its name or the table's name. I'm able to obtain the columns and …
conectivity of sql & visual basic is needed as early as possible pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeee!
Hi, I hope someone can help me creating a sql for the purpose i have. I have a table named case_score_t with these columns: id, case_id, user_id, score, created_date I am interested in picking the rows with the greatest created_date, for a certain user_id. I now this SQL with give …
Windows Server 2003 Standard Edition Service Pack 2 SQL Server 2005 Standard VS 2008 Hi everyone. I'm currently working on the following tutorial: [url]http://www.asp.net/Learn/Security/tutorial-04-cs.aspx[/url], but I get an error adding a SQL Server DB to the App_Data folder. I right click App_Data, click Add New Item, SQL Server Database I …
i'm working on asp, vs2005. I should save the typed information in sql server. I connected and written the code in the following way[CODE] Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim ConnStr As String Dim visitors_name, officer_to_visit, purpose, date_of_visit, time_in As String Dim serial_no, …
Hello, Anybody help me to develop a web page for online registration with asp.net and sql server...plz
hi, how the way backup database in sql server 2000 with syntax sql for one month, i mean query. Thank's
[CODE][B] DataTable dt; private void Permissions_Load(object sender, EventArgs e){ dt = new DataTable(); dt.Columns.Add("Feature", typeof(string)); dt.Columns.Add("None", typeof(bool)); dt.Columns.Add("ReadOnly", typeof(bool)); dt.Columns.Add("ReadWrite", typeof(bool)); datagridview1.Datasource=dt; } private void btnSave_Click(object sender, EventArgs e){ [COLOR="Red"]in the grid when i'll click on the any checkbox i want to pass parameter to this function [COLOR="Green"]SetPermission( , , …
Hello every one.. I have this exception while trying to execute an insert command into a simple sql database [CODE] string myChar = charNameTextBox.Text; string command = "insert into data (char,Entropy,Uniformity,stadev,smoothness,skewness,kurtosis) values(" + myChar + "," + entropy + "," + uniformity + "," + standardDeviation + "," + Smoothness …
I have one combo box “cboitemname” and one text box “itemcode” in vb6 form,I have a table “stock” in sql server 2000 database where data about item name and its code is present, in rutime I want to disply item code of item that I select from combolist, how should …
Hello Everyone, I am implementing an asp.net web site. I use sql membership provider. Some times when I am trying to connect with my database, It gives an error message "Login failed for user 'operator' ". Here operator is the account that I am using to connect Sql server using …
I think my thread title is a bit incomplete. coz these are my questions.I need answers to these questions for the completion of my thesis. [B]I Know this is sort of a long message but im detailing the situation for better understanding of my questions.[/B] And because these thread is …
[TEX]How do i insert a Sql database into a project so that the project won't be dependent on sql server and can be moved around freely?[/TEX]
I'm currently populating my GridView using code-behind codes and it looks like this:- [CODE]BoundField boundField = new BoundField(); boundField.DataField = "student_name"; boundField.HeaderText = "Name"; GridView1.Columns.Add(boundField);[/CODE] Is there a possibility where I can have a different DataSource for the different BoundFields that I insert? Perhaps, Column 1 - 5 uses SQLDataSource1, …
[TEX]How do i insert a Sql database into a project so that the project won't be dependent on sql server and can be moved aroun freely?[/TEX]
Hi, I am doing a student progression system where the application is able to keep track of student marks. I have a problem currently and I've been spending nights on this. Let me briefly explain. Marks are calculated based on their hurdles. So for instance, H1 = xx%, H2 = …
i m final year student of computer engineering and there is problem for me in my final year project. i want to attach databases to sql server dbms from one of the form of my vb.net application. the idea is that a want to have a button name "Browse" when …
I just keep getting the same error. can not insert record. Problem near keyword "where". [CODE]Imports System.Security Imports System.Data.SqlClient Imports System.Web.Configuration Imports System.Data Partial Class admin Inherits System.Web.UI.Page Public connectPath As String = ConfigurationSettings.AppSettings("Maya") Protected Sub fillDropList(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not Page.IsPostBack Then …
In the view below, I need the line "[COLOR="Red"]isnull(wwr.packed_qty, isnull((select sum(qty_on_hand) from lot_loc where item = coi.item and loc like 'P%'), 0)) packed_qty,[/COLOR] " to include a "[COLOR="red"]or 'S%[/COLOR]'", so that both P and S are found, but I get a syntax error when I add it. What is the …
how can i find the table names from Sql server. what r the statement.
it seem my connection string doesnt work? [code]$connect = mssql_connect("192.170.10.798","sa","gasd") or die(mssql_error()); $test = mssql_select_db("banex", $connect) or die (mssql_error()); [/code] whats wrong with my connection string?
all I need to do is have a control that a user keys in a code that is validated against the sql table and brings back the associated web page for that code. does anyone know how to do this in Visual Studio 2003
In my application, When the user clciks a button,some coding wil run, after that a popup window should appear, with a image button and its saved to sql server. I am using asp.net 2.0 Plz help me
Good Day All I have a Package created and hosted in a Machine(Theresa) that has SQL 2008 and i have my Development Machine(Vuyiswa) that has IIS and am Debugging from the my machine. i have a ASP.NET 2.0 App and am executing a Package that in another machine. The First …
Hello guys. In this project i am involved with we want to list some columns from a sql database. We want to list them as a table which you can make changes to, but the first two should be edited through dropdown and and the other two which are dates …
Hello, Ihope to find some help in here, i have the following diagram [URL=http://img143.imageshack.us/i/13503390.jpg/][IMG]http://img143.imageshack.us/img143/6704/13503390.th.jpg[/IMG][/URL] and i want a query which return Emp_ID, Pro_ID note; i can get these values but by 2 queries as the following; [code=sql]select Pro_ID from Projects where Dep_ID in (select Dep_ID from Departments where name = …
Hi, I have a computer that has Win-2003 and SQL Server 2005 Installed. I checked my client and server both are giving the response to each other using ping their address. I created a string as: ---------------------------------------------------- Public conn As New ADODB.Connection Public rs As New ADODB.Recordset Sub main() Set …
What is the best way to generate a set of dates based on today's date? Essentially, what I wanna do is: 1. Get Current Date 2. Populate a table with future dates 6 months apart and go up until I reach, let's say, 12/31/2020 I have looked at some of …
hi guys, I have 2 tables, one called neworders which stores the part_id and num or parts and a 2nd table called parts which has all the part details including cost. tables are as follows [code] neworder part_id(primary key) number_of_parts parts part_id(primary key) 7-8 more columns, eg size, desc, sup …
I have the next query, but it doesn't update when I have but of a product with the same code in the table detallefacturas UPDATE dbo.Kardex SET dbo.Kardex.SaldoDocumental = dbo.Kardex.SaldoDocumental + dbo.DetalleFacturas.Cantidad FROM dbo.Kardex INNER JOIN dbo.DetalleFacturas ON (dbo.Kardex.CodigoZofriID = dbo.DetalleFacturas.CodigoZofriID) WHERE dbo.DetalleFacturas.FacturaID = @FacturaID for example. DetalleFacturas Item CodigoZofriID …
Hi, I'm trying to move "leftover" data from one database table to another after the user clicked on a button. Please can anyone give me some advise. This is kinda really urgent plz. Everytime i run my app it gives no error but also doesn't move my data. :angry: I'm …
Im a recent grad working on my first paid project as an aspiring freelance .net developer. I have no idea what to charge for the project description below: Client needs a web app to manage sales leads. Sales reps, managers, and call center will all be able to insert a …
Can I get a template for Log in icon. I have purchased DB Name, MS SQL , Database connection. But I dont know how to connect my database file to server. BC PATTANAYAK
Hello All, I'm very new to the world of php, js and ajax however I've been working on creating two combo boxes built from values in a table. The table is such - LeagueCode, TeamCode, TeamName. The first combo displays all distinct LeagueCode values. The second combo then needs to …
Hi... I want to write a IF Condition as follow: [CODE]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[abc] AS SET NOCOUNT ON; BEGIN Declare @add = 0 as int Declare @change = 0 as int Declare @remove = 0 as int Select abc.value as 'Name' if (History.OLDSTR == …
private bool OpenDbConnection(SqlConnection sql_con_obj) { try { SqlConnection.ClearPool(sql_con_obj); SqlConnection.ClearAllPools(); if (sql_con_obj.State == ConnectionState.Closed || sql_con_obj.State == ConnectionState.Broken) { sql_con_obj.ConnectionString = "Data Source=.;Initial Catalog=Practice;User ID=sa;Password=sa"; sql_con_obj.Open(); return true; } else { return false; } } catch (Exception ex) { ShowMessage(ex.Message); } } I get following error on execution: Error 1 '_Default.OpenDbConnection(System.Data.SqlClient.SqlConnection)': …
I have to connect remotely to my MSSQL database. However, I am a little unsure as to the best way to do this. Can I connect directly to the database from my client machine, or would it be best to create some kind of local script that does the connection …
The End.