[microsoft:sql-server] Forum Topics

How can i update data from data grid view into SQL database using C#. Actually i m working on windows form app and i have to write update code in click event of the button.I am trying to update single row of data grid view into database. I have tried …

Hello, im trying to insert data to sql server and its not working so well even the code not show any error message or errors on compile. when i check the database......hes empty. Please look at the code for sulotion: [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using …

I want to connect to sql server database from php code. OS: Win xp SP3 PHP ver 5.1.0 Database : SQL server 2005 IIS ver 5.1 What are the drivers needed for the connection to happen? I downloaded the php_sqlsrv_52_ts.dll and tried with it. It doesn't work.I think its for …

hello, I am saving some data in sql of type datetime but the value I am getting is 1900-01-02 00:00:00.000 what must I do?

what sql command i must use. this is my current command but it give me an error saying "The specified filed 'ClientNo' could refer to more than one table listed in the FROM clause of your sql statemate." Try dc.Connection = conn dc.CommandText = "SELECT * FROM tblClient, tblClientInfo WHERE …

AM I doing the right syntax for this parameter? da.SelectCommand = new SqlCommand("SELECT Member.MemberID, Member.Name , Member.Surname, Rentals.RentalID FROM Member,Rentals WHERE Member.MemberID = (@MemberID) Rentals.MemberID", c); da.SelectCommand.Parameters.Add("MemberID", SqlDbType.VarChar).Value = txtID.Text; ds.Clear(); da.Fill(ds); dtgv1.DataSource = ds; It is giving me an error "Incorrect syntax near 'Rentals'." Thanks

I am getting an error that is"Invalid object name 't_Images' " here is my code: SqlConnection s = new SqlConnection(con); s.Open(); byte[] data; using (System.IO.MemoryStream stream = new System.IO.MemoryStream()) { video.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp); data = stream.ToArray(); } SqlCommand s_Com = new SqlCommand("INSERT INTO t_Images (Image_ID,Image)"+" VALUES (1,@data) ; ", s); SqlParameter …

protected void Button1_Click1(object sender, EventArgs e) { string sql = "INSERT INTO user(CustomerName,Age,Sex,Email address,State,City,Country) VALUES (@Val1,@Val2,@val3,@val4,@val5,@val6,@val7,@val8,@val9,@val10)"; try { SqlConn.Open(); SqlCommand cmd = new SqlCommand(sql, SqlConn); cmd.Parameters.AddWithValue("@Val1", txtcname.Text.ToString().Trim()); cmd.Parameters.AddWithValue("@Val2", txtAge.Text.ToString().Trim()); cmd.Parameters.AddWithValue("@Val3", txtsex.Text.ToString().Trim()); cmd.Parameters.AddWithValue("@Val4", txtEmail.Text.ToString().Trim()); cmd.Parameters.AddWithValue("@Val5", txtaddress.Text.ToString().Trim()); cmd.Parameters.AddWithValue("@val6", DrpState.SelectedItem.ToString().Trim()); cmd.Parameters.AddWithValue("@Val7", DrpCity.SelectedItem.ToString().Trim()); cmd.Parameters.AddWithValue("@Val7", DrpCountry.SelectedItem.ToString().Trim()); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { …

Hi all, I have two tables in SQL Server : Rent and Member . And they are in a relationship. Member ID (from Memner table) is in the table of Rent. I would like to know if there is a way that when I view a new Rent in the …

hi, This is a bit complex.. I have 2 nested repeaters.. and 3 datasources(in markup) <asp:SqlDataSource ID=data1 runat=server ConnectionString="<%$connectionstrings:MainServer %>" SelectCommand="select MatrixRiskFactorId,Name,MaxWeight from Matrixriskfactor" ></asp:SqlDataSource> <asp:SqlDataSource ID=data2 runat=server ConnectionString="<%$connectionstrings:MainServer %>" SelectCommand="select * from MatrixQuestion" ></asp:SqlDataSource> <asp:SqlDataSource ID=data3 runat=server ConnectionString="<%$connectionstrings:MainServer %>" SelectCommand = "select MatrixRiskFactorId,Value,text from MatrixRiskFactorScore where MatrixRiskFactorId=2"> <repeater id=rep1 …

>could someone help me out of this code i have a problem the quoted input text could not be print see my codes `function generate_table(){ $query = "select id,branchcode,accountno,accountname,naturalaccount,mname,placeholder,design,elevel from account_codes"; $result = mssql_query($query); $index = 0; while($result_row=mssql_fetch_array($result)){ $index++; echo '<tr> <td><input size="2" type="hidden" value="'.$result_row['id'].'" name="did'.$index.'" id="did'.$index.'" disabled="disabled"/>'; echo '<select …

Dear developers... I have problem with code... I cant understand where is mistake... here is my code... [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.Sql; using System.Data.SqlClient; namespace Phon_Imenik { public partial class Form1 : Form { public Form1() { …

"UPDATE P SET Stock = T.Stock FROM prices P INNER JOIN #prices " + "T ON P.Avg = T.Avg AND P.Colour = T.Colour;" + " " + "INSERT INTO prices(Avg, Colour, Stock) SELECT T.Avg, T.Colour, T.Stock FROM #prices T " + "WHERE NOT EXISTS (SELECT 1 FROM prices P WHERE …

I have table of three column like Identifier Description Value P1 x 20 P2 y 20 P3 x 20 P4 y 20 P5 x 20 P6 y 20 P7 x 20 P8 y 20 P9 x 20 y 20 x 20 y 20 x 20 y 20 x 20 y …

Guys hi i need some help here though i fixed the connection with the sql server i tries to see if its correct and look first at the code and i explain m prob: private void lgnBtn_Click(object sender, EventArgs e) { SqlConnection lgnConnection = new SqlConnection(); lgnConnection.ConnectionString="Data Source=.\\SQLEXPRESS;"+"AttachDbFilename=C:\\Users\\ryudo\\Desktop\\workspace\\sql_goldshop_project\\Project1\\Goldshop_Tax\\Goldshop_Tax\\gold_tax.mdf;"+"Integrated Security=True;"+"User Instance=True"; …

Hi, All, Sample Table Job_ID Job_Name Status 1 TEST00001 FOR KE 2 TEST00002 FOR KE 3 TEST00003 FOR KE 4 TEST00004 FOR KE 5 TEST00005 FOR KE I have sql query that will get a jobname where status is equal to 'FOR KE' and I have multiple users that will …

HI All, I have three tables tbl_category, tbl_subcategory, tbl_product . where categoryid is foreign key in subcategory table and subcategoryid is foreign key in prduct table. I want to show category and subcategory on home page menubar. I just reach upto display category on menubar but not able to get …

Hi, Im trying to insert to a table in sql that is related to another by a foreign key. The first table has an ID, a suppliers id and a date; and the other table has an ID (that for some records should have the same id from the other …

How to delete a row from grid view using connectivity code. con = new SqlConnection("Data Source=SPICOM15-PC;Initial Catalog=Student;Integrated Security=True;Pooling=False"); Label lblstid = (Label)GridView1.Rows[e.RowIndex].FindControl("lblId"); TextBox txtname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname"); TextBox txtclassname = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtcity"); TextBox txtemailid = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtEmailId"); cmd.Connection = con; cmd.CommandText = "Update Information set Id='" + txtid.Text + "',Name='" + txtname.Text + …

Hi, I am trying to check if the username entered by the user in the textbox exists in the Access database I am using. For some reason, I am unable to get this correct. My code is as follows: Protected Sub btnRegister_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles …

The query below performs fairly quickly, however when hit by several visitors at once causes the SQL Server CPU to spike greatly. How would you rewrite this query to reduce the impact? SELECT * FROM (SELECT TOP 1 a.adID, a.type, a.position, a.image, a.altText, a.caption, a.link, isNull(v.viewCount, 0) AS viewCount FROM …

Currently I am working on a project regarding C# and SQL and I have a problem regarding the SELECT function and I cannot find any solutions on-line. The scenario is regard searching query from C# through SQL server and display the results in a Data Grid View at C#. I'm …

daniwebbers, This is my issue. I need to back up one server, that has server 2008 r2 installed. It does have sql server 2008 installed, but I successfully back up our databases every day so that is not an issue. In the event viewer this is the error I am …

I am trying to write a query to update multiple tables. Here it is: DECLARE @old_team_id AS int; DECLARE @new_team_id AS int; UPDATE Players SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE managers SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE draft SET owner_id = @newteam_id …

using System; using System.Configuration; using System.Web; using System.IO; using System.Data; using System.Data.SqlClient; public class ShowImage : IHttpHandler { public void ProcessRequest(HttpContext context) { Int32 empno; if (context.Request.QueryString["id"] != null) empno = Convert.ToInt32(context.Request.QueryString["id"]); else throw new ArgumentException("No parameter specified"); context.Response.ContentType = "image/jpeg"; Stream strm = ShowEmpImage(empno); byte[] buffer = new byte[4096]; …

I have read plenty articles on Bool methods that have problems returning a value and i have been having the same problem except I cant see anyway around mine. public bool GetAdministrators(string userName, string password) { SqlConnection conn = new SqlConnection("Data Source=(local); database=ManagementNAV; Integrated Security=True"); SqlCommand cmd = new SqlCommand("GetAdministrators", …

I am trying to insert and retrieve image from sql server into window phone. and the image type would be varbinary. I cant find example for it.. Mostly the related post is about retrieve from url or isolated image.. Any help? Thank you.

Hi, i had developed windows application with SQL Database. i had deployed the windows application and want to run the same on the client machine Could any one please help me in this issue...

Object of type 'System.Web.UI.WebControls.TextBox' cannot be converted to type 'System.Int32' 6 minutes ago|LINK Hi, i started web application in Microsoft Visual Web Developer 2010 Express. I created few text boxes and dropdown lists. I connect them with my database in SQL management studio. When I click on SaveButton it should …

Hello Friends, I need help to get the time value from MSSQL database to VB.Net Datetimepicker I have a datetimepicker but the custom format is set to HH:mm tt so that I can get eg 11:20 AM this value I have stored in database with the help of ` Label4.Text …

Hi I have a real conumdrum here - I just can't expalin this behaviour!! A colleague has designed a view that contains the following : `CONVERT (nvarchar(4),YEAR(dbo.SYSFinancialYear.FinancialYearStartDate)) + N'/' + RIGHT ('00' + RTRIM(CONVERT (nvarchar(2), dbo.SYSAccountingPeriod.PeriodNumber)), 2) As YearPeriod` When you are in the design view, of the view and …

Working with Visual Studio 2008 and accessing SQL Server Compact 2010. Following a programming book and have created a small contacts database. The next lesson requires that the database be dragged onto a form already created. Have not found success in getting the form and the database on to the …

Hi all I've been struggling with this one for some time now and I would realy appreciate some help. I have a string which gets data from mssql server, reader collects data (among others also "person) SQLStr = "select * from tablename order by id desc command = New System.Data.SqlClient.SqlCommand(SQLStr, …

Hello xD First : Im new to c# stuff Im having some windows form app. I read data from datagridview(iv puted in from table..works fine) and i should write it to table in database.. My insert statment doesnt do nothing.. private void button3_Click(object sender, EventArgs e) { int amorplanid = …

REATE TABLE [dbo].[BiddingTable]( [cAuctionId] [int] NULL, [idUserId] [int] NULL, [cItemId] [int] NULL, [vcBidamount] [nvarchar](50) NULL, [vcBidcount] [int] NULL, [bidQty] [varchar](5) NULL, [vcBidtime] [datetime] NULL, [status] [varchar](50) NULL ) ON [PRIMARY] INSERT [dbo].[BiddingTable] ([cAuctionId], [idUserId], [cItemId], [vcBidamount], [vcBidcount], [bidQty], [vcBidtime], [status]) VALUES (10, 36, 21, N'93.6', 1, N'0', CAST(0x0000A05500F83B44 AS DateTime), …

Hello All Just a quick question I am currently thinking of buying a Standard Retail Technet subscription as I am hoping to obtain a qaulification in Windows Server 2008 and some more SQL server qaulification and would also like some hands on experience so I am considering buying a subscription …

Hello community i am new to vb.net and was wondering if anyone had some turtorials as i am trying to create a tool for my job. I would like to create a tool to gather data from sql 2008 by searching a clients name and then pulling the clients record …

Can someone help me with wiring up my search parameters. I have txtboxes on my webpage and a search button. So far I can only search for an ID. How can I expand this to include searching for AssignedTo, Location, Department, Model, InkType, Status, AquiredDate? Here is my code. Can …

Hi all, I am designing a log in page and every day i face a new problem :'( The code now is working fine but i want to add exception to check if the Login Id and the password are not exist in the DB table I tried to put …

Greetings guys, i don't know if this is the right forum to post it so please forgive me if my topic is not related in to this forum. Uhm, i just want to ask about on how to check if i am successfully connected in ms sql 2008 in vb.net …

how can i save multiple record in single click using user define data type in SQL i am having problem in selecting the value in gridview using checkbox here my code View // View LAyer protected void imgbtnSave_Click(object sender, EventArgs e) { DataTable dtTable = new DataTable(); DataRow dtRow = …

Hi, im currently working with an SQL Server 2008 database and im trying to change values in the database usign visual basic. The following code runs correctly and I have tested changing passwords and have been able to logoff and then back on again using the new password. The problem …

Hello Friends, I need to create a report for my project I am using Miscrosoft Visual Studio 2010 and the SAP crystal Report I am not able to set up the connection The SQL server that I am using is not coming in the drop down of the server part …

I am doing a Music store online that does selling of music albums on the internet. I would like to know how to enable a user who, say for example is viewing all my music albums, but is not registerd with my site as yet, but they do place an …

Hi peeps, pls i need help on how to hard code my database connect to my application . Example, i want to connect to my application using dim conn as new SqlConnection conn.ConnectionString = " connSring" dim cmd as new SqlCommand cmd.connection = conn cmd.commandType = commandType.text cmd.commandtext = " …

For my sign up page, i want detect user exist so that no repeated username. BUT fail. There is no error in my coding. BUT cannot detect.... HELP. tHAnk you if (IsPostBack) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString); con.Open(); string cmdStr = "Select count(*) from Reg where Username = '" …

Hi, I have a static sqlparameter default value which I need to display in a label but I can't get it to work. I tried: lblDefaultRate.Text = SqlDataSource1.SelectParameters["rate"].ToString but didn't work. Any idea what is wrong? Thanks

I want to make a software that takes data from the data base and then manipulate that data and show on screen? What steps should i take?

how to insert special character in sql database like wise" @#$%^&&*" plz mail me ans at salman_hundekar@rediff.com

yow! I have a question. the case is have and email notifacation in my php code in the database(MSSQL) i put an email add these are the two email address Rex.Cam@email.com and rex.cam@email.com the email notication is intended for the email who has a capital letter on the start the …