9,022 Topics
How to retrieve the particular column row to the text box? I mean how to display it in textbox? The column has got different rows. The code I wrote in vb net is : cmd = New SqlCommand("select ida from Issue where aname='" + TextBox3.Text + "'", con) In the …
Hi, I want to know what would be your preferences in this case. I'll have a login and sign up process and want to develop its database tables. - 1:1 version needs JOIN everytime when loging in, T-SQL when signin up new user. - Single table version doesn't need two …
I was wondering if anyone could help me. I am working on a program in VS2008 with C# which has a datagridview populated from 2 SQL Express tables and needs to save to only 1 database. Below is the code I have working so far: public frmGrid() { BindingSource bs …
I have created a project in which i am printing Hall ticket for an examination. i am using visual studie 2008 as front end and sql2008 as backend. I have created a report in crystal reprot. I have photographs of students in a local folder. how do i access or …
I am going through some tutorials in java and I would like to do my first insert into an SQL express database using java .I saw some tutorial recomending jdbc insert. I would like to know which is the best and most reccomended way to carry out an insert into …
Hi i want to join two tables,'Employee' and 'Dispatch'. Dispatch has column 'DispatcherID' and 'TechnicianID' which are both foregn keys to EmployeeID in Employee table.I want to join these two tables using EmployeeID so that i can obtain the matching name to each id.but it only works when i make …
Hello Friends, I m Developing an windows form application. i have a winform on which i have datagridview and i am saving the data to Sql Server database from datagridview directly . i m using the following code for connecting & saving data of datagridview to database using button click …
Two parted question really... First off, I've been trying to enable my SQL Server 2008 R2 to allow remote access so my friend can view it from his RDBMS (also SQL Server 2008). I've enabled TCP/IP, I've allowed Remote Access/Connection, I've opened TCP and UDP Ports and also added the …
`Public Class login Dim cnn As New OleDb.OleDbConnection Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click Dim cmd As New OleDb.OleDbCommand If Not cnn.State = ConnectionState.Open Then cnn.Open() End If cmd.Connection = cnn If cmd.CommandText = "SELECT UName FROM Account WHERE UName =" & Me.UsernameTextBox.Text Then …
how do i create service accounts for the various SQL Server 2008 components?
this is my csharp code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Configuration; namespace MutlitableDatasetApp { public partial class MainForm : Form { //form wide dataset. private DataSet autoLotDS = new DataSet("AutoLot"); //Make use of command builders to …
I'm working on a method that will save checkstates to a SQL server and something occured to me and I thought I would ask if there is a simpler way of doing this. If I have a single parameter, for example an initial checkstate, and an if...else statement is supposed …
Hi I am Trying to install visaulstudio2010 and sqlserver2008 in my lenovo laptop. I am having windows7 home premium on my machine. I have installed first sqlserver. installation done successfull but installed **Partially** means sqlserver management studio not installed. 1) Please let me know what should i install first. sqlserver2008 …
I have a checklistbox that I have been working on and I need to commit the changes made to those checkstates to a sql table, removing rows where the checkbox is not checked and adding rows where the checkbox is checked (assuming the checkstate actually changed). Instead of doing a …
Hey guys.... Just wondered if anyone can help me, I'm busy writing an application with a login form using SQL Server, if the user logs into the specific for i want a lable saying logged in as : .... But how do you code that part? Hope you understand thanks
*There is no any specific area to add this problem of mine. Thats why i add this in to windows server area.* **This is a SQL problem.** I want to combine 2 columns in to one column (2 columns are in 2 tables). There are a lot of codes in …
I have derived another challenge for myself, I created a package on an sql server (sql server 2000) this package populates a table in a particular database with data from a datasource. Every time i wanted the table to be updated i would go to data transformation services>> local packages …
hello! i am facing an error ("object refrence is not set to an instance of an object.") i check my all code but i can able to solve it . here is a line of code where i getting it. . . . cmd = new sqlcommand(_mycommand_) if (__mycondition) { …
can any body help me by giving me a guideline on how to insert data from a populated datagrid into sql server table and how to make the values conform to the specified datatypes constructe in the sql server side...assuming the datagrid headings have already been created in the sql …
I am beginner, so please help me with these problem i am suffering I). I have a coding in ASP.net i want to display list of information from my database (MS Sql 2008 R2) to a table. My database contain: Name Email Address Phone I want this to be displayed …
This is my search button and textbox code, but i will got error on pelanggandatagridview and searchdatas, i need to search data on SQL DB like google! just type any word with almost same with the data and it will show on pelanggandatagridview, please help me... Private Sub Button5_Click(ByVal searchword …
Hi, I am getting the following error and I cannot understand why. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Before i try and insert the data into the database I print it out and this is what i get: **09/04/2012 00:00:00** The code below is …
Dear All, I am using VB.NET 2010 and SQL Sever CE 3.5 database. I insert some data into my database (SDF file) and I can do any all manipulations with those data. But I cannot see those data in the data table using Data Source or Server Explorer in Visual …
hi everyone i have to 4 table and two different database ----------------------- first db = rotadb first table =Rota rota pRotabos ldchangetime 101 6 NULL 102 7 NULL 103 8 NULL 104 9 NULL 105 10 NULL ------- second table = Rotabos Rotabos_rowid pRotaBa 6 1 7 2 8 3 …
Hello, We are installing MS SQL server '08 and while installing its giving us the message, "Windows need higher version of Windows installer.. Recommended version: 4.5". How safe will it be to download the installer 4.5 and run it on machine? I just want to have clarification to this question …
Hi All, I am using Visual Studio 2010 and for my database I'm using SQL I am trying to make a multi user login and valdate the input with my datatable the problem is that i made a login page but it's just check the username and the password but …
Hello! I have a query regarding Merge Replication. I have 5 Tables. 1. SetYarnMain Fields (MainId(PK), MainName, Comments) 2. SetYarnSub (SubId(PK), SubName, MainId(FK), Comments) 3. SetYarnDet (DetId(PK), DetName,SubId(FK),MainId(FK), Comments) 4. SetYarnGrp (GrpId(PK), GrpName, DetId(FK),SubId(FK),MainId(FK), Comments) 5. SetYarn (YarnId(PK),YarnName,GrpId(FK),DetId(FK),SubId(FK),MainId(FK),Comments) **These Tables doesnt have Identity Column** Lets take 2 tables SetYarnMain and …
Hi, I need to create windows services that will back up MS SQL database. Parameter should be time period when I want to backup database (for example every hours, every 2 hours etc). I haven't any experience with backing up database. Once I made WCF service. How can I do …
I am new to sql.i am little bit confused in the concept of group by. Please suggest me online sites.books for detailed knowledge of sql i have 2 tables 1)emp :empid empname empphone dept_id 2)dept :dept_id,dept_name select dept_id,count(*) from emp group by dept_id; its give the expected result. dept_id count(*) …
hi.. i want to compare two tables ..in enlistment table will count the number of students that enlisted to the YearLEvel and section selected by user.. then i want to limit that by means of calling it from the table of Schedulings (AvailableSlots Table) here's my code but it doesnt …
hello all! I have this SQL code that I am supposed to write and am worried that my code may be wrong. I am fairly confident that the first 2 questions are correct but after that......who knows! I have attached an ER diagram( which is acutally really messed up...but whatever) …
I need to have a text field in a search form that pulls from our DB, to default to uppercase for the search. I tried to use java script in the html part of the form for that field but it bombs out after you submit the search. Here is …
hi there! can you please help me? this codes doesnt have any reponse from the database .. these codes is for case sensitivity of the usernametxtbox and if satisfied, the secretquestion textbox will automatically display the correct secret question. help me pls! Dim i As Integer Dim PassResult As String …
The below code was written to bind the datatable to the grid, but i am unable to fill the grid.... I am unable to fill the datagrid, I'll be very thankfull for your help. Private Sub BindGrid() Dim CMD As New SqlCommand Dim ad As New SqlDataAdapter(CMD) Dim DT As …
Hey guys, I urgently need your help. Just stuck in the develpment of my website. My problem is as follows:- I am using asp:hyperlink in my masterpage as-- <asp:HyperLink ID="HyperLink9" runat="server" Text="Expert" Font-Underline="False" ForeColor="White" NavigateUrl="~/exam.aspx?cat=css_ex" ToolTip="Expert in CSS?"></asp:HyperLink> and in exam.aspx page , i am retrieving the values from exam …
I have a database with structure like users: usr_id usr_fname usr_lname usr_uname usr_pass organizarion: org_id org_name org_address org_tel org_web org_email org_cat org_desc departments: dpt_id dpt_name dpt_desc sections: sec_id sec_dpt_id sec_name sec_desc designations: dsg_id dsg_sec_id dsg_name dsg_desc employee: emp_id emp_fname emp_lname emp_phone emp_email emp_addr emp_join_dt emp_salary emp_card_no emp_dsg_id emp_sft_id shifts: sft_id …
I am using getRow() method of ResultSet class like: int rowCount = result.getRow(); but when i run the application, it gives me the exception that says: *The 'getRow()' method is only allowed on scroll cursors.* Please, anyone, who knows why it happened, explain it with some possible solutions Thanks!
i need to compare two different tables which are Enlistment and Schedulings Table . in schedulings Table , there was a columnnmae AvailableSlots wherein the AvailableSlots in every sections in every year is recorded.. in Enlistment table, i used to count the number of records that satisfy my query : …
I have an asp.net griedview that includes a radio button. My application can sucessfully retrieve data and display it in the gridview. But when I select the radio button that corresponds to the row I want to delete and click the delete button, I get the following error: "Input string …
I want to update my database but the problem is that the driver is not taking any values from the preparedStatement. I am getting an error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] You must enter a value in the 'ClassicRoom.Occupy' field. Press any key to continue... Here is the ActionPerformed …
Hey guys, My name is Dane and I am an 18 year old I.T Apprentice based in Blackpool. Our I.T manager has gone on holiday and I have had a call giving a deadline on getting a form on our intranet working, I look and it is all ColdFusion! I …
Im uploading student details that are tab seperated within a text file. If a submitted ID was added sucessfully to the database i want to add the submitted details to a gridview to allow the admin to see the total of submitted students. //student details from the submitted text file …
So I am trying to write data to a SQL directory the code is suppose to take a finger print and store it in a directory and for some reason the data in the DataRow myRow is always null I have tried everything. sqlCommandText = "select * from xluser where …
I want to create an installer for my vb.net application, i want to have an installer which can install the application as well as the supporitng software (sql server, crystal reports). I have googled alot learned about clickonce & several other things but not able to incorporate the things. Please …
Hey, I'm pulling data from a table, and storing it into a DataRow. Per [MSDN](http://msdn.microsoft.com/en-us/library/system.data.datarow(v=vs.110).aspx) , I should be able to get an item from the row simply by `dRow.Item("time")`, but I only get the option of using ItemsArray. Is there any specific reason this would happen? Thanks. Link to …
Dear All, I have a small probelm with updating my database. Here are my codes ~~~ vb Module AphidSimVar Dim myCon As SqlCeConnection = New SqlCeConnection("Data Source=|DataDirectory|\AphidModel.sdf") Dim myCmd As SqlCeCommand Dim myAdap As SqlCeDataAdapter Dim myDataSet As DataSet Dim myTable As DataTable Dim myBuilder As SqlCeCommandBuilder Public Sub ShowData() …
I have an SQL select statement that I cannot quite get working. Dim SelectStr As String = "SELECT * FROM Appointments WHERE Doctor = '" & ComboBox1.Text & "' AND AptDate = #" & DateTimePicker1.Text & "#" This works perfect ... however I have 2 more WHERE possibilities ... I …
I can't seem to wrap my brain around this one and would really appreciate it if someone has some suggestions! :) I have two tables, one contains a list of locations (AccountLocations), another a list of contacts that belong to those locations (AccountContacts). What I would like to do is …
Can anyone help me with importing text file to sql server using vb.net here is my code ~~~ vb Dim ImportedFile As String Dim ImportedLines() As String Dim OneLine() As String Dim strSQL As String Dim i As Integer If My.Computer.FileSystem.FileExists("D:\PPOS\Sales_report\inventory_255503221452_Cake102.CSV") Then ' Read the whole text file ImportedFile = …
Hi, I'm trying to create a form in which a user selects a Customer from a Combo box and then can select a "Dongle" (or Product they have) from a list box. Below is a screen shot of the relationship between the tables.  Also here is a screen …
The End.