[microsoft:sql-server] Forum Topics

Hi, I am making a website for Buying Online Books, I am using ASp.Net 2.0 & SQl. Because the Data needs to be updated Regularly, I want to use CMS. And I have No idea about the code part of CMS(means I don't know how to link CMS to my …

hey all... i m in 5th sem engg ....currently i hve undertaken a project under indian army which is like creating a database software for them.....frontend is vb6 and sql....i need ur hlp in the search and view option..... for the search option i need codes to search from the …

Hi Guys My hosting company confirmed that recently it appeared that somebody was trying to hack into my website. I was able to confirm the page used but not whether they actually got through - no data in the database was changed. I have never come across this before and …

i have been using adodc for searching for a client's details using the client number, but it would give me inexpected errors and bomb out of my programme. i have then resorted to searching using sql. the following code gives me this error::: [I][U]no value given for one or more …

Hello, I would like to know if there is an easy way to transform the following table CarId | PropertyName | PropertyValue 1 | Size | XL 1 | Name | Porsche 1 | Color | Red 2 | Size | XS 2 | Name | Smart 3 | Name …

[code] <connectionStrings> <add name="ConnectionString" connectionString="Data Source=(local);Initial catalog=sonia;User ID=sonia;Password=sonia;" providerName="System.Data.SqlClient"/> </connectionStrings> [/code] [code] public partial class Frmgrid : System.Web.UI.Page { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlDataAdapter da; DataSet ds; protected void Page_Load(object sender, EventArgs e) { try { da = new SqlDataAdapter("SELECT * FROM Products", conn); da.Fill(ds, "tb1"); DropDownList1.DataSource = ds.Tables["tb1"]; …

Hi, I have problem, i have designed a web page in asp.net 3.5. I have a TextBox and a button, the User is expected to write some comment in the TextBox. The TextBox can also have a comment pattern including a (') on the click of button the data in …

Hi.. I want to create a seperate DataAccessLayer and do the inserting,updating...etc to a database.Actually I'm new to .net things. I did it as below.But the database is not updated at all.. This is the DataAccessLayer class... [CODE] using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace ClassTest …

Hi Guys, I am using sql in and am stuck. after "selecting * from table", how do i store whatever I have obtained from my database in a variable, for display? Thanks.

Hi I developed report using sql server reporting service.I used parameter to assign value for sql query.I want to use "LIKE" keyword in using parameter,How i do that?i wrote coding below what u wrote before.I used @con as parameter. [COde=sql]Select FriutID from Friut where friutName like'@con'%.[/COde] Once I write above …

Hello everybody, Hope everyone is fine over here. Well .. actually, i am developing a networking application, or a client-server application where many clients on a LAN will connect to the server. Actually I am a bit confused with the database part, one of the features of my application is …

I am a new SQL user and I have created my code but when I execute it I get this error : [COLOR="Red"]Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Job_Title' in the database.[/COLOR] I do not understand why I keep getting this same …

Hi, I have just switched to IIS 6.0 in windows server 2003 sp2 from IIS 5.1 in Windows xp ,I have problems with configuring the website on the IIS , I have given the directory path, given it IP address ,given default document. but when I try to access the …

[B]I am trying to prepare a report detailing all jobs entered into program sorted by customer and then by project name. Also produce a report for total products for all projects in database.[/B] I am able to create diferent classess (Component) for all my formular product calculations and then reference …

Hi, i have created a sp, that is taking too much time (more than 35 sec, is it more?). [Code] SELECT top 11 ROW_NUMBER() OVER (ORDER BY hjs_job_details.date_posted desc, KEY_TBL.RANK desc) AS Row, job_id, (case when len(job_title)>59 then (substring(job_title,0,59)+'...') else job_title end ) as title, company_name as Source_Org, source_company_name as …

Hi, Im new in C#, could you help with my codes. I need to connect to MS SQL DB (2000) and need to call Stored Proc to return value. Here is my codes: [CODE][COLOR="Green"]private void ExecuteStoredProcs() { SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); SqlCommand getRequestCmd = new SqlCommand(SP, …

I am just new in C#, somebody can you give me code for MS SQL server connection, on how to call records, add, edit and delete records...THANK YOU

Hi I am trying to insert data into a sql server database table using sqlDataAdapter and adding newrow method.But the values entered are not saved in the database.What I did is............ [CODE] string sql = "Select * from Users"; dataCmd.CommandText = sql; SqlDataAdapter da = new SqlDataAdapter(dataCmd); da.SelectCommand = new …

[CODE]OleDbConnection con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\\incomexp.mdb"); OleDbCommand com; OleDbCommand com = new OleDbCommand("insert into incomeexp values (@year,@month,@data,@bal,@inc_exp)",con); com.Parameters.Add("@year", OleDbType.Integer); com.Parameters["@year"].Value = yr; com.Parameters.Add("@month", OleDbType.Integer); com.Parameters["@month"].Value = mn; com.Parameters.Add("@data", OleDbType.Char); com.Parameters["@data"].Value = s ; com.Parameters.Add("@bal", OleDbType.Decimal ); com.Parameters["@bal"].Value = j ; com.Parameters.Add("@inc_exp", OleDbType.Char); com.Parameters["@inc_exp"].Value = s1 …

PLease help!!!!! How the ... do i fill my dataset with data using sql server, datatable, and adapter... I've passed the select statement [ Select * from [TableName] and a ref of my datagrid to this procedure. Public Sub FillDataGrid(ByRef DataGrid As DataGrid, ByVal SelectCommand As String) Try Dim adSQLAdapter …

I need to know how and what steps to automate to backup a database on my production SQL server and restore that database in my test SQL server. The database exists in both servers currently. I want to set this up so it will run every day at a certain …

I want to select from a table only when a field repeats more than once. For this I have: [CODE]Select title, Count(*) As Cnt From poss_titles where Cnt > 1 Group By Title Order By Cnt desc[/CODE] But it says invalid column name cnt. How should I refer to this …

Hi guys, i've deployed asp application, now the problem im facing is it doesn't connect sql database. At first the database was attached with the application and it failled to connect the database, secondly i attached the database on SQL server and configured connection string still it doesnt connect. When …

Ive downloaded these "would be" awesome controls from the excentric world web site. One of them is calendar pop up. The problem lies in the fact that when i try to insert the data into sql 2005; it inserts "..." instead of the selected value. Anyone know a way around …

In VB.Net 2008 express: I am looking for a way to setup a screen that contains a picture and some information. Hold in place for 10 seconds, change the picture and information and re-display the screen. The information comes from a SQL Server database. I there a way to setup …

Hi! I'm having a problem when generating a crystal report from php. This code works fine when not using connections to ODBC, but when I try to connect i get the error: "Server has not yet been openned". I've tried almost everything, even chaging the dlls but nothing has worked …

I have a table for example: tb1 with data: [CODE]cse-12m cse-343k cse-mka cse-ptu cse-jpy[/CODE] How can I write a SELECT statement to retrieve data in one of these formats: 1) cse-three digits number 2) cse-p% and exclude other format data, any idea?

I want to display the columns in to rows format as below: eg: [U] col 1 [/U] [U]clo 2 [/U] yes No I want this to display as: [U]Column name[/U] yes no The Code which i used as below: [code=sql]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[Vista_Capable] AS …

ok, so here's the deal. i'm a bit confused about .sdf and .mdf files, i know i should post this in databases, but the topic is also relevant here so i'll just get right to it. 1. I'm working on an inventory project which will be a standalone, so i …

hi daniweb... i need some help for my projects...maybe u all can help me.... i want to make a autonumber field in sqlserver and will be reset to 1 every 1st day in a new month....it will be use for document numbering..because i want to make the doc format is …

Hi all, I am trying to get a grasp of web form data getting passed to PHP, then dumped into a SQL Database (2005). I have created the form in html. but because the form is an employee application there are a lot of text boxes, radio button, etc etc. …

Hi,,.. Need hlpe on this. I have 2 columns Oldvalue and newvalue. I want to create a store procedure where the query will be as if oldvalue and new value have record, but both the records are not same then 'change' variable should increment by 1 for each computername, again …

[code] protected void btnLogin_Click(object sender, EventArgs e) { try { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand("SELECT * FROM UserLogin", conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (txtUserName.Text == dr[0].ToString()) { if (txtPassword.Text == dr[1].ToString()) { Response.Redirect("FrmLogin.aspx"); } else { lblError.Text = "UserName & …

I have SQL datasource and all columns are directly displayed in gridview. [CODE] DS_params.SelectCommand = "SELECT ID, ParamName, ParamValue FROM Params WHERE ProductID=" + pid; DS_params.Select(DataSourceSelectArguments.Empty); grid_productdata.DataBind(); [/CODE] The first thing I cannot figure out is how to make some column read-only so it can't be edited, without directly adding …

I'm using this piece of code to get the number of search results. However it says- Incorrect syntax near ')' (the very last ')' ) [CODE] SELECT COUNT(*) FROM (SELECT ID, ProductDescription FROM Products WHERE ProductDescription LIKE '%tech%') [/CODE] The inner select works fine and gives correct results, so I …

Good Day all it is Probably a long day, i cant think Straight now. i have a table that looks like this [CODE] Nodeid Parent Description Type Curr ========================================================================================== 89 NULL Compulsory 1 10 90 89 B1052 3 10 2820 89 One of 2 10 [COLOR="red"] 4113 89 B1061 3 …

hi, can any one tell me how to i use my sql sever's databse itno ms sql 2008 server. I tried to to do dat with the help of mysql backup file & execute it on ms sql server, but there are some syntax related problems. please help me. thanks …

Greetings! I am hoping someone can help me with a MS SQL query/view problem. I am creating a "name my new baby" website where parents can upload a picture of their child and have users cast votes for a good name. Users will see the child's photo and they will …

Hi all, I have a Subscription database running and i am trying to insert values into it from an ASP web form when i click on a button with an id of 'confirm'. The name of the field is 'startdate' (date data type) and i need to enter today's date …

Hi, Hoe to insert multiple selection from checkbox(from jsp) in to one column of the table(sql server database ). Anyone can you help me? Thanx

OK, i have a form with 3 controls. 1 x textbox, and 2 combo boxes. The scenario is like capturing students taking courses in a specified week number. e.g. TxtWeekNo CboCourse TxtStudentName 1 Engineering Joe Bloggs 1 Engineering Jay Rock 1 Law Mary Joe 2 Engineering <Nothing to select!> What …

Hi, I am using vwd 2005 & SQL Server 2000. Now I got 2 problems - 1. How to Copy the SQL Server 2000 Database on Hosting Server(What i mean is where to search SQL 2000 Database file on my local PC)? 2.What Connection String to Use (should work on …

HI I am developing a part of asp.net web site as a training project. My part is creating authentication structure and authorization. Can any body please tell me are there any way to do this except using sql membership provider. Because we have to implement according to the class definitions …

[B][COLOR="Red"]please help me. tell me how to show a table from sql database by button click event in my form[/COLOR][/B]

I made my project in [B]Visual Studio 2005 using C# language[/B] , [B]SQL SERVER 2005 in Backend[/B] and [B]Ado.net connectivity[/B]. [B][I]Now I want o make .exe file (Windows setup file)[/I][/B] But I dont know how to do it, So guys help me .... Thanks in advance....:confused:

Hello, im a little bit new for mobile.NET and tryin to work with sql express data base during my mobile web form. Im tryin to make some contact form and its work great. the data send from the mobile form to the sql contact table. my question is there is …

Can you take a look at this code and see if there is anything obviously wrong with it. It’s just a simple update query to a backend Sybase DB, but it’s not updating and not returning any errors. My updates to an SQL DB are working, so I’m wondering if …

Hi, First of all, I'm no database expert. See me as managing a project where this problem occurs. We are building a system that will enable us to roll out Windows Patches automatically to all Windows systems we manage. We use WSUS on SQL Server 2005/SQL Express. The application will …

[code] public partial class FrmOnline : System.Web.UI.Page { string Query; SqlCommand cmd; SqlConnection conn; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { OpenSQLConnection(); SqlCommand cmd = new SqlCommand("select * from Info1 where UID=1", conn); SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { dr.Read(); TextBox1.Text = dr[0].ToString(); } } …

hi, i am currently working on aptana studio nokia wrt plugin to develop a mobile widget where i need to retrieve data from database. i've created a java servlet in eclipse to connect and execute query to the ms sql server 2005 database. in aptana, i am using js file …