9,022 Topics
protected void Button1_Click(object sender, EventArgs e) { try { SqlAddGroup.InsertParameters["mem_email"].DefaultValue = Session["User"].ToString(); SqlAddGroup.InsertParameters["groupname"].DefaultValue = Txtgroup.Text; SqlAddGroup.Insert(); Label1.Text = "Group has been added"; } catch (Exception ex) { Label1.Text = ex.Message; } } <asp:SqlDataSource ID="SqlAddGroup" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:PadmaSMSConnectionString %>" DeleteCommand="DELETE FROM [group] WHERE [sno] = @original_sno AND [mem_email] = @original_mem_email …
Hi, These are the opening lines of my code USE myDatabase GO PRINT '@@FETCH_STATUS: ' + CAST(@@FETCH_STATUS AS nvarchar(30)) This returns FETCH_STATUS as -1. I have just opened the connection. Can anyone tell me why this is occuring?
Hi guys I got a table called rc_Pages then I got a column called pName (Pages Name) and now I have made a new column called pCategory (Page Category). Since there are like 60 pages and updating the pages manually can be a big issue. I need to set the …
Hi everyone, Ok, Im new to the forum so I hope I've placed the question in the right place, and here it is : I am developing a silverlight application that uses Bing Maps. The Idea behind the application is that to help land owners (farmers , agronomy businessmen) visualize, …
With both subs you must enter the values as you would write them into a sql string i.e. 'mustsurroundstrings' I'm rather new at VB.Net and SQL but these work for me and are seem pretty efficient. If anyone has a way to improve on them or finds a flaw in …
Id like to know, if say i have a data grid that is connected to a sql database, it displays the table columns once a user enters a search. eg;(in your sql table colnm names are member_name,m_address). Now instead of display those names from the sql, can it display your …
Eventually i want to load names from a database to textboxes which are created at runtime. Thought i'd try just getting names into a listbox first though as i'm new to using databases in vb and for some reason nothings getting added to the listbox Heres the code iv'e got …
OK so I made a website http://www.thecodinguys.net now code is displayed in <table class="code"> my friend said I should use <pre> because pre is for code/preformatted text. Now I use a CMS and the data is stored in a table. The content is stored in a column call pText. Is …
i was wondering how can database replication on a sql server be accomplished?
Hi friend, i am trying to learn ASP but i face problem to connect ASP wtih SQL Server. Anyone help me. Sushil ..
how to delete duplicate record in a table by using SQL query
Id like to know, if say i have a data grid that is connected to a sql database, it displays the table columns once a user enters a search. eg;(in your sql table colnm names are member_name,m_address). Now instead of display those names from the sql, can it display your …
i developed a payroll running in VB6 and using SQL 2000 Database, and when i install it on my laptop with windows 7, it gives me an error message 'You dont have permission to perform this operation'. Im logged in as administrator.
Hi I am basically designing a database to store our development team metrics...here are some of my tables. What do you guys think? I am having a lot of trouble coding this on SQL Server so that question is asked towards the bottom :). ProductTable: productID (PK) productDescription SprintTable: sprintID …
ok, I have what I hope is an easy problem to fix. i'm try to query a db, store to a temp table, and then query the same db, inner joined with first query. please help. I'm currently getting "access cant find table/query" error. I've tried putting quotes around tmp, …
Dear all; I have using VB.Net and sql server to develop an application. In the form I use controls to move record like First Rec, Previous Rec, Next Rec, Last Rec. But I'm not using Navigator Binding control. It's mean I use code to move.Anyone can help me, please. Thank! …
hello ! may God bless all of you, i m good in mssql , but this is very first time that i am very confuse , the case is , i have a table , having fields 1- ContactPersonId 2- Name and 2nd table having fields 1- recId 2- ContactPersonId …
I have a bunch of records that I get from doing multiple joins. # Name, ID, Date, Gender, Birthday # John Doe 111 01/02/2003 M 01/01/2001 Jane Doe 222 03/04/2005 F 02/02/2002 Jane Doe 222 **03/05/2005** F 02/02/2002 Jim Doe 333 07/08/2009 M 10/11/2012 What I am trying to get …
Hi Everyone, I am facing the following problem: My connection to SQL Server 2000 (Enterprise Edition with sp4) is fluctuating a lot. It gets disconnected after one or two hours and remained so for 2 - 3 minutes and again re-establish or sometimes I need to restart the SQL Server …
Hi I have databse having id and name field. In that I wanted to fetch random names from that database but the records which fetch in 1 st attempt wpuld not repeat in next attempt. May be this can be done by using some stored precedure or something else i.e. …
Dear all programmer; I build an application using vb.net and sql sever. I want to create auto number increasement like (STAFF-0001). For STAFF-000 mean like default value and number is increasement. example: STAFF-0001, STAFF-0002, STAFF-0003. Please help me thank. Best regard, Kimlong
Dear Expertise, I am problem with coding to search the data from database using stored procedure and vb.net form. I am coding with vb language not the C#. Explanation: I have stored procedure named "usp_GetPayByGrade" : /* Name: usp_GetPayByGrade Description: Search the Record to dbo.hrGradePayScale table by gpsIntGrade Author: Tashi …
Hello, I have a MSSQL database with a table called "people" and a table called "attendance". The people table contains the person's ID (primary key, identity increment), last name, first name, and active fields (I would only be interested in grabbing fields where active = Yes). The attendance table contains …
Hello, I have a few charts on my web form. they ar eall working apart from one! my code thats populating the cart is as follows Protected Sub ddlUserBm_SelectedIndexChanged(sender As Object, e As System.EventArgs) Handles ddlUserBm.SelectedIndexChanged Dim USerBM As String = ddlUserBm.SelectedValue con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = ../SR.mdb" sql = …
// This code is not solving my problem .Data redundency still exist... lblresult.Text always give 0 :( int count=0 ; string selectSQL = "SELECT Equipment_Name,Vendor_Name FROM CatC"; SqlConnection myConn = new SqlConnection(); myConn.ConnectionString = "Data Source=.;Initial Catalog=ecsd1;User ID=sa;Password=786"; myConn.Open(); SqlCommand cmd1 = new SqlCommand(selectSQL, myConn); SqlDataReader reader; try { myConn.Open(); …
Anybody have manage to install PeopleSoft HCM9.1 or other 9.1 module using SQL Server 2008 or R2 on Windows 7 OS on their laptop? If yes, please provide the steps and details specially input param for each steps. Also include installation of SQLServer and details including configuring Data Sourse/SYS DNS. …
Hi guys Our college has a website(php, html, css) that is hosted elsewhere, but now we have a college database (mssql) on a local server and the Director wants me to link the website to the database at the college's server. Any ideas on how to do that? thanks in …
Hello Friends, Can anyone tell me how to find the list of SQL servers on the local machine...and not the network... I searched in google but everywhere its for the list of SQL servers on network....I just want my PC SQL server name.... Is it possible to get it? Thanks …
I have tried using the following it saves the data but the data is not visible in database i have attached the Screen SHot of the database below. i am pasting my code below. Kindly help me out as m not getting what to do further.  Private Sub …
In my script, I have a table displaying the results of a SQL query. However, I am using the results as a sumamary, but the SQL is making the page display the table as many times as there are results (rows) in the returning SQL that are allowed because of …
Dear All, I want to create a dynamic website with a database. Visual studio 2010, dreamweaver CS5, sql server management studio and all other requirements are installed (like IIS 7). I set the IIS server configuration in dreamweaver cs5. I check simple ASP codes like <%Response.Write ("The time on the …
HI i am getting error on lbl.Visible = true and command.ExecuteNonQuery(); plz check and paste correct coding i doing new project plz help me. protected void Button1_Click1(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=RAVI-PCSQLEXPRESS;Initial Catalog=personals;User ID=sa;password=sa;Integrated Security=True"); SqlDataAdapter da = new SqlDataAdapter(" select * from table_2", conn); …
Guys, current im using MS SQL 2005. today they will change it to MS SQL 2008 express edition. My question are: 1. can I still create SSRS/SSIS. 2. i have existing RDL,RDS file. still can open it to 2008 express. Thanks. Jonel
I have a nightly SSIS package that reorganizes indexes that are between 10% and 40% and then a weekly package that rebuilds for anything over 40%. But Ive noticed a lot of table do not change. Example below my Location table below is just about always at 82%. Am I …
Hi all, Here's to hoping that a SQL Server guru is hiding among the ranks of DaniWeb members. I have two servers, DB01 - the production database server and BKP01 - the backup server, that are in two different geographical locations. Since some queries on DB01 are accessing BKP01 there …
Hi, We have an SQL Server 2000 with one 138GB database currently used. I am worry of the performance because as time goes it becomes slower and slower. So I tried googling out the solution and I found out the DBCC Reindex command. As what I read, first you have …
Is it possible to reuse an identity field value after deleting rows in SQL Server 2005? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I will have these 5 Ids: 1, 2, 3, 4, 5. …
Hey All, Context: I am creating a feed for work, similar to facebooks, that hits the database every 5 seconds to see if an update is made and if so returns the results to the feed. The problem I have is that we have over 35,000 users and if they …
Hello, I want to change the datatype of a field from Varchar to integer in T-SQL. I tried something like Modify like you use in Oracle. ALTER TABLE tablename MODIFY COLUMNNAME Datatype. But its not working in SQL server.. Any thoughts.
I'm bit new to SQL server Express edition. I'v create few databases using sql server management studio. (always i login as windows authentication mode). Those databases are working properly with VB.net. In those databases i've never used username and passwords. But now i want to login as 'SQL Server authentication' …
Well, I can't say it correctly, I'm sure the title is not what I meant, I just didn't know how to say it... But anyways, I inserted some text in a table in a dtabase, for SQL injection reasons, I stripslashed it or should I say "I used real_escape_string" But …
There are 2 servers. (I named those 2 servers in this post as "server1" and "server2". Those 2 servers are link together via VPN) i want to backup server1 data to server2. This should be done automatically in every day in some fix time. I know how to back up …
I was wondering if there is a way to open an SQL file and execute it from a c# application without prior connection to a database and also get the name of the default server that is used when SSMS is opened. at the moment i can open SSMS but …
I created an instance and did some fault while moving the files from one location to other and now the server doesnt start and i need to execute a query in SQL SERVER Management studio in order to open a new query feature it again ask to start the server..the …
hey there, Here's my complete code for a delete button that deletes a record in a Heirachical Flex Grid. Dim rsTour As New ADODB.Recordset Dim cn As New ADODB.Connection Dim strSQL As String cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=" & App.Path & "\Luckshan Tours & Travels.mdb;" & _ "Persist …
i m making website of college in which i have two show the all data of student(student name, course from student table, and faculity from teacher table and result ) after he login his account i have 3 table in sql one is student which have student id, name and …
Guys, Using this query, i got an error. any idea guys. what method should i used for this report. Im using text queries instead of SP. thanks. The variable name '@FromDate' has already been declared. Variable names must be unique within a query batch or stored procedure. Fromdate:'2012/06/01' FromTime:12:00AM Todate:'2012/06/29' …
I have a DataGridView that is attached to a BindingSource that gets data from a SQL Server database. I can populate the DataGridView without a problem. I can even insert/update it without issue if I run the update code from a click event of a button. But where I run …
Suppose I want retrieve values froma table that are greater than 10, should I first store all the values in a list and then check condition of ">10" using any language or should I just just retrieve all values directly from databse using query : `Select id from table where …
hi, i would like to assign the value of a combobox to a variable and use this variable as a parameter on the insert statement.see code below,code 1 works ok,but code 2 brings an error relating to wrong datatype,i cant seem to find where the problem because i think i …
The End.