2,935 Topics
 | |
| | Greetings. I'm having a problem that is we have a fingerprint devices in the factory, we have 2 work shifts OK so the security guys must switch the devices from "in state" to "out state" so that the [in/out mode] in the database being 0 "means attend state" it changes …  |
 | i am retrieving textual data from database on my page , asp.net(c#), now i want to save in pdf format and want to store that pdf file on my server(localhost) so how ? |
| | during signup by applicant he/she must fill her educational details , total 5 educational levels, 1.ssc 2.hssc 3. BS 4. MS 5. Phd now lets say that an applicant has only BS passed then it mean that he/she would not have fill 4 and 5 option, now i want that … |
| | *.cs page code* using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class advertisementSubmission : System.Web.UI.Page { protected String EmplyrSession; protected int userId; protected void Page_Load(object sender, EventArgs e) { EmplyrSession … |
| | Hi, I'm writing a VB.net application that runs off a SQL database. If the application can not connect to the database or the connection has not been set up I'm giving the user the option to create the database on the SQL server instance of their choice I then create … |
 | i have two tables with the following columns: departments: departmentID tinyint not null department varchar( 30 ) not null employees: employeeID SMALLINT(5) not null departmentID tinyint not null firstName varchar(30) not null lastName varchar(30) not null how do i create the two tables using SQL with a foreign key linking …  |
| | ***using select query result in insert query*** ***i have this code in .cs Page .cs page*** String query = "select userid from tblUser where email='" + EmplyrSession + "'"; SqlCommand com = new SqlCommand(query, con); try { con.Open(); int noRows= com.ExecuteNonQuery(); Response.Write(noRows); } catch (Exception ex) { Response.Write("Sql Error:" + …  |
 | I'm new to MSSQL though I have some grounding in MySQL. At the moment, I'm trying to use a variable. Reduced to simpler form, my query to search people with 'and' in their name is: DECLARE @MyVar nchar; SET @MyVar = '%and%'; SELECT name,email FROM db.dbo.users WHERE name LIKE @MyVar; … |
| | I need to split my Access 2007 .accdb and place the back-end on SQL Server 2008. I am not able to utilize SSMA due to security reasons. SQL Server resides on a different machine from the Access Database. I tried looking for books or tutorial to no avail to any … |
| | I just task with sql related Syntax,using ERP software.How i want to more about sql database?  |
| | Hey guys. I am trying to move a SQL database from one SQL server to another. One is SQL server 2003 and the destination is running SQL server 2008. Can anyone provide some guidance with this. I have never done this before so any pointers with be greatly appreciated! Thanks! |
| | in databse tabel i have fieild with type varbinary(max) for storing image, so i achieved it and stored my image but the problem is that when i use this line SqlParameter p8 = new SqlParameter("logo", SqlDbType.VarBinary).Value= productImage; then it gives me an error but when i use this line : … |
 | Hi all, I have the following VB.NET code where I am attempting to connect to a SQL Server table, query it to find out if a date in the table is between a derived date called "fileCreateDate" and now/today. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim … |
| | if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this app1 will retrieve first 500 records app2 will retrieve next 500 records means no over lap SET Transaction Isolation Level … |
| | i stored session variable in string variable in .cs page , but now i want to retrieve that string variable on .aspx page and want to put into selectcommand of sqldatasource how ? |
| | am using asp.net 3.5(c#) + sql server 200 DB, doing this GIVES me an error , *Error:The multi-part identifier "email@yahoo.com" could not be bound* why ??? using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; … |
| | i have imagepath stored in database , now i want to show on asp.net page via datalist , so how to do it , i tried by best and binded textual data from database bt not able to bind or show image on asp.net page via datalist ? i am … |
| | Hi all, I have a table called tblCPI that holds approximately 160,000 records that have to do with Canadian CPI. I have created a process that did the initial data load into it and now I need help figuring out how to update it according to date values. For instance, … |
| | i have field (advDetails) in database with datatype TEXT, and i am trying to insert text from asp.net detailsview into database but it isn't working. here is my code. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="advertisementSubmission.aspx.cs" Inherits="advertisementSubmission" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> … |
| | Hi, I have a table with date column where the date data is represented by a number. I would like to view this data in a date format (dd-mm-yyyy) after running the sql statement. Appriciate if you could let me what is the code for it. Thanks. Y |
| | Hi All, In my table (dbo.partha) i have three fields. the first one is id, 2nd one is CM_Name and the last one is empid the table looks like id name empid 1 Das 5 2 Ram 9 3 Abi 5 1 Wed 5 4 Sat 4 5 Sun 3 … |
| | Greetings, I have 3 tables in my database HR_Employee_Personal_Info, HR_Employee_Job_Info and HR_Attend_And_Leave_Of_Staff respectively, I want to get the attendance of each employee based on his work shift. I will mention the columns within each table which will be of interest in order to do the job. Table HR_Employee_Personal_Info: [Employee ID], …  |
| | Hi All, I am trying to link two database in different servers. Are there any ways I can do this? If this possible, could anyone show me how to do it. I've been googling it a few weeks ago, there are sites that said to use the sp_addlinkedserver but I … |
| | Hey everyone, I'm using CTEs to try and get the totals of two different criteria queries that I want to group by Month depending on the associated Inquiry Date. Here is what I have right now; ;With CTE(total, InitDate) as ( SELECT count(Inquiry.ID), Inquiry.Date from Inquiry Inner Join Inquirer on … |
| | Hi All, In a table (dbo.UnquotedContacts) I have few columns from where I am trying to extract few columns. But My crcern is as follows IF the field 'Date_ABC_Updated' is NOT empty AND the field 'subscribed_to_Business_XL' = 'SUB', the contact has an ACTIVE BXL subscription IF the field 'Date_ABC_Updated' is … |
| | Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable … |
| | I have created a cube in visual studio, when i want to deploy it i get the following error: Error : The project could not be deployed to the 'USER-PC\SQLEXPRESSR2' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service … |
| | Hi All, I am new comer in this site. Through Google serach I have found this community. Hope this site is really helpful for the beginers who wants to learn everything However I have written a query and got the result. Now I want to insert the data (what I … |
| | i have a problem. i have a table that has one column that should accept one of a set of defined values. i know in MySQL i use the following command to create the table: CREATE TABLE tblstudents ( studentID int( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT, lastName VARCHAR( 20 … |
| | HI All, I'm writing an application in Visual Basic .NET but the application will use a SQL backend. If the user runs the application and the backend database is not set up, I want the user to select a SQL Database Instance, supply an administrator user ID (sa) and Password … |
The End.