[microsoft:sql-server] Forum Topics

I have two radio buttons of male and female, datetimepicker and picturebox. I want to retrieve data in these controls using sql table. for the texbox and combobox i m using this code but for above contriles this is not applicable.. [CODE] while (dtRdr.Read()) { txtdoctorid.Text = Convert.ToInt16(dtRdr[0]).ToString(); txtdoctorname.Text = …

Team - This has to be way more simple that I am getting. Been searching google for hours with no luck. Simply stated, I am trying to delete a datalist row which is bound to a mssql database. Simple right! I am missing where it is putting the key or …

hiya, Please i am a newbie and i am trying to create a database for a Education agency whereby they can retrieve data to go on with the days work. I want to build a database using sql server and it will have a log in page in c# ,so …

Hi, how to do an access right Administrator can add users while the rest of the users can only view the data? Thanks.

Hi, I'm fresher for sql injection, i have already worked and having a good knowledge about the MY sql server 2000, 2005, and 2008. Did anybody can able to give me steps and how to work in sql injection, as a part of testing engineer. Kindly send me the links …

can you plz help me how to create a report in execl from visual basic and sql server 2000...

Can anyone help me solve this error:- Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

i am trying to write a SP that will return a value in vb.net here is my SP CREATE PROCEDURE ClaimTotal @Ctotal BIGINT output AS select SUM(total) from claim where @ctotal = total I want to SUM my total coloum from my table claim, and store this in a varible …

hi can anyone send the link r sample project with asp.net and calling sql server stored procedure i am new for SQL thanks regards suresh.S

Hey guys, I am trying to update the Quantity field in my database on button click. I have a checkout system, and on the final checkout page it displays my basket items in a listview bulleted list. Now say there is 1 item, and the quantity is 5, upon the …

Hi, I'm quite new with Data Adapter on VB.NET. I'm having a problem with retrieving data on different tables. Example database: [QUOTE][B]BookInfo[/B][INDENT]BookID: HSD993Z Title: Introduction to SQL[/INDENT] [INDENT]BookID: LDJA293 Title: Advance Computer Programming[/INDENT] [INDENT]BookID: KSKL194 Title: Object Oriented Programming[/INDENT] [B]StudentInfo[/B] [INDENT]StudentID: 2938485 FullName: Michael Zip[/INDENT] [INDENT]StudentID: 2949284 FullName: Ray Williams[/INDENT] …

IIf(Time()>=TimeValue("00:00:00");IIf(Time()<=TimeValue("07:00:00");Format(Now()-1;"dd mm yyyy");Format(Now();"dd mm yyyy")))

Okay, I have a table called InGameTime with the following columns: CharName varchar(30) InTime datetime OutTime datetime HH int MM int SS int I am trying to make a trigger, that will once data is updated, it will update the HH,MM,SS to add the total hours, minutes, seconds spent in …

I've been looking all day for a way to somehow save a TabPage containing runtime-added images and controls (the user can move them in the TabPage) so that they can be used later. I tried using serialization but it seams that you can't serialize interfaces. I'm using a SqlCe database …

Column A (datetime) ----------------------- 2011-04-01 00:00:00.000 2011-04-01 00:00:00.000 2011-04-09 00:00:00.000 2011-04-01 00:00:00.000 2011-03-31 00:00:00.000 Column B (datetime) ----------------------- 2011-03-25 15:45:56.457 2011-03-25 15:52:37.933 2011-03-25 15:54:37.197 2011-03-25 16:05:30.023 2011-03-27 00:43:23.713 When i try to query the above record [CODE] Select * from table where A between '1900-01-01' and '2012-01-01' [/CODE] this work …

Hi someone help in distinct command i have created 2 tables department and balance, 1. Department dep_id, dep_code, dep_name 2 001 Bloom Room 3 002 Tahmeco Th 4 003 Kniting 2. Balance dep_id, Date, Amount 2 01/Mar/2011 10000 3 02/Mar/2011 15000 4 20/Mar/2011 25000 3 22/Mar/2011 10000 2 26/Apr/2011 27000 …

Hi! i just learned howto create a simple webpage displaying some database records on it. i know how to bind the database to a grid control and display data. But how can i search for some value in the database? i know SqlDataSource.Insert() method inserts data into the database. What …

Please help me.. i am stuck with this one... i have a a field(TotalAmount) in Table(Deposits) when i run this stored proc when i put @TotalAmount = 5000.00 the table became 5.00 i tried everything, still not working properly... thank u :) [CODE] ALTER PROCEDURE [General].[EditTable] -- Add the parameters …

I wasn't sure which section to post this under but I am working on an assignment in SQL and have created a batch file to make the tables, load the data into the tables, and then sends several queries to sql to get results. Is there a way I can …

my code is working fine, but the output shows for example 12345.000 i would like to only show the data before the .000 is this posible? [CODE] Private Sub GetCurrentJanVOL() Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString = "Data Source=" & ServerV & ";Initial Catalog=" …

[ICODE]<html xmlns="http://www.w3.org/1999/xhtml" > <head> <title>PicNet Table Filter Demo</title> <script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.3.2.min.js" type="text/javascript"></script> <script type="text/javascript" src="picnet.table.filter.min.js"></script> <script type="text/javascript"> $(document).ready(function() { // Randomly Create Data Rows for (var i = 0; i < 50; i++) { var tr = $("<tr>" + "<td>Value" + Math.floor(Math.random() * 500) + "</td>" + "<td>" + Math.floor(Math.random() * …

Hi folks, So let me do a quick introduction of myself. My name is Leroy and my alias is heinzel. In my daily job I am a system developer for database driven applications and am mostly into programming database environments like MS sql server through transact-sql for the back-end and …

Hello to all, I got problem in my vb.net program in publishing it. I am using Microsoft Visual Studio 2008, when I publish my program and I got the setup file and when i tried to run into another computer I got some error saying that it cant connect into …

i have to show data in datagrid using store procedure...but remember...i m using store procure in seprate class so i m facing difficulties.. how to do it.. thats my class coding... but how to pass it in main form? public Searching() { Myconnection = new SqlConnection("Data Source=.;Initial Catalog=Bahria_Managment;Integrated Security=True"); } …

Hi. My problem is, the data that I pull from the database, when try to multiply it, it didn't multiply. The database has Fruit and FruitPrice column. When select fruit form the combo box, it will search the price. But I can't seem to multiply it. The price is display …

I am building a database using SQL that assigns a value to a field based on a set of about 41 criteria. To give an example, the value for a field is set to A when X Y Z and W are present, but is B when only W X …

I have a search form there is a search textbox for search by name. i want when i type any text onto the textbox then the names shows on listbox. and when i click on any name of list box then all data related to this name fill on textbox, …

Hi, how do i do this:- The dyndns that allows Admin to get result from different location. No need to get the database over from another location, able to view the report and print. Using VB.net and SQL Server 2008

Right now we're having an issue with SQL, it's currently using 1.7GB of memory, and with the size and usage of our application, this isn't always enough. The server it's on is a 32 bit Windows Server 2003 Enterprise Edition, with 15.9GB of RAM. Is there any way to break …

Does anyone know how to turn this excel function into an sql statement? The function looks at my address and route. If it is different than the one prior it increments column G by 1 if it is the same it keeps column G as the same number. Ive been …

I created the following tables and inserted few values. create table books(bookid integer primary key, booktitle varchar(20), year integer, publisherid integer foreign key references publisher(publisherid), price integer, number integer) create table publisher(publisherid integer primary key, publishername varchar(20)) create table author(authorid integer primary key, authorname varchar(20)) create table bookauthor(bookid integer foreign …

can anyone tell me what's the wrong in the code.............when i run this........the updation is not working [CODE] string sq1; SqlCommand cmd1; SqlDataReader rd1; SqlConnection cn; cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=J:\\Rcar\\motion\\db_image.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"); cn.Open(); sq1= "SELECT * FROM Customers"; cmd1 = new SqlCommand(sq1,cn); rd1 = cmd1.ExecuteReader(); //while (rd1.Read()) // …

i have the following code that isn't working correct [CODE] Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString = "Data Source=" & ServerV & ";Initial Catalog=" & databaseV & ";Persist Security Info=True;User ID=" & usernameV & ";Password=" & passwordV & "" con.Open() cmd.Connection = con cmd.CommandText …

[CODE]hey i am designing a Registration Page. In that i am having 3 comboboxes, one for country,one for state & last one for city. I am able to display all countries, states & cities entries from database. Here is my code. SqlDataAdapter da = new SqlDataAdapter("select * from Country","Data Source=.;Initial …

how to insert the values of checkbox and radiobuttons in the sql databse using vb.net??? we are getting problem in inserting and don't know what to do................ like i have one form with two text boxes named username and password and one label say gender....which has two checkboxes male and …

I've used this many times and it's always worked, however for some reason I'm missing something. [CODE]$ddType_query="SELECT DISTINCT Type from dbo.LTN_HARDWARE"; $ddType_result=odbc_exec($conn, $ddType_query); while ($ddTypeOptionsRows = odbc_fetch_array($ddType_result)) { //echo $ddTypeOptionsRows['Type'], "\n"; $ddTypeOptions = $ddTypeOptionsRows['Type'] ; } odbc_close($conn);[/CODE] I'm trying to get the $ddTypeOptions to contain all the distinct results of …

Ok, so after hours and hours of testing and searching online I'm almost convinced that this can't be done, but I'm asking here for help maybe someone can give me any idea as to why this isn't working. I'm doing this query: [CODE]SELECT * FROM( (SELECT t1.PAG5 from table1 t1 …

here table is creating but the values is not inserting [CODE] private void button_Click(object sender, EventArgs e) { SqlConnection cn; cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=J:\\Rcar\\motion\\db_image.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"); if (cn.State==ConnectionState.Closed) { cn.Open(); } SqlCommand cmd; string sq1; sq1 = "CREATE TABLE [" +Box1.Text+ "] (name CHAR(50) PRIMARY KEY," +"id CHAR(15), …

[CODE] SqlConnection cn; cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=J:\\Rcar\\motion\\db_image.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"); if (cn.State==ConnectionState.Closed) { cn.Open(); } SqlCommand cmd; string sq1; sq1 = "CREATE TABLE [B]"+TextBox1.Text+"[/B](myId INTEGER CONSTRAINT PKeyMyId PRIMARY KEY," +"myName CHAR(50), myAddress CHAR(255), myBalance FLOAT)"; cmd = new SqlCommand(sq1, cn); try { cmd.ExecuteNonQuery(); MessageBox.Show("Table Created"); } catch (SqlException sqlexception) …

Hi guys wanna ask the experts how to deploy or to distribute the completed application in clients' machine in vb.net.. what if the dbms used in sql server 2005.. how about ms access. hope you'll help me with this. Blessings, Say

I have a form form1 and there is a search button for searching the doctor when i click search button then a new form opens i.e. form2 and in form2 there is a data grid view control and i want when i select any doctor and click on apply button …

I have a form form1 and there is a search button for searching the doctor when i click search button then a new form opens i.e. form2 and in form2 there is a data grid view control and i want when i select any doctor and click on apply button …

I am having a form through which user will enter empcode(checking whether it is present in the table) When i click On Login i am getting the following error [B]Invalid column name[/B] [B]cmd.CommandText = "select employee_code from MST_Employee where employee_code = " + emp_code; [/B] In the above select i …

I got error invalid column 'A1009' string v11; chk1 = "select Sno from Student where SID = "+ @smemno.Text.ToString(); SqlCommand ck1 = new SqlCommand(chk1, cn); [COLOR="Red"]v11 = (string)ck1.ExecuteScalar();[/COLOR] what should i do please help me....

Hello people, I have an application that updates a table. In this application i have a combobox where i load id of record on form load. Let me paste my code to be more clear about my problem. [CODE] Private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string q = "Select …

[code] <% if (this._arr_design.Count > 0) { %> <% foreach (Ameronix.Teeone.Models.Design obj_design in this._arr_design) { %> <tr> <td style="width: 254px; height: 27px;"><%= obj_design.name_design.ToString() %> <div class="thumbnails"> <% foreach (System.Collections.Generic.KeyValuePair<int, Ameronix.Teeone.Models.DesignSection> kvp in obj_design.arr_design_section) { %> <div class="thumbnail"><a href="/snapshots/processed/designs/<%= obj_design.id_design %>_<%= kvp.Value.id_design_section %>.jpg" rel="lightbox"><img src="../resources/get_image.aspx?src=/snapshots/processed/designs/<%= obj_design.id_design %>_<%= kvp.Value.id_design_section %>.jpg&width=50&height=50" /></a></div> C# …

Copy a table from one database to another database in another ms sql server using sql server management studio : If your table was in the same ms sql server but in another database, you would copy it using t-sql like this : SELECT * INTO NewTable FROM existingdb.dbo.existingtable; However, …

Hi everyone I'm trying to connect and display data in a TDBGrid (component) from an .mdf (made in sql) and connect it to a Delphi application. the .mdf is on the desktop and my databases name is Attach. If anyone has any clues or advice please let me know! Many …

Hi there, Im getting the error above, when i run my code. [code] string myCommand = "SELECT * FROM Manager WHERE UserName=" + ID; SqlDataAdapter da = new SqlDataAdapter(myCommand, con); DataSet ds = new DataSet(); try { con.Open(); da.Fill(ds); [B]// <- highlighting this part of the code..[/B] } finally { …

Sir, i am in a trouble and i need some suggestion from you. I have used a sql query and have successfully showed the results in a JTable from the database. Now, what i needed is that after clicking a JButton which in a JPanel i need to show different …