9,022 Topics
how to send an email remainder using local sql server in my own system.
Dear All, How can i get Crystal report between two dates from SQL SERVER Database. We will enter the dates from One column. Any help will be apriciated.
finaldata table has 7 columns and AllcDataBoys table has 3 columns(which is common on both tables). i want to get a specified row from AllcDataBoys where (Bespx.CompareTo(RET)==0)and put them in finaldata where txtRegNumber match any RegNumber data where the 3 columns exit among the 7 column in finaldata table. -- …
Problem I have is that the following code works only if the user tabs out of the field, (or moves the cursor to another field in the same form), if the cursor is still at the end of the date text, none of the error traps catch, but I get …
pls brothers help me out here: [CODE]"INSERT INTO finaldata (Hall, Bedspace, AmountPaid) SELECT * FROM AllcDataBoys 'WHERE Bedspace ='" + (Bespx.CompareTo(RET) == 0) + "'WHERE RegNumber ='" + txtRegNumber.Text.Trim().ToString(); [/CODE] finaldata table has 7 columns and AllcDataBoys table has 3 columns(which is common on both tables). i want to get …
I have created a gridview that is populated from a SQL table. The gridview does not autogenerate the fields; all are explicitly defined. [CODE]<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="Hours" style="margin-left: 0px" AllowSorting="true"> <Columns> <asp:TemplateField HeaderText="Send Email"> <ItemTemplate> <asp:CheckBox ID="chkEmail" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="tkinit" HeaderText="Initials" SortExpression="tkinit" /> <asp:BoundField DataField="tklast_first" HeaderText="Name" …
This seems to be the appropriate thread to post my problem in: I'm also trying to bind to a ReportViewer object, however I'm not binding a stored procedure but dynamic sql that selects <dynamic columns> from <dynamic views or tables> nice huh? My boss has fallen in love with the …
[CODE]import java.awt.*; import java.awt.event.*; import java.awt.image.*; import java.io.*; import java.sql.*; public class RefHistTest { public static void main(String args[]) { int iw2, ih2; Image img2; int pixels2[]; double[] hist2 = new double[256]; int y; ResultSet r; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection c=DriverManager.getConnection("jdbc:odbc:CBIRS"); Statement st=c.createStatement(); r=st.executeQuery("select Images from ImageTable"); byte[] bytes=null; while(r.next()) …
Hi, I'm having a question about retrieving data. I'm using VS 2008 and I have to create a new consultation record for a patient and I've already created a database with 3 tables, which are doctor, patient and consultation. I have 10 records saved in consultation table, and I've made …
This is a sql datatype problem Hello I am a junior programmer and new member of this forum I want to ask a question I have these two columns in sql 2000 server trx_date char(8) trx_time char(6) And now, I imported this database to sql 2008 and want to copy …
hi, Does anyone knows on how to update records from 1 text file into 2 different sql database. Name of the sql Table is Payment2SQL_Success_P() & Payment2SQL_Success_E() is the code below is on the right track. [CODE=vb.net] Select Case "AGENCIES" Case AGENCY_AV Or AGENCY_SR Or AGENCY_IP Or AGENCY_TM Or AGENCY_MS …
Hello, I just have a very simple n00b question so please forgive me. Basically I have an ASP.NET website connected to an SQL server database. Everything is working fine (I can connect to the database, execute queries) but where should I put the SQL connection/logic code? In the aspx.cs code …
Hello fellas I'm actually developing some web applications in Ajax, and have been trying them in my Wamp server for Windows 7. I've been using the php_sqlsrv module since its release, because of its new features. The thing is, my office has a fedora webserver, and I'm looking for a …
Hi, I am just new using the Microsoft Application Blocks .NET. I am using a custom one... The problem is that when I call the SqlHelper parameter as "SqlHelper. " it only shows to me "Equals" or "ReferenceEquals". Why I can get the others...? [CODE]public void ExecuteNonQuery(SqlCommand sqlCmd) {...} public …
hello, I am facing a problem with the following code: select year(regdate) as [Year],month(regdate) as [Month], CONVERT(varchar(3),regdate,100)as inmonth, count(*) as incount, cast(sum(amt)as decimal(20,2))as insum, count(case when nbr <>' ' then amt else Null end) as incountpo, SUM(case when nbr <>' ' then (amt)else 0.00 end)as insumpo, --cast( (Insumpo / InSum …
Hi all, I got this Error Message while I try to preview the records in Dataset Designer: "The connection string could not be found or Data provider associated with the connection string could not be loaded" Here is my dataset.xsd code [CODE] <Connections> <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)" …
OK SQL documentation sucks. I know that, I've known that for years, but it can be helpful and useful at times, so I use it. I thought I remembered correctly what "~" did, but looked it up anyway. I'm reading the usual @#$%, but getting the basic information (While thinking …
i have create a registration form in asp.net & sql server..It's working good.. i generate ID for user when they click "sign Up" button..(the ID will appear in drop down list at form-ID not saved yet into database).. the problem is when several user register at same time and click …
I have program in VB.NET 2008 where I want to update the premamt cell value in the tblPrem Access table, where the premno is the maximum (autogenerated as 1,2,3...), but only within a specified set of common numbers in a column (contno) I am currently saving. This contno is from …
I have a SQL DTS job that runs nightly. What this is supposed to do is to copy from Database1 to Database2 and to overwrite anything that was in Database 2 previously. This was set up as an import/export job. The process runs nightly as it's supposed to but apparently …
Hello everyone , Have a small problem which i dont know how to deal with . at the same time not sure if i need delegate or event handlers . here it goes . I have two classes with two forms : Form A and Progress Form . Form A …
.hi guys! good day to all, i am currently developing a library system as one of my school projects using Visual Studio C# 2008 and SQL Server 2008. however there are several problems i have encountered. 1st: How to retrieve the value of an auto-incremented field. 2nd: How to use …
I am having the following trouble: "System.Data.SqlClient.SqlException: Incorrect syntax near '11'. Unclosed quotation mark after the character string ' )'. I tried the solution of using double quote right there, but it give me another problem. The more strange thing is that the data is begin copy to the new …
Pls any body help. I am in a crucial situation :( I want to back up and restore database which is created in sql server 2000. how can I use this in C#. The code which I have written is not working properly. It throws an exception at step 31. …
Hi, is it possible to create the aspnetdb file in Visual Studio 2008 using the "Security" option from Web Site Administration Tool with MS SQL Server 2008 express edition? I get the following error message when I try it: "There is a problem with your selected data store. This can …
Hi, I am new to Auditing concept in Sqlserver 2008 I need to Audit certain tables in my database and write triggers on those tables to make insert rows on AUDIT table. Can anyone help me the way of doing this,.. By giving certain examples / Auditing Information on Websites?
guys i need to know how to view the contents and indexes of the files in the .ald database by IMR. is there a way that i conncet this .ald database to MYSQL of MS SQl? I really need to view the indexes that this database has. please help me …
Hi, my name is khalil and im hosting a online game which using mssql! in databases i got database called gamedb i have "account" as table in account table there is a column called GM so this column is my problem! when guy account got GM Column number 0 mean …
I am adding a feature to my application that allows users to backup an entire SQL database, as well as include application settings with that backup file. My dilemma is choosing a good file extension to use. The over-used .bkp type could cause conflicts in systems that have applications that …
I am attempting to create 2 fields that will create decimals so that I can take these decimals and create a percentage in a new field. Here is what I have and I can't seem to get the errors gone. [code] WOAVG = IIf("[WOIssued]=0", "", Val(Nz(WOCompleted, 0)) / Val(Nz(WOIssued, 0))) …
Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only …
Hi, Iam using ms sql server.Iam using a hospital management system .I need to find the last visit of the patient,only the last visit date,How can i do that?I think that it is as same as the latest published text,one of my friend told me,But how can i do that? …
I am creating a program that will have a database of schools.. Each months the user needs to add a certain data entry for all schools, like each month the user will need to input how each school scored in a monthly competition. The number of months is not fixed, …
I have written code to show records in a datagridview but it shows nothing. I have tried to debug & when it step into GetData function following codes [Code] Catch ex As Exception returnData = Nothing If connection.State = ConnectionState.Open Then connection.Close() End If [/Code] become gray & it shows …
i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though two processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really fade up. …
hi, If the condition = true How do i select all records stored in .txt (temporary text file) to be updated in sql table How do i do that. Please help Thank You
I have used following code to show records there in a datagridview but it doesnt work. Even it shows nothing. Please check it & tell me what did I make mistake. Please add example with your answer because I am just a beginner. [Code] Imports System.Data.SqlClient Public Class Form34 Private …
hi, here is my data base structure: [ATTACH]17124[/ATTACH] i try an sql command that return for each examen its number of tests, so i tried: [CODE]Dim sqlQRY1 As String = "SELECT Int_Exa,count(*) as 'TOTAL' from TEST T1,TEST T2 where T1.Int_Exa=T2.Int_Exa"[/CODE] that`s did not work, so i tried to do that: …
how to insert username and password into database with connection in c# please give me reply sir
I have kind of the same question as Rambomst, except I need the query string to populate the values for the IN statement this is the code I have but it's not working and I'm stuck and am in DIRE need of an answer: <% Dim rsAuto__print For i=1 to …
I am trying to make a query which will search for the ID's 5, 6 and 23(Those are just random numbers and could potentially be more). Rather than making a loop in my code to query each separate ID I was wondering if it was possible to query them all …
i have a scenario like this, and want to do a ERD for it, i've done a little bit, and want to make sure it is correct for the entity as well as the attribute...sorry im not so good at that Scenario An international courier, express and parcel Services Company …
i am trying to install developer edition 2000 on xp, but after clicking the autorun file nothing happens, though three processes appear in windows task manager, these are 1) sqlstp.exe 2) setupsql.exe 3) wowexec.exe but both are using '0%' cpu use and taking some memory. i tried so many things..really …
I am doing a Smart device project The problam is I can not pass parameters to the stored procedure to insert into the database from the PDA emulator for the following sqlDbtypes it gives me the following error A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.SqlClient.dll Deicimal Money …
Hi team, I've written a windows program and it works nicely but its really slow when it retrieves the data from the server. Program Overview: The program allows users to search through a database and add contacts if they want. Some of the fields on the forms fill up depending …
Hey all! I'm working on a university project (C# - VS 2010) at the moment which uses an SQL Server 2008 (.mdf) database. At the moment, I have the database (lets call it ProjectDB) attached to SQL Server Management Studio on my laptop (the server - lets call it "LaptopServer") …
How to store and retrieve images from VB.NET and Sql Server 2008
hey i need to know whether the below code is correct [CODE] string query = @"Select p.ID,p.Phase From Proposal as p, Negotiation as n,contract as c Where c.CID=con.CID and c.NID=n.NID and n.ID=p.ID and n.Phase=p.Phase (Select con.CID From Contract as con Where CStatus='Active')"; [/CODE] there is an error coming saying "Incorrect …
Has anyone tried this? My general dilemma is having to open and maintain multiple connections across multiple forms. I have an MDI application and I would prefer to store the connection in the parent form and just have the child forms use that connection if it needs it. This normally …
I am using a details view and sqldatasource to update information in my database. I keep getting this "Incorrect syntax near 'nvarchar'." Error and from what I have researched this is because there are spaces in my table field names and the table name. Here is some code: [code] <asp:SqlDataSource …
The End.