Noob To VWD 2005 - Insert From Textbox Into SQL DB

Feb 9, 2007

I have followed all the tutorials and I think I have a pretty good grasp on how to get info from the SQL database running on my machine in the App Data directory. My question is simple and probably the answer is nested in the 148 pages of this very informative forum.
How do I take the 15 textbox fields worth of data and insert them into the SQL db? I am pretty familiar with general sql concepts (mysql, mssql, postgresql), but I have only been in this IDE for about a week now and I need to get my project up and running quickly. I am just unfamiliar with VB in general, but I do understand the object.method concept.

 I gathered that I need to make the insert statement part of the button click "event". I cannot find any good "starter" documentation on getting this process to work. I understand the grid and form and detail view really well and have tested my 2nd app with success, but it requires the db to be populated by a web front end. I have read a few MSDN links but they are not helping much, they just keep linking me back to grid and detal and form views.

 
Help? Please? Pretty Please?


- Chris
 

View 10 Replies


ADVERTISEMENT

Noob 2005 Version Headaches

Dec 12, 2007

Sorry if this is a very simple couple of questions, i've tried searching the docs but I'm not even sure which docs I should be reading!

We run a few dedicated web servers with our web host. A new one of which has sql server 2005 on it until now we've only ever used 2000.

Anyway I wanted to restore a 2000 database into 2005 and so logged into the machine for the first time, there was no management server installed just Sql Server configuration manager, fine I thought i'd be able to use SQL Express built into visual studio (2008) on my own machine. However when trying to connect I realised I didn't know the admin login details so called the host, they said there are no login details because there is no management software installed on the server and they'll install the Express version. Is this correct? Can you install SQL Server without an administrative login and you then can't connect to it until you've installed the management console?

Secondly, As I mentioned I've got SQL Express installed as part of a visual studio 2008 install, we also have a copy of SQL Server 2005 standard for internal use only, I tried to use this to install the necessary client tools and it tells me I can't because I have a higher version already installed?

Begining to wish I'd taken a look at 2005 much earlier than now as it seems like quite a big jump from 2000 in terms of management and setup...

Any pointers much appreciated.

Dan

View 1 Replies View Related

Cant Insert Decimal From Textbox

Dec 20, 2004

Hi guys.

Hopefully someone can help me, im pulling out my hair over this!

Im trying to insert a price into my MSSQL database.

The Column type is decimal.

If i use the following simple script

<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
Sub Submit_Click(Sender As Object, E As EventArgs)
Dim sqlCmd AS SQLCommand
Dim sqlConn as SQLConnection = New SqlConnection("************;")
Dim mySQL as String = "Insert Into Products (Delivery, Price) Values (" & Dvalue.Text & ", " & Pvalue.Text & ")"
sqlCmd = New SQLCommand(mySQL,sqlConn)
sqlConn.Open()
sqlCmd.ExecuteNonQuery()
sqlConn.Close()
End Sub
</script>
<form action="" runat="server">
Delivery - <asp:TextBox ID="Dvalue" runat="server" /><br>
Price - <asp:TextBox ID="Pvalue" runat="server" /><br>
<Asp:Button id="Submit" runat="server" text="Insert" onclick="Submit_Click" />
</form>

And add in the values as
Delivery - 12.9999
Price - 56.777

The resulting numbers on the database are
Delivery - 13
Price - 57

Im using 1and1 to host my sql database and using their own SQL admin tool to configure it.

The price column has the following options

Name - Price
Type - Decimal
size(if char) - 19 ( i cant seem to change this)
default value - <blank> (I cant seem to change this)

No other options are ticked (as in nullable, indexed, unique key, primary key, identity)

Is there some setting or something ive missed/ dont know about? (ive only really used access and mysql in the past)

I would really appreciate any help

View 7 Replies View Related

Dear Insert In To Database From Textbox In Asp.net

Dec 12, 2006

I have 5 textboxs and 1 botton in web form. I want to click botton and insert all data in textbox to database that using sql server 2005. Please help me

View 1 Replies View Related

Need Help Inserting Data Into Table With Sql Insert Into Using Textbox Values

Oct 6, 2007

the error message I get is
{"Object reference not set to an instance of an object."}
and it points to <  Tickr As String = CType(FindControl("TickerTextbx"), TextBox).Text >   
 this is my code":
 Protected Sub TickMastBtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles TickMastBtn.Click
REM Collect variablesDim Tickr As String = CType(FindControl("TickerTextbx"), TextBox).Text
Dim Comp As String = CType(FindControl("CoTextbx"), TextBox).TextDim Exch As String = CType(FindControl("ExchTextbx"), TextBox).Text
REM Create connection and command objectsDim cn As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataVTRADE.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")Dim cmd As New SqlCommand
cmd.Connection = cn
REM Build our parameterized insert statementDim sql As New StringBuilder
sql.Append("INSERT INTO TickerMaster ")sql.Append("(Ticker,Company,Exchange,) ")sql.Append("VALUES (@Tickr,@Comp,@Exch,)")
cmd.CommandText = sql.ToString
REM Add parameter values to command
REM Parameters used to protect DB from SQL injection attacksWith cmd.Parameters
.Add("Tickr", SqlDbType.Int).Value = Tickr.Add("Comp", SqlDbType.VarChar).Value = Comp
.Add("Exch", SqlDbType.VarChar).Value = Exch
End With
REM Now execute the statement
cn.Open()
cmd.ExecuteNonQuery()
cn.Close()
End Sub

View 3 Replies View Related

HOW DO I: Insert Nulls Into SQL DateTime Field Stored In SQL DB From A Web UI Textbox

Mar 29, 2006

I’m looking for feedback on the Best/Right way to Insert nulls into SQL dateTime field in SQL DB from a web UI textbox.
 
 Option 1:     Presently implemented:
 Dim dtFollowUpDate = IIf(dtDateFollowUp.Text = "", System.Data.SqlTypes.SqlDateTime.Null, dtDateFollowUp.Text)
Although ithis does what is needed it generates the following inner exception
 
ParamValue    {System.Data.SqlTypes.SqlDateTime} Object[System.Data.SqlTypes.SqlDateTime] {System.Data.SqlTypes.SqlDateTime}            System.Data.SqlTypes.SqlDateTimeDayTicks  
<error: an exception of type: {System.Data.SqlTypes.SqlNullValueException} occurred>            Integer IsNull   True     Boolean
 
Option 2:
Dim dtFollowUpDate = IIf(dtDateFollowUp.Text = "", System.DBNull.Value, dtDateFollowUp.Text)
 No exceptions, no problems that I have seen yet.
 
Option 3:
Dim dtNull As System.Data.SqlTypes.INullable
Dim dtFollowUpDate = IIf(dtDateFollowUp.Text = "", dtNull, dtDateFollowUp.Text)
 No exceptions, no problems that I have seen yet.
 
Any advice would be greatly appreciated! 
 
Thanks
 
Craig
CTARP2
 

View 1 Replies View Related

Inserting TextBox Values To Database Using SqlDataSource.Insert Method

Oct 25, 2006

Hi, it is few days I posted here my question, but received no answer. Maybe the problem is just my problem, maybe I put my question some strange way. OK, I try to put it again, more simply. I have few textboxes, their values I need to transport to database. I set SqlDataSource, parameters... and used SqlDataSource.Insert() method. I got NULL values in the database's record. So I tried find problem by using Microsoft's sample code from address http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.insert.aspx. After some changes I tried that code and everything went well, data were put into database. Next step was to separate code beside and structure of page to two separate files followed by new test. Good again, data were delivered to database. Next step: to use MasterPage, very simple, just with one ContentPlaceHolder. After this step the program stoped to deliver data to database and delivers only NULLs to new record. It is exactly the same problem which I have found in my application. The functionless code is here:http://forums.asp.net/thread/1437716.aspx I cannot find any answer this problem on forums worldwide. I cannot believe it is only my problem. I compared html code of two generated pages - with maserPage and without. There are differentions in code in ids' of input fields generated by NET.Framework:Without masterpage:<input name="NazevBox" type="text" id="NazevBox" /><span id="RequiredFieldValidator1" style='color:Red;visibility:hidden;'>Please enter a company name.</span><p><input name="CodeBox" type="text" id="CodeBox" /><span id="RequiredFieldValidator2" style='color:Red;visibility:hidden;'>Please enter a phone number.</span><p><input type="submit" name="Button1" value="Insert New Shipper" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions(&quot;Button1&quot;, &quot;&quot;, true, &quot;&quot;, &quot;&quot;, false, false))" id="Button1" /> With masterpage:<input name="ctl00$Obsah$NazevBox" type="text" id="ctl00_Obsah_NazevBox" /><span id="ctl00_Obsah_RequiredFieldValidator1" style='color:Red;visibility:hidden;'>Please enter a company name.</span><p><input name="ctl00$Obsah$CodeBox" type="text" id="ctl00_Obsah_CodeBox" /><span id="ctl00_Obsah_RequiredFieldValidator2" style='color:Red;visibility:hidden;'>Please enter a phone number.</span><p><input type="submit" name="ctl00$Obsah$Button1" value="Insert New Shipper" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions(&quot;ctl00$Obsah$Button1&quot;, &quot;&quot;, true, &quot;&quot;, &quot;&quot;, false, false))" id="ctl00_Obsah_Button1" />In second case ids' of input fields have different names, but I hope it is inner business of NET.Framework.There must be something I haven't noticed, maybe NET's bug, maybe my own. Thanks for any suggestion.

View 2 Replies View Related

How To Refer To Report Textbox Values In Another Textbox

May 24, 2007

I want to add up the values in a couple of text boxes in another textbox. How do I refer to the textboxes?



fields!textbox1.value doesn't work..what does?

View 1 Replies View Related

Textbox Valiadation In SQLServer/C#2005

Feb 21, 2007

Hi, sorry if this is in the wrong forum
I’m hoping someone can help me with this problem. In theory it’s basic enough but I can’t get my head around it!!!!
I have a basic form that has a drop down list a text box. I’m selecting a static value from a list in the drop down list. Depending on this value I select I enter text into the textbox. What I can’t figure out is how to check/validate the value in the textbox against the value in the database.  I’m using a SqlDataSource connection which takes the parameter entered in the textbox to check the value. It doesn’t seem to send to the database and check the values.
The pieces of code :
 SQL Stmt in SqlDataSource1
SELECT InvoiceNo FROM [Order] WHERE (InvoiceNo = @invoiceno)
code in the invoice no method
string searchby = ddlSearchBy.SelectedValue.ToString();
string invoiceno = txtDetail.Text;
 
if (searchby == ("InvoiceNo"))
{
txtDetail.Text = ("@invoiceno");
 
SqlDataSource tester =SqlDataSource1;
SqlDataReader rdr = null ;
rdr = SqlDataSource1.Select();
 If anyone can help id really appreciate it
 
Thanks
Pete
 

View 3 Replies View Related

Tooltip For A Reporting Service Textbox In Rs 2005

Feb 19, 2008

Hi,

I need to set up tooltip for some images in a reporting service

2005 report. I add some text in image's tooltip property.

However when I move the mouse over the image in the report preview,
it does not show any tooltip. What am I doing wrong?

There is also another property called tooltiplocid.
What is that? when and how should we use it?

Thanks in advance.

View 4 Replies View Related

Reporting Services 2005 Textbox With Html?

Jan 11, 2007

Hi,

Is it possible to insert html into a text control?

I have some records containing html that are saved using a website based on a richText html editor...

How can i send the html to the textbox so that it would render like it is desired?

If by any reason i cannot use html how can i at least specify line breaks and feeds?



Best Regards,

LS

View 1 Replies View Related

Reference Textbox In Other Textbox

Sep 12, 2007

Hi!
I dont know if i will explain this correctly, but my problem is with reporting service.
I'm supposed to Sum value in one textbox and than that sum use it in sum in other textbox.

Something like this:
Sum(Fields!Abc.Value/(Fields!dfg.Value+Sum(Fields!abc.Value)),"matrix1_RowGroup1")*100
I get error msg 'The Value expression for the textbox 'textbox49' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggregate functions.'

Something like this wont work either Sum(Fields!abc.Value/ReportItems("textbox56").Value)*100
Error The Value expression for the textbox 'textbox55' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers.

So, pls help if you know how to reference textbox in other in body of report.
Thx.

View 1 Replies View Related

T-SQL Noob!!!

Dec 21, 2005

In VB, I have this code...


lSQL = "SELECT * FROM OPENQUERY(liorder,'SELECT a.KF_ORDER_NO AS OrdNo, f.KU_NAME AS Customer, " & _
"a.KF_ORDER_POS AS Pos, a.KF_SCHEIB_NR AS Pane, a.KF_QTY AS Qty, d.BREITE*d.HOEHE/1000*a.KF_QTY AS SQM, " & _
"a.KF_QTY*d.SUM_NETTO AS Val, a.KF_FERT_QTY AS Done, d.BREITE*d.HOEHE/1000*a.KF_FERT_QTY AS DoneSQM, " & _
"a.KF_FERT_QTY*d.SUM_NETTO AS DoneVal FROM LIORDER.AUF_KOPF c, LIPROD.KAPA_AUS_FERT a, LIORDER.KUST_ADR f, " & _
"LIORDER.AUF_POS d WHERE (f.KU_VK_EK = 0) AND (a.KF_SCHR_NR = 12) AND (c.AUF_NR = a.KF_ORDER_NO) AND " & _
"(c.KUNR = f.KU_NR) AND (a.KF_ORDER_NO = d.AUF_NR) AND (a.KF_ORDER_POS = d.AUF_POS) AND (f.KU_NAME IS NOT NULL) " & _
"GROUP BY a.KF_ORDER_NO, f.KU_NAME, a.KF_ORDER_POS, a.KF_SCHEIB_NR, a.KF_QTY, d.BREITE, d.HOEHE, a.KF_FERT_QTY, d.SUM_NETTO')"
Set RS = New ADODB.Recordset
RS.Open lSQL, DB

Do While Not RS.EOF
Select Case RS!Pane
Case "0" Or "1"
glassSQL = "SELECT IDNR, GL_BEZ FROM OPENQUERY(liorder, 'SELECT a.IDNR, a.GL_BEZ FROM LIORDER.GLAS_DATEN a, LIORDER.AUF_POS b " & _
"WHERE a.IDNR = b.GLAS1 AND b.AUF_NR = " & RS!OrdNo & " AND b.AUF_POS = " & RS!Pos & "')"
Set glassRS = New ADODB.Recordset
glassRS.Open glassSQL, DB

SQL = "INSERT INTO PendingLamination (OrdNo, Customer, Pos, Code, GlassDesc, Qty, SQM, Val, Done, DoneSQM, DoneVal) " & _
"VALUES ('" & RS!OrdNo & "', '" & Apostrophe(RS!Customer) & "', '" & RS!Pos & "', '" & glassRS!IDNR & "', '" & glassRS!GL_BEZ & _
"', '" & RS!Qty & "', '" & RS!SQM & "', '" & RS!Val & "', '" & RS!Done & "', '" & RS!DoneSQM & "', '" & RS!DoneVal & "')"
DB.Execute SQL
Case "2"
glassSQL = "SELECT IDNR, GL_BEZ FROM OPENQUERY(liorder, 'SELECT a.IDNR, a.GL_BEZ FROM LIORDER.GLAS_DATEN a, LIORDER.AUF_POS b " & _
"WHERE a.IDNR = b.GLAS2 AND b.AUF_NR = " & RS!OrdNo & " AND b.AUF_POS = " & RS!Pos & "')"
Set glassRS = New ADODB.Recordset
glassRS.Open glassSQL, DB

SQL = "INSERT INTO PendingLamination (OrdNo, Customer, Pos, Code, GlassDesc, Qty, SQM, Val, Done, DoneSQM, DoneVal) " & _
"VALUES ('" & RS!OrdNo & "', '" & Apostrophe(RS!Customer) & "', '" & RS!Pos & "', '" & glassRS!IDNR & "', '" & glassRS!GL_BEZ & _
"', '" & RS!Qty & "', '" & RS!SQM & "', '" & RS!Val & "', '" & RS!Done & "', '" & RS!DoneSQM & "', '" & RS!DoneVal & "')"
DB.Execute SQL
Case "3"
glassSQL = "SELECT IDNR, GL_BEZ FROM OPENQUERY(liorder, 'SELECT a.IDNR, a.GL_BEZ FROM LIORDER.GLAS_DATEN a, LIORDER.AUF_POS b " & _
"WHERE a.IDNR = b.GLAS3 AND b.AUF_NR = " & RS!OrdNo & " AND b.AUF_POS = " & RS!Pos & "')"
Set glassRS = New ADODB.Recordset
glassRS.Open glassSQL, DB

SQL = "INSERT INTO PendingLamination (OrdNo, Customer, Pos, Code, GlassDesc, Qty, SQM, Val, Done, DoneSQM, DoneVal) " & _
"VALUES ('" & RS!OrdNo & "', '" & Apostrophe(RS!Customer) & "', '" & RS!Pos & "', '" & glassRS!IDNR & "', '" & glassRS!GL_BEZ & _
"', '" & RS!Qty & "', '" & RS!SQM & "', '" & RS!Val & "', '" & RS!Done & "', '" & RS!DoneSQM & "', '" & RS!DoneVal & "')"
DB.Execute SQL
End Select

ProgressBar1.Value = ProgressBar1.Value + 1

If ProgressBar1.Value = 800 Then
ProgressBar1.Value = 0
End If

RS.MoveNext
Loop

...and I'm planning to use the same flow of logic in the SQL Server Agent using T-SQL. Is there any way I can do it?

View 6 Replies View Related

Noob: How Do I Run Pl/sql On Ms Sql?

Feb 9, 2004

Hi experts,

I'm using MS SQL 2000. The closest i could get to having pl/sql within ms sql was tru its stored procedures feature.

I created a new stored procedure within the built-in Northwind database. I pasted the following inside:

-----------------------------------------------------------------
declare

vname Employees.firstname%TYPE;

begin

SELECT firstname INTO vname FROM Employees
WHERE firstname = 'Nancy';

dbms_output.put_line ('Name is ' || vname);

EXCEPTION

when NO_DATA_FOUND then
dbms_output.put_line ('no data found');

when TOO_MANY_RECORDS then
dbms_output.put_line ('too many records');


END;

-----------------------------------------------------------------


I checked the syntax and i get some error about the employees table.
Error 155: 'Employees' is not a recognized cursor option

Any idea?

Thanks..

View 1 Replies View Related

SQL Noob Needs Help

Aug 25, 2005

Mike writes "I have a string, >!~[99DC# 4.12$2251.% 1.63& 3.58'2150.(-2050.>/~]

and I would like to extract parts of it and send it to a SQL database. here is the layout and data that should be in each column. The Data column will be filled in automatically, but once that happens I would like the other columns to get their data from the Data column.

Data = >!~[99DC# 4.12$2251.% 1.63& 3.58'2150.(-2050.>/~]
Display_Address = 99
CE = 4.12
TPK = 2251
Si= 1.63
C = 3.58
TPL = 2150
TPS = 2050

Can anyone tell me how to do this?"

View 1 Replies View Related

Noob Needs Help!

Jun 7, 2007

/* hi people im doing a task and im not sure about some things. could u check if what im doing is good plz.*/

The task is:
Produce a list of all female employees who earn more than the average salary of the male employees in the company. Display employee number, first name and last name.

The table: emp
Attributes: EMPNO, FIRSTNAME, LASTNAME, SEX, SALARY

What i came up with:
selectempno, firstname, lastname
fromemp
whereavg(salary)>any(selectavg(salary)
fromemp
wheresex='M')
group by sex
havingsex = 'F'

View 3 Replies View Related

Noob SQL Help

Aug 7, 2007

Here is my code to connect, any help would be appreciated. I am a total noob at this.

############### Code

<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="orderofb_test"; // Database name
$tbl_name="orderofb_test.members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from signup form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>


This is the error message I receive.

############### Code

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/orderofb/public_html/php/checklogin.php on line 11
cannot connect


I changed all the permissons to 777 and I still receive this error.

$tbl_name="orderofb_test.members"; // Table name

Is this the correct table name? Here is a pic of my phpmyadmin

http://mnetcs.com/thumb/storage/b3583134.JPG

View 2 Replies View Related

SQL Noob Help Required

Sep 26, 2007

I am trying to create a script that will return information from 4 different tables in a database using different where clauses.

This is working correctly, however the primary table the query uses has multiple entries for different people and i only want to return the last row per person.
I have got this to work using a MAX(t.column) statement, but when used in conjunction with all the where clauses things go wrong.

This is what i have


Code:

CREATE VIEW Firereport1 AS

select max(t.punch_id) as punch, e.EMPLOYEE_FIRSTNAME, e.EMPLOYEE_LASTNAME, c.CLOCK_NAME, t.PUNCH_TIME, d.DEPT2_DESCRIPTION

FROM TM_PUNCH t, EMPLOYEE e, COMM_CLOCK c, DEPT2 d

WHERE t.PUNCH_EMPID = e.EMPLOYEE_ID
and e.EMPLOYEE_ONCLOCK <> 'False'
and e.EMPLOYEE_LASTTIMELOC = c.CLOCK_ID
and e.EMPLOYEE_LASTDEPT2 = d.DEPT2_ID

group by e.EMPLOYEE_FIRSTNAME, e.EMPLOYEE_LASTNAME, c.CLOCK_NAME, t.PUNCH_TIME, d.DEPT2_DESCRIPTION

GO



This returns multiple entries because there are multiple unique entries for t.punch_time.

What i was thinking is i need a where statement on t.time_punch, d.dept2_description, c.clock_name
that says something along the lines of where return t.punch_time where t.punch_id=punch (**substitute correct column names**)

This is a sample of the tm_punch table


Code:



PUNCH_ID PUNCH_SEQNR PUNCH_EMPID PUNCH_DATE PUNCH_TIME PUNCH_MODIFIED PUNCH_PC PUNCH_CLOCKID PUNCH_DATA1 PUNCH_DATA2 PUNCH_DATA3 PROJECT_ID
141 0 52 2007-07-05 00:00:00 603 -1 0 0 0 0 0 NULL
142 0 52 2007-07-05 00:00:00 909 -1 0 0 0 0 0 NULL
143 0 52 2007-07-05 00:00:00 911 -1 0 0 0 0 0 NULL
144 0 52 2007-07-05 00:00:00 914 -1 0 0 0 0 0 NULL




If the query works correctly what should be returned is just the line with id 144

can anyone point out where i'm going wrong

View 3 Replies View Related

A, B And C Are The Same But At Least D Or E Are Different (was Noob Question)

Aug 23, 2006

hi,

just wanted to ask the most efficient way to query for the following:
say i have a table with the following columns A, B, C, D, E.
i want to find the records whose A, B and C are the same but at least D or E are different and then display all the columns (A to E) for these records.
thank you!

g11DB

View 8 Replies View Related

Total Sql Noob Help

Nov 19, 2007

Hi Everybody.

So as the subject states, I'm a total sql noob. I have a database in SQL 2k5 that was transfered over from an acces DB. In the sql db there are a few fields using nvarchar(255) but the data held is actually dates and times. I need to convert these over to datetime format but do no know how. Also, not all rows have a full mm/dd/yyyy hh:mm format. some hold only the date and can be seen as either m/d/yyyy or full out mm/dd/yyyy format. If anyone can help with this that would be great.

Thanks

View 2 Replies View Related

Noob Question

Dec 14, 2007

Hi

I installed sql sever 2005 enterprise edition in my computer.Where is the management studio? Is it a different program? Can I install the express edition of the management studio?Help please.

View 6 Replies View Related

Noob SQL Question

Mar 1, 2008

Ok so i have something like this for a simple quary,

select avg(reorderlevel)/ (avg(QOH)/(avg(reorderlevel)*2)) as "Needed qty",ItemCategory from item
group by ItemCategory



What I basicly need to do is to output the quantity needed for QOH to be 2 times the amount of reorderlevel. then grouped by diffrent catagories.

Anyways I have the formula done and it should work except for some reason "(avg(QOH)/(avg(reorderlevel)*2))" gives me 0 when in fact it should give me 0.728383 or w/e. Im wondering if its omiting the decimals or what??

Because if i run that code it tells me i cant divid by zero

Sorry im new at this and might be doing this all wrong so go easy on me =/

Thanks a lot

View 7 Replies View Related

Noob On Security But...

Apr 30, 2008

Apologies first up -I dont do security so slapped wrists all round, but I have a little situation that I need to take seriously so I thought I'd try do the job right for a change.
Scenario: I have a stored procedure that I want one, and only one, 'thing' to have access to. The 'thing' will be one and only one SSIS package invoked by external scheduling software so basically a call to the dtexec utility to run the package stored in the file system. At runtime therefore, this package has an ExecuteSQL task which connects to the server and runs the sproc. Given windows authentication how do I ensure that the ONLY user allowed to execute the stored procedure is whatever user happens to invoke the package but that this same user can never log in to sql server and execute the stored procedure. In even simpler terms, I want nothing on earth to run that stored procedure nor select the data from the table other than this package when it runs, regardless of who runs it, it is only internal processing by the package that gets the data.

View 1 Replies View Related

Total Noob Can't Get Db Connection......

May 9, 2007

My background is networking with a lot of SQL Server 6.5-2000 dba/sql code thrown in.  I've written some straight ASP pages, some Access DB frontends to SQL etc and I just can't get this .Net stuff.
 I'm trying to work my way thru the getting started vids here and can't get a db connection to the membership db.  I ran the aspnet_regsql.exe to create the db on my sql dev box, and it won't connect.  I've added the code from http://aspnet.4guysfromrolla.com/articles/120705-1.aspx to the web config. 
I erased the connection strings from the web config....I installed SQL 2005 express on my local machine and STILL CAN'T get anything other than can't connect to data store, data store doesn't exit, click here to crash....blah blah blah.
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. 
blah blah 
Test  the AspNetSqlProvider and get
Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
again.
I know the machine itself is fine.  It built the db on both the local machine and the remote sql server.  I can connect to the local and remote sql servers using sql management studio.
Can someone help a brother out?

View 2 Replies View Related

Case Sensitive SQL - Pls Help A Noob

Feb 5, 2005

I just created my first Asp.net app. I had to install it to a corporate server. What I found is that the corporate SQL Server 2000 was case sensitive in the stored procedures while my installation was not!
How can I set my SQL Server 2000 to be case sensitive as well?

View 1 Replies View Related

Please Help A Noob Out In Stored Procedure!

Jul 14, 2005

Hi All,
    I'm a newbie in stored procedure programming. I wanted to learn how to perform keyword(s) search with stored procedures.   Take the Pubs database for example.  How can i create a stored procedure which takes in a string of keywords and return the title_id, title and notes column ?  like if i pass in "computer easy" as keywords then the stored procedure should return all the rows with ANY of these keywords in those 3 columns.  Can anyone give me some ideas on how to do this? like do i have to use dynamic sql?, any tutorials or sample codes? Thanks in advance!regards

View 16 Replies View Related

Noob Question For Msde2000

Apr 20, 2004

looks like a noob question but how can i manage msde2000...i can see sql is runnin but how can i create database , attach/detach database, write functions and so on...

thanx alot for the reply :)

View 2 Replies View Related

Complete Noob Needs A Lot Of Advice

Dec 15, 2005

I was given the task of writing a new website for my boss.
problem being he wants the ability have a custom user signup form and then a picture gallery of service with comments listed off each one.
I was also asked to produce this in .aspx with SQL.
only one small glitch, never worked with either of them....
I have designed most of the database requirements off of examples I found online but have not found how to post data from the users signup form to the database correctly and retrieve it for the customers profile.
any suggestions????
all help on this will be greatly appreciated

View 9 Replies View Related

Noob: Why Does This Query Work?

Jul 23, 2005

I'm wondering how/why this query works. Trying to get my head wrappedaround SQL. Basically the Query deletes from the Import table allrecords that are already in FooStrings so that when I do an insert fromthe FooStringsImport table into the FooStrings table, then I won't getprimary key violations.DELETE FROM FooStringsImportWHERE EXISTS(SELECT * FROM FooStringsWHERE FooStringsImport.FooKey = FooStrings.FooKey)It seems to work fine, but I'm wondering about how the EXISTS keywordworks.(SELECT * FROM FooStringsWHERE FooStringsImport.FooKey = FooStrings.FooKey)This part is going to return only records from FooStrings correct? Ordoes it do a cartesian product since I've specified more than one tablein the WHERE statement?I wonder if it only returns records in FooStrings, then I don't see howa record from FooStringsImport would "EXISTS" in the records returnedfrom FooStrings.The reason I wondered about the cartesian product is because, if onlyFooStrings is specified in the FROM part of the SELECT statement, thenI was thinking it is only going to return FooString records. Theserecords would then be returned by the select statement to the WHEREEXISTS, which would look for FooStringImport records, but would findnone because the select statement only returned FooString records.I'm guessing maybe because it has to do a cartesian product to evaluatethe WHERE Pkey's equal, then the "SELECT *" just goes ahead and getsALL the fields, and not just those in FooStrings.FooStrings and FooStringsImport are identically structured tables,where the FooKey is set as the primary key in each table:CREATE TABLE [dbo].[FooStrings] ([FooKey] [bigint] NOT NULL ,[Name] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[StartDate] [datetime] NULL ,[EndDate] [datetime] NULL ,[Code] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY]GOThanks in advance. I'm so appreciative of the help I've gotten here,as I've been able to write several very useful queries on my own nowafter everyones help and plus lots of reading on my own.

View 4 Replies View Related

Noob Having Troble With Group By Etc.

Sep 6, 2006

Well i guess it is a bit more than just group by but here we go...

General description :( background info on the problem; may or may not be needed)

I am trying to get a list of active card holders for a particular month.  A card holder is considered active if their status was active any time during that month. I have a card holder status in my  CardHolder table but that will only give me their current status.    I also have a CardHolderHistory table that saves any changes to a card holder including their status.  Using the CardHolderHistory table i can find out who was active for any month in question by using the following algorithm:

A card holder is active if they meet one or both of the following conditions;

1) The last entry before the month in question has them as active in CardHolderHistory or

2) They were set to active any time during the month in question 

The problem:

I create a temporary table and copy the card holders into the table with separate select into statements for each of the above conditions.  For the first condition, I first gather all the CardHolderHistory entries before the month in question with the following select

select EmployerName, cardholderhistory.FirstName, cardholderhistory.Initial, cardholderhistory.LastName, ChangeDate, CardHolderHistory.CardState, FKEmployerID

into #MonthlyCards from cardholderhistory left join Employer on PKEmployerID = cardholderhistory.FKEmployerID

where changedate<@datespecified
This gives me ALL of the CardHolderHistory before the month in question (@dateSpecified).
It would look something like this
 
EmployerName             First      Initial     Last      Status   ChangeDate                  EmployerID
-------------------------------------------------------------------------------------------------------------------------------
.
.
.
Some Fake Company    John     P          Doe      A          2006-05-02 11:34:26.360            109
Some Fake Company    John     P          Doe      A          2006-03-28 11:14:10.520            109
Some Fake Company    Jane     T          Doe      S          2006-05-30 15:34:14.900            109
Some Fake Company    Jane     T          Doe      A          2006-03-28 12:20:03.670            109
Some Fake Company    Jane     T          Doe      A          2006-03-01 10:12:45.320            109
.
.                                 (S = suspended; A = Active)
.
 
Now I need to make sure people are only listed once and remove everyone whose status = suspended for their last change date.  That is my problem; I can€™t figure out how to remove these people.  The next step i took was to do a group by with EmployerName, FirstName, Initial, LastName, Status, Max(ChangeDate), FKEmployerID.  This removes everyone listed multiple times except if their status changes.  After the group by the list would be
EmployerName             First      Initial     Last      Status   ChangeDate                  EmployerID
-------------------------------------------------------------------------------------------------------------------------------
Some Fake Company    John     P          Doe      A          2006-05-02 11:34:26.360            109
Some Fake Company    Jane     T          Doe      S          2006-05-30 15:34:14.900            109
Some Fake Company    Jane     T          Doe      A          2006-03-28 12:20:03.670            109
 
Now I need to delete Jane completely, since her latest status is S.  I could delete where Status = €˜S€™ but that leaves her as active from 3/28.  I can€™t figure out how to completely remove Jane.  The rest I can figure out I think.  Please help me get rid of Jane for good, I don€™t like her.
 
Thanks for any help,
 
Rico

 

View 6 Replies View Related

Easy NOOB Question

Jul 22, 2006

Hi,

I'm trying to pass a parameter into a procedure and not getting the results I want.  There's probably better ways to write the procedure, and if you want to suggest one, that's ok, but I'm most interested in just getting the stupid thing to work.  I'm trying to search a bit field in a table with the bit field being the parameter that isn't working.  In the code I include below, @category is the parameter that isn't working.  For this case, "category" is a bit field in a table and I want to be able to pass in different fields and find out if they're set.  When I use the parameter @category, the result isn't right.  If I hard code the field name (for the case below, "Compensation" is the DB field name), it works.  I'm declareing the calling procedures parameter as a bit field too.  Code follows:

CALLING PROCEDURE:

DECLARE

@include int,

@Compensation bit,

@performanceBool bit

-- Find out if this category is included in the Plan Summary

-- CALLING PROCEDURE WITH PROBLEM PARAMETER IS BELOW

execute @include = dbo.PlanSummary @planId, @version, @Compensation

IF @include = 0

BEGIN

 

CALLED PROCEDURE:

ALTER PROCEDURE [dbo].[PlanSummary]

(@planId int, @version float, @category bit)

AS

-- Find out if this Category should be included in the Plan Summary

DECLARE planSummary CURSOR

 

If I hard code "@category" below as the DB field name "Compensation", it works, but using the parameter @category, it doesn't.

 

FOR SELECT DISTINCT COALESCE ((SELECT @category

FROM ProvisionsPlanSum

WHERE (PlanId = @planID) AND (Version = @version)),

(SELECT Compensation

FROM ProvisionsPlanSum AS pps

WHERE (PlanId = - 99))) AS fred

BEGIN

DECLARE @index as int

DECLARE @planSum as bit

DECLARE @id as int

SET NOCOUNT ON;

OPEN planSummary

FETCH NEXT FROM planSummary INTO @planSum

-- If the FETCH_STATUS is 0 a row was retrieved

IF @@FETCH_STATUS = 0

BEGIN

-- Find out if the Committee bool is set to true

IF @planSum = 'true'

BEGIN

RETURN (0)

END

ELSE

BEGIN

RETURN (1)

END

END

CLOSE planSummary

DEALLOCATE planSummary

END

GO

View 1 Replies View Related

How To Do This In SSIS? Soory If I M A Noob

Sep 12, 2006

Hi all,

Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination.

I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases):

After 1st run,

Source table has: 1 - 1000 records

Destination table has: 1 - 1000 records

For 2nd run,

Source table has: 1 - 1500 records

Destination table has: 1 - 1500 records

How I insert only the 1001th record - 1500th record, without touching the 1st to 1000th record?

Secondly, if there are any changes in values in the records 1st to 1000th record, how to I compare and only update the value that has changed? Is there any particular configuration setting in sql that I can use?

Many thanks for any help provided.



View 25 Replies View Related

Coding C# Stand Alone App With Db (noob)

Nov 3, 2007

Hi everyone!

I'm currently working on an application that needs to store address information.
I figured a database of some sort would be the perfect thing to use.

The thing is:
The application will work locally, there will be no server running on a network

There shouldn't be any login and password protection for the db
When I later on install the application on a computer, a fresh and clean db should be created within the applications folde

How can I create and access a db like that using c# and MS SQL Server?

Any hints, tips, example code, links...anything?


Many thanks in advance!!!


PS. I've been working some with visual c# express and recently installed SQL Server & Manager. I've previusly made some php web pages using MySQL but I´m a total noob when it comes to working with SQL and c# (= I'm stuck!).

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved