9,022 Topics
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 …
I need a suggestion on the scenario I have, multiple application sharing same data. -I have a set of tools which is developed independetly, but there is a set of data they share. -Its around 7 Applications sharing some of the basic data and few data are specific to the …
Hi all, I have the following procedure that connects to my database. Sub getDateModified() Dim fileCreatedDate As DateTime = File.GetCreationTime(strFilePath + "\CPI1.csv") Dim stmt As String SQLConn.ConnectionString = ConnString SQLConn.Open() stmt = "select Table_Numbers From tblRelease_Dates Where (Release_Date Between '" + fileCreatedDate + "' And GETDATE())" SQLCmd.Connection = SQLConn SQLCmd.CommandText …
I have written a VB reservations program that writes back to a SQL 2008 database. When I write the reservation event back to the data base, I also write the reservation 'end time' back to the database as reservationtime + 4 hours in order to block off the event resource. …
Hi, So i've got a web page that has various drop down menus on them. The first one is for processes and the second for activities. I was wanting the second drop down list (activities) to only show the activities related to that process. I'm only starting ASP.NET so not …
This code to save, Edit and delete data in VB.Net using SQLServer as backend. this code is continuance from my previous post "Show Data in DataGrid with VB.Net 2003 and SQLServer 2000". so i didn't write code how to connect SQLServer 2000 with VB.Net 2003 cause this already in there. …
hello, i have a project and im a beginner in this type of programming.. im using sqlcserver 2005 to connect into visual studio 2010.. may i ask what is the correct syntax connection string.. i have my code already but i can not connect because there is an error stating …
*.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 …
Hi guys! I don't know if i post it in the right forum page, but I would like to ask if it's possible to put color on the last row of your table (LAST ROW ONLY). the data is from SQL. I would appericiate any references or links, snippets, anything! …
I'm developing a website, so when a user hits a button the following sample sql code is run. This is for registeration and basically meant to take information entered in a form and save it. BEGIN TRAN *sql code* *sql code* COMMITT TRAN BEGIN TRAN *sql code* COMMITT TRAN IF …
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:" + …
The employees of our company are using an India Cash Program application that displays records and data according to search criteria and also genertes reports.It is built using VB6.0,sql server 2005 and crystal report 8.5 .The application is used daily from an .exe file that is installed on all computers.The …
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 …
anyone please explain to me what is the diffrence of this two query select * from tbl_Booking where [Date of Pres] between 'October 11,2012' and 'September 17,2012' (this query can display the information) select * from tbl_booking where [Date of Pres] between 'September 17,2012' and 'October 11,2012' (while this query …
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 : …
I have a crontab job in which data from csv file get insert into mysql table at regular interval. Now i want the same table data to be inserted in ms sqlserver database. I know i can write code again to take data from csv to ms sqlserver database. But …
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 ?
1.i hve create listview on form1..all data in listview from Sql2000 database..im using sql connection.. 2.in listview i hve not create a checkbox.. 3. i print all data in listview using ms report but only selected item in listview will display in report..i mean, display item that i hve select …
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; …
Hi friends! I'm looking for an easy way to enable a user of my app to print the contet of a GridView.However, I think an easy way will be to convert it into a Crystal Report or pdf (many people say to pdf is terrible), so, I'd like to convert …
Good day, I just want to asked regarding SQL. let say i have a table for discount.using SQL query. here my table name A Item Price A 100.00 B 200.00 C 300.00 Assume that there's 20% discount if the price is greater than 200.00 Discount should apply 1. How could …
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
Dim conn As New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = e:\wms\wms\wms.mdb") conn.Open() Dim userDetailsAdapter As New OleDbDataAdapter("select * from daily_trans", conn) Dim userDetailsTable As New DataTable userDetailsAdapter.Fill(userDetailsTable) Dim returnRows() As System.Data.DataRow = Nothing returnRows = userDetailsTable.Select("cons = " & TextLine) If returnRows Is Nothing Then MsgBox("Can be saved") Else MsgBox("Primary Key") End If …
Hello, I am working on a project which aims to compare an image to from a database of images and find out similar looking images. I am working with a DLL file which returns unique hash for each image. The hash is an array of 768 bytes. (byte[]) My problem …
overload resolution failed because no accessible 'new' can be called with these arguments.. the error shows at the Dim *dataadapter* As New SqlDataAdapter(sqlCmd, connection) Imports System.Data.SqlClient Public Class Form1 Private Sub BtnGenResult_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnGenResult.Click Dim ConnectionString As String = "Data Source=(local)\SQLEXPRESS; AttachDbFilename=D:\PKBW Batching …
I am new to vb and I have been working on getting my brain around this if condition problem I am having in a windows forms in VB. This part of the project is a form writing back to SQL. I am looking to valdate input in textboxAm before I …
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 …
i want to save my picture in database i have these codes but then there is an error . " command text was not set for the command object " how to solve this problem? thank you.! Try If imgName <> "" Then Dim fs As FileStream fs = New …
Hye, can one please explain to me about the code below. I need to know what exactly should be inside Field1 and Field2? I'm new to vb.net. I know that tbltemp should be the name of our table but im confused about the Field1 and Field2. Dim strSQL as String …
C#, SQL SERVER 2005 first. Sorry for the bad english :> can anyone give me ideas, techniques, theories, or any posible solution. Here is a scenario i have a form called SearchItem and a database table doc_Item doc_Item has a 1 million. . . data. when i click a button …
hi im new to programing and im trying to make a program that would calculate the tax on a given price but that would accept the tax rate as either an integer or a double but i get this error Index (zero based) must be greater than or equal to …
i want to hash my password to SHA1 algo, in asp.net code and then want to compare it with hashed password in sql 2008 db, for login so how to hash it in asp.net code ?
Hello! I am makeing inventry program for my SHOP, When Button1 clicked, listview all items will UPDATE, listview coloum 3(QUANTITY) will SUBTRACT from ms access quantity. Please help me. Private Sub Button9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button9.Click Try Call OpenConnection() OleDa.UpdateCommand.Parameters.Add("UPDATE [Inventry] SET [QTY] = [QTY] …
Hello Everyone, ASP.NET (C#) I have problem in retrieving the images from Table created in SQL Server Management Studio. Actually I had uploaded the images into folder in the Application Server on Visual Studio and the path of the images is given in the Table Attribute. Thus I have table …
check the image or chk Hot Jobs section in this link: http://www.bayrozgar.com/ i am working in asp.net and want to put exactly same thing whitin my website, and all text fields + images should b from database, sql i have all entries in database for advertisement section, but i want …
Who know how to let winForms C# access SQL database through internet.
Hi I am developing a windows application. For your infomation FRONT END : C# (VISUAL STUDIO 2008) BACKEND : SQL SERVER 2008 In a single form I have an option for add and remove client. Two different buttons are used(Add and delete clients). When I click on Add button the …
i stored few ads details in sql database & made connection between my asp.net website and sql database , now i want to update my page automatically with ads after every few days, mean if i have 50 ads details in my DB and i only show 10 ads per …
i have this two tables fields: table1 (BOQSectionsAndParts_ID,BOQSection,BOQPart,ProjectNO) BOQSectionsAndParts_ID is a primary key table2 (BOQItemEntry_ID,ProjectNO,BOQSectionsAndParts_ID,BOQ_Item) BOQItemEntry_ID is a primary key and BOQSectionsAndParts_ID is a forign key. this is a sql server in my vb forum : i view the BOQ sectin as a combobox what i need is when the …
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], …
The End.