9,022 Topics
I've my data in a Database. Using SQL,I need to print it on a list For example, My Table is: Teachers, and it has ID, Name and Phone#. I need a button which shows all this data in a list. My first thought is with a DataGridView.. ID Name Phone …
[CODE]obcon.cmd.CommandText = " select f_name + ' ' + m_name + ' ' + l_name from contact where type='" & ledcmbsrctype.Text & "'" obcon.con.Open() Dim dr As SqlDataReader dr = obcon.cmd.ExecuteReader While (dr.Read) ledcmbsrcitem.Items.Add(dr.Item(0)) End While[/CODE] 'name is added to combo box and i want to get id for selected …
hey everyone, i need a little help in here....i am making a vb program( VS 2008 ) that create a blood type Card for a patient(Name,ID,BirthDate.....and picture), All info are stored in SQL database (SQL 2008), concerning the image i store the path of it....so in the crystal report how …
Hi EveryOne, I have some problem in validating duplicate values while saving & updating my records to SQL database. I have following codes: [B]1. Decalaration Code[/B] [CODE] #Region "Declarations" 'Declaration for Navigation Dim inc As Integer Dim maxRows As Integer Dim ds As DataSet = New DataSet Dim dvEmpDesignation As …
How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to insert a1,b1,c1 in 1st row. a2,b2,c2 in 2nd row,... How do I write one sql insert statement to do that?
Hey guys, not sure what thread to put this in, please direct me to the correct one if this one isn't it. I'm struggling with a sub report in iReports. I have a report that selects from a MSSQL database, and uses a sub report to do a select from …
need to check an SQL Server database (not asp.net membership) to see if an email is already in use before allowing the user to register. I have tried using the information in this website but it does not seem to work. Your help will be much appreciated
hello all, after tried so much now posting here. i have two programs sql.php and form.jsp. i want to do insert values into mssql database from user input form. sql.php is able to insert the values into database. i have connected database using ODBC.form.jsp is able to give user input …
Hello everybody. How do you do? I have a really odd problem. I am using an application which is running on MS OS-es. (MS Windows XP SP3, MS Server 2003) This application connects to a remote SQL server (MS Server 2003). The version of MS SQL was 2000 (previous free …
Please Any help me , I need Free JSP hosting with MS SQL (Data base) for one month as a trail basis to check my Project Work ! Please Help me out!
Hi everyone, we have constructed a content management system that gets updated quite frequently and is used by many clients for their day to day opperations for their websites. We have decided to build a section of the CMS with additional modules that we will host on our cloud and …
Hello, I am having trouble inserting data from a XML file into a table in a SQL data base. The worst thing is it isn't coming up with an error but nothing is being inserted into the database Here is the condensed version of the XML code I am using …
What I am trying to do is have a user enter a word into a text box and retrieve the information from a SQL database where the 'entered word' eqauls that a column. I have this working perfectly but now I would like the user to be able to enter …
[CODE] System::String ^name_string; SqlCeConnection ^sqlConnection = gcnew SqlCeConnection("Data Source=Northwind.sdf"); sqlConnection->Open(); SqlCeCommand comSelect = gcnew SqlCeCommand("SELECT * FROM tablo WHERE id = 33 ", sqlConnection); SqlCeDataReader ^reader = comSelect->ExecuteReader(); name_string = reader["name"]->ToString(); sqlConnection->Close(); [/CODE] What's the mistake on the code above ? :?:
Hi I am trying to store the filepath of uploaded files in a sql server database using vb.net. I have run the code at it uploads fine but nothing is being added to the database. Any help will be greatly appreciated. [CODE]Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As …
I'm trying to store a data from the checkbox. when i checked on NSO Birth Certificate it has to be stored into my mssql server. here is my code If nso.Checked = True Then strsql = "insert into student info(Requirements) values ('" & nso.Checked & "')" Dim sqlcmd As New …
Guys, I have an SSRS report with a month to date parameter. the date parameter is set up like startdate 10/01/2011 - enddate 10/31/2011. I would like to run this every first day of the current month through ssrs subscription. I need your idea guys to tis in subscription. thanks. …
Hi, I am very new to c# and I toying with the idea of using stored procedures to insert values from two textboxes in to two related tables. Table 1 Model (ModelID PK, ModelName, ManufacturerID FK) - Table 2 Manufacturer (ManufacturerID PK, ManufacturerName) both tables are related by the ManufacturerID. …
Hi guys i'm trying to just do a simple email/password validation on two text boxes. This code runs but when i type in a correct email address it throws an error "Object reference not set to an instance of an object." on [CODE]AdAcc.InsertCommand.Connection = OleAcc;[/CODE] I'm thinking i may need …
Hello, I'm currently working on a database application where the application can show a number of risks and counter-measures. Now i'm updating the application so it is possible to upload new risks without having to open the database. However, each risk has an riskID, a number that was being put …
Hi Guys! I am using the following Connection Strings for ms sql. I am new in programing so help me. Eror: [B]Description: [/B]An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in …
HELP!! I try to bind a textbox to a datatable but i cant.. I checked if the datatable is filled (it includes the results of a sql query)and it s ok.. i can depict the result in a combo box but not in textbox. I wait for only one result …
Hi dear S/W Eng and Asp.net c# Developer. I am facing a big problem during converting a textbox value to decimal. baceous the Database type of that variable is decimal(4,4) that is client requirement.From front end when we passing a value like 1234.0000 MSSQL throws exception "Fail to convert numeric …
Hi dear S/W Eng and Asp.net c# Developer. I am facing a big problem during converting a textbox value to decimal. baceous the Database type of that variable is decimal(4,4) that is client requirement.From front end when we passing a value like 1234.0000 MSSQL throws exception "Fail to convert numeric …
Sir I need some urgent help. M currently doing a project on hotel management system in C# using visual studio 2005 and SQl server 2005. The main problem m facing ri8 now is m unable to ADD and DELETE data to the server in the windows form. M alredy connect …
NEED HELP~! I want to create a openfiledialog and allow user to choose which exel file to be imported into the server but this error keep coming "ODBC--connection to '{SQL Server}'TGT102 failed". Thank you so much~~ PS. I am just a beginner of vb.net. So would u pls tell me …
Hi There; I have a MS-SQL 2005 in my computer. There is a [I]person [/I] table, and this person table have three columns; [I]name[/I], [I]surname [/I]and [I]address[/I].They are nvarchar(50). I hold the data of my company on it. User can make some queries over it via HTML. PHP code does …
Hi, I[B] have a problem with the following query select tbl_employee.E_Name,sum(tbl_Salary.Amt),tbl_Dpt.DeptName from tbl_employee inner join tbl_Salary on tbl_employee.eid = tbl_Salary.eid inner join tbl_Dpt on tbl_Salary.eid = tbl_Dpt.eid where tbl_employee.eid ='E101' When the query is executed,the following error is displayed "Column ' tbl_employee.E_Name' is invalid in the select list because it …
Hello Everyone, I wrote a function that allows me to retrieve data from a single SQL table and place it into 3 datagridviews. The problem i am having is as follows: * Whenever a user types something in anyone of the datagridviews that information is recorded in all three of …
Hi Guys, I wrote a function that returns the number in a particular field, my issue at the moment is how to update that field before i return the previous value i collected from the field. i am seeking any guidance available. Enclosed is the function i wrote. [CODE] Function …
Hello friends, I am looking for a bit of help. Here is the scenario. I am trying to compile sales data for a number of stores from multiple databases and import them into excel for the current month by day. I have a field for date and sales. The problem …
Dear, I have a code of c# who simply insert data into database i have code that contains abyte data but runtime it insert query display the system.byte[] instead of byte data [CODE] private void showData_Click(object sender, EventArgs e) { String FileType; String PictureName; for (int i = 0; i …
Hi all I am using asp.net 4.0 for my application that connects to sql server 2008 via ADO.Net Entity Framework. When there is bit increase in traffic the site goes down. I notice below error in event management [QUOTE]Execution of the command requires an open and available connection. The connection's …
Hi everyone, I am new in LINQ. Please let me help to convert the following SQL Query into LINQ query. The Query is : [CODE]SELECT PRS.Product_Code, PRS.Purchase_Code, PRS.Purchase_Details_Code, PRS.Lot_No, PRS.Lot_Amount, PRS.Sold_Amount, SS.Supplier_Code, SS.Name, ISNULL(SSS.Sales_Lot, 0) AS Sales_Lot FROM Supplier_String AS SS INNER JOIN ( SELECT PD.Product_Code, PP.Purchase_Code, PP.Supplier_Code, PPD.Purchase_Details_Code, PPD.Lot_No, …
I have a drop down menu on a page where the user can select between, All, House, Unit and Rural which send the selection to a stored procedure which access' the database and returns the information with the selection eg. House from the category column. It all works great when …
Hi Guys, Im trying to update a datagrid and a text box value in access database. both shld be saved in the same row simultaneously.,unfortunately its not happening. they were gettign saved in a different rows. PLEASE help. [CODE] conn.Open() sqlQRY = "Insert Into tblPlot(SurveyNo)" sqlQRY = sqlQRY & "Values" …
Context: I am trying to Query a MS SQL CE database for the properties of table columns. I can get a list of tables from the Schema and from that, the column names. Issue: I can retrieve properties for some column elements but some do not return a correct value. …
I have achieve to populate my combobox from sql and from this combobox to populate a textbox but now I have to do something more complicated.I would like to populate a combobox from an other combobox choice. And what i mean is that I have a table with Streenames and …
Hi all, this is maybe a big stupid question, but cant get this to work thing is that i have 5 tables: airlines - hotels - costs - projects and payments being costs my main table. In this costs table I need to have in the 'total' column the sum …
I'm new to stored procedures and, really anything about sql beyond the basic SELECT/INSERT/etc... so this is probably just something I don't understand but my problem is that my stored procedure seems to only return the last row of the result set (i.e. if it should return 10 items it …
Hi There; I have a MS-SQL server and I have Turkish names in my table. User enters names and I send it to SQL server, print result to output. However, my PHP code process and prints text as a UTF-8, and send it to MS-SQL and print it to output.However …
I try many tips but not able to connect two table with each other! Actually i want something like that , I insert into one table and if data also used by another table (Data automatically insert in another table also by submitting data in first table)
Hello all! I am getting errors when I try to use this adodb.connection and command in my code. The error I am getting is saying that the connection and command are not defined. I read online that depending on your version of vb that you might use the "OLE" connection …
lets say it in example,i had column, which its rows contain numbers increasing -10,-9,-8,-7,....-1, those rows got bugged and changed into 1,2,3,4,.....10, that was example, the real one is over 40,000 rows, and it was -2147483629,-2147483630,-2147483631,....etc and it turned into 1000000001,1000000002,1000000003,.... how to make script that scan for 1000000001~1000000050 (for …
cmd = new OleDbCommand("select Convert(varchar(50),Fault_Time),[Level],[Trouble_Source],[Solution],[Ticket_Status],[Close_Date],convert(varchar,Close_Time),[Actual_Cause],[Solution],[Description] from [TT_Record$]", conn); its showing error at runtime :- Undefined function 'Convert' in expression pls suggest........
I need to capture the logout time and login time. I can capture the login time already but I cannot capture the logout time. I would appreciate all the help that you had given me. Thank you. This is the coding in the logout button: [CODE]protected void logoutButton_Click(object sender, EventArgs …
Hai , I have a table Student_transport_Details having columns : UserId DesignatonId StartDate Enddate I need to get records for a particular month. Can i retrieve records by passing MonthId [between 1 -12]. Thanks in advance
Good day! Anyone knows how to select latest record of an item..here's the scenario. I have records with the same data except for the date. Example: product_code productname item_code date PR-123 abc TY-01 2011-10-11 PR-123 abc TY-02 2011-10-11 PR-123 abc TY-01 2011-10-13 PR-123 abc TY-02 2011-10-13 PR-123 abc TY-01 2011-10-16 …
Hi All I am writing an import program to import data from an access database to a SQL database. The table structure in the SQL and Access are the exact same with the same field names. I was wondering if there was a quick way to get the data into …
I have a stored procedure that creates temporary table to populate return table. It works perfectly fine when I execute it on SQL management studio but when I try to import this sttored procedure, it give me an error Invalid object name '#TOTAL' which #TOTAL is the temp table that …
The End.