SQL Or Visual Web Developer 2005 To Arrange Phone Number Formatting?
i am trying to build a database that contains a coloumn of phone number but i reallly dont know where and how i will be able to give a specific format for phone numbers.. or anything else any common type of information that may have a format..
Will i use Visual Web Developer or SQL Server Management or whatever else to arrange my phone number coloumn?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Phone Number Formatting
If I have a string of 10 numbers (with no other characters), what is the best way to format them into a standard phone format: xxx-xxx-xxxx? I tried numerous variations in the format code and edit expression areas, but no luck.
View Replies !
View Related
Remove Formatting From Phone Number Column
I have a column of phone numbers that have formatting such as (xxx)xxx-xxxx, or xxx.xxx.xxxx or xxx.xxx-xxxx; however, not all phone numbers are formatted in this fashion. I need to remove all characters and only leave behind numeric digits to look like xxxxxxxxxx. I have tried select replace(colname,'-','') from table. This does the trick but does not actually change the values in the column. Any help in accomplishing this would be helpful. Thanks in advance. Paul
View Replies !
View Related
Visual Web Developer 2005 Express -- With SQL Server Developer 2005?
Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005? I was about to order SQL Server Developer Edition 2005 on Amazon, to use with Visual Web Developer 2005 Express, when I read a user comment that the two are incompatible with each other. Does anyone know for sure if that is true? What I'm wanting to do is develop an ASP.NET web application on a web host using a SQL Server database. I use VS2003 and SQL Server Enterprise 2000 at work, but I'd like to learn the 2005 editions for this side project. I don't own any of the developer tools/IDEs personally, so I'm trying to find the most affordable way to do this for my home business. Thanks for any advice, Keith
View Replies !
View Related
Can I Use SQL Server 2005 Developer With Visual Web Developer?
There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine. I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu. Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
View Replies !
View Related
Formatting For Phone?
In my report I am combing 2 fields as =Fields!PROPERTY.Value & " - " & Fields!PHONE.Value this results in PropertyName - 5555551212 How would I add in formatting for phone so my resulting display is (555) 555-1212?
View Replies !
View Related
Getting Up And Running With Visual SQL Server 2005 Express And Visual Web Developer 2005 Express
I've downloaded and installed both of these (VWD installs both) and have been trying to run through the walkthrough of setting up a web application which supports membership. However, no matter what I do I invariably get errors like the following: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) I'm concerned why VWD and VSQL express versions don't run correctly out of the box (so to speak). I'm not an expert on configuring these services -- but that's the point of offering these tools to hobbyists: So we can learn about how to make some of these great applications using MS tools. My configuration:: Windows XP SP2 -- clean machine as of about a month ago, never had any dev tools, web servers, or the like on it. IIS is installed and the service says its running VSQL and VWD express versions installed (no errors on installation) SQL server service indicates it is running .Net 2.0 framework installed (no errors on installation) Note: I've tried installing on two separate machines. Obviously I'm missing something fundamental. Would someone please help me go through the million things I [apparently] need to do to configure all these tools so I can get on to actually coding up my first web application? If this is documented somewhere, all I can say is I tried to find it but it certainly wasn't obvious.
View Replies !
View Related
Formatting Phone Numbers
What is the simplest way to format the 10 digit numeric string that represents a phone number, so that the result appearing on a web page looks like (xxx) xxx-xxxx. Should this take place in the database or out at the web server or where?
View Replies !
View Related
Formatting Phone Numbers In SQL
Here's my problem: I have to clean up a SQL Server 2005 database with a large number of phone number records (several hundred thousand). The records are of varchar datatype and contain phone numbers in every format imaginable. In fact, many records have written notes regarding the phone numbers after the numbers themselves. What I need to do is format all of the phone numbers to this format: ###-###-####- Basically I'm figuring I need to do the following: 1. Strip all non-numeric characters from the record 2. Remove the 1 from any records that have a leading 1 (in many cases the records contain stuff like 1-888-555-1234) 3. Remove any digits following the first 10 digits (they don't want to keep any extensions - the formatting is more important) 4. Add dashes after the first three digits, after the second three and at the end of the phone number This seems like a rather complex problem to me, and honestly I don't even know where to begin. I can accomplish this rather easily in javascript or C#, but writing SQL to solve this is beyond me. I'd really appreciate any help you guys can provide. Thanks alot!
View Replies !
View Related
Visual Web Developer && Server 2005
Yes I am a newby (or is that newbie) and this is my first post.My Visual Web Developer site work really well on my PC, I read the books took it slowly, created logins and sql tables and then found a good hosting company with Server 2005 ... I though I was one step away from the road to success ... then I hit the big brick wall. Spent hours on Google trying to find some answers without joy ... all I found were lots of users with the same or similar problems ... and some answers that caused more problems !1) Please can someone give my a 'step by step' idiots guide on how to convert my ASPNETDB.MDF content to run on Server 2005. I have Server Management Studio so I am happy about loading the translated files but I don't understand how to break them down into tables and logs.2) Once the files are across can I run a connection string from VWD directly to the tables on the server instead of SQL local ? I assume that is set in web.config !!.... normally I am happy to learn by trial and error. But I can't get around or over this brick wall.Welcome assistance, advice or a ladder ... with simple instructions ?
View Replies !
View Related
Problem With Visual Studio 2005 Pro + SQLserver 2005 Developer
Hello Im pretty new to development so..... be nice guys. I have VS2005 pro and SQL Server 2005 developer edition installed. When I open VS, in the server explorer i can connet to databases located on the SQL directory (SQL Server runs perfectly) But when i try to add an sql server to my project( add new item --> SQL database) it gives me an error saying "Connection to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component......" HELP! donno what VS wants!
View Replies !
View Related
Trouble In Installing Visual Web Developer 2005 SP
Hi, I'm new to SQL Server and am now learning how to operate SQL Server Express 2005. I'm getting the following error when attempting to install Visual Web Developer 2005 SP1. "The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch" My machine runs on XP Pro SP2, .NET Framework 3.5. Currently, what i have got on the computer are as follows Microsoft SQL Server 2005: SQL Server Management Studio Express, SQL Server Configuration Manager.
View Replies !
View Related
CASE Function Home Phone Work Phone Cell Phone
Hi, I'm trying to create a case function for home phone ,work phone and cell phone. The thing is some of the home phone numbers either null, zero or less than 10 digits then i'd like to get either cell phone or work phone if they are not null, zero or less than 10 digits. I'd appreciate it if you could help me on this? Thanks in advance.
View Replies !
View Related
Microsft SQL Server && Visual Web Developer 2005 Express
Hello Everyone, I have just installed then above softwares and I am trying to work on a very simple application.On my Default.aspx I created a Gridview and connected it to the dabase.Everything works fine?When I try to work on the Security under Website->ASP.NET_Configuration I get the error: 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. I see that a lot of people get this problem. Can someone sugest a way out?Thnaks in advancePati2005
View Replies !
View Related
Why Can't I Acces My SQL Server 2005 Db After Working With Visual Web Developer?
I am developing an asp.net app using visual web developer. I am using a sql server 2005 db for the back end. I have learned that I have to restart my machine if I want to work with the db in SQL Server 2005 Express after working with it in Visual Web Developer. I am wondering why this is. I am assuming that the db is locked when it is used with VWD. Is this correct? Am I refering to it's status of "locked" correctly? Should I call this something else? -thanks to anyone that can help
View Replies !
View Related
SQL Reporting Services 2005: Formatting A Number
I know this is very simple, and I've done it before, but now I can't remember how to do it and I keep failing to do it correctly. I want to format a 6 digit number like this: 00-00-00. The number is returned from the database as 6 digits, and I just want to add the dashes. I tried putting ##-##-## in the Format cell in the properties of the textbox (which I thought worked before) but it's not doing the trick. What am I doing wrong here?
View Replies !
View Related
Problem In Deploying The Website Developed In Visual Web Developer 2005
Hi, I am new to asp.net.I am trying to deploy the website on IIS created in visual web developer 2005 express.I am having problem with the aspnetdb.mdf for login.I have copied my entire contents to the physical directory( shared floder),from where the iis virtual directory can access the contents.I can see my login form but when i enter my username and password and click login it gives my error"error occured in establishing the connection". I am using the sql server 2005.I don't know what should i do with aspnetdb.mdf? thanks and urgent help needed
View Replies !
View Related
Problem Reading A Text File With Visual Web Developer 2005 Express
Hi, my name is Bonfa, i'm working with visual web developer 2005 express and visual basic and sql server, i'm trying to import one file using the bulk function in sql server, in the visual web developer i just call the method to execute the stored procedure, but i'm facing a problem that says: "Bulk load: An unexpected end of file was encountered in the data file/The OLE DB provider "BULK" for linked server "(null)" reported an error./The provider did not give any information about the error. " and i couldn't do this yet. I don't know what's happening, because i'm passing the file to the stored procedure in the exact way it should be passed, and how could the sql server find some end of file characters inside the file? I need help. Any help are welcome.Here are some parts of my code: Dim strsql1 As String = "sp_insert" Dim myCommand As New SqlClient.SqlCommand(strsql1, objConn) Try myCommand.CommandType = Data.CommandType.StoredProcedure myCommand.Parameters.AddWithValue("path", "C:TestOrders.txt") myCommand.Connection.Open() myCommand.ExecuteNonQuery() myCommand.Connection.Close() myCommand.Dispose() Catch ex As Exception End Try set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[sp_insert]@Path varchar(max)AS--Step 1: Build Valid BULK INSERT StatementDECLARE @SQL varchar(2000) BEGIN -- Valid format: "John","Smith","john@smith.com" SET @SQL = "BULK INSERT temporary FROM '"+@Path+"' WITH (FIELDTERMINATOR = '"",""', rowterminator = '')" END--Step 2: Execute BULK INSERT statementEXEC (@SQL)--Step 3: INSERT data into final tableINSERT order (header,order_number)SELECT SUBSTRING(header,2,DATALENGTH(header)-1), order_numberFROM temporary --Step 4: Empty temporary tableTRUNCATE TABLE temporary
View Replies !
View Related
Error Connecting To The Sqlserver Express Edition From Visual Web Developer 2005
hello eveyone..i have just downloaded and installed the visaul web developer 2005 express edition and sqlserver 2005 express edition.On top of that i even downloaded and installed the northwind database.But my problem is when i am connecting to the northwind database by clicking toos menu>connect to the database>choose datasource>new connection>..i have provided it with the required information..but as soon as i press "Test Connection" button the following error box displays.. "an error has occured while establishing a connection to the server.when connecting to the sql server2005,this failure may be caused by the fact that under default settings sql server doestnot allow remote connections.(provider:Named piped providers,error:40-couldnot open a connection to sqlserver.)" i have no idea whats is all about..can anyone get me pass this error..
View Replies !
View Related
Asp.net Visual Web Developer 2005 Connection To Sage Dosen't Work On Server
Hi all i have a page with this code <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="36"> <PagerSettings Mode="NumericFirstLast" Position="TopAndBottom" /> <Columns> <asp:BoundField DataField="ACCOUNT_REF" HeaderText="ACCOUNT_REF" SortExpression="ACCOUNT_REF" /> <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" /> <asp:BoundField DataField="ADDRESS_1" HeaderText="ADDRESS_1" SortExpression="ADDRESS_1" /> <asp:BoundField DataField="ADDRESS_2" HeaderText="ADDRESS_2" SortExpression="ADDRESS_2" /> <asp:BoundField DataField="ADDRESS_3" HeaderText="ADDRESS_3" SortExpression="ADDRESS_3" /> <asp:BoundField DataField="ADDRESS_4" HeaderText="ADDRESS_4" SortExpression="ADDRESS_4" /> <asp:BoundField DataField="ADDRESS_5" HeaderText="ADDRESS_5" SortExpression="ADDRESS_5" /> </Columns> <PagerStyle HorizontalAlign="Center" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SageConnectionString %>" ProviderName="<%$ ConnectionStrings:SageConnectionString.ProviderName %>" SelectCommand="SELECT ACCOUNT_REF, NAME, ADDRESS_1, ADDRESS_2, ADDRESS_3, ADDRESS_4, ADDRESS_5 FROM SALES_LEDGER"> </asp:SqlDataSource> On my local machien this works great and I'm very happy with it I then uploaded the site onto the server on running the page i get this ERROR [08001] Cannot find all files in data pathERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 2.00ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). can anyone suggest a eresolution? i'm confused since it works on my local machine fine but not on the server
View Replies !
View Related
Problem Installing SQL 2005 Developer + Express And Visual Studio 2008
I installed both SQL 2005 developer and SQL Server 2005 Express Edition with Advanced Services SP2 and Microsoft SQL Server 2005 Express Edition Toolkit. In every version "SQL Server Business Intelligence Development Studio" was missing. I uninstalled and reinstalled both version but always "SQL Server Business Intelligence Development Studio" was not available and the computer could not find devenv.exe file. I installed visual studio 2008 as well. For some reason the start menu link for "SQL Server Business Intelligence Development Studio" is ""C:Program FilesMicrosoft Visual Studio 8Common7IDEdevenv.exe"" and devenv.exe is not there or anywhere Pleas advise.
View Replies !
View Related
Trouble Installing Reporting Add-In For Microsoft Visual Web Developer 2005 Express
Hi Folks I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message: "There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor" Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing. Any ideas, please? Thanks Andrew
View Replies !
View Related
UNABLE TO ESTABLISH USER INSTANCE - Visual Web Developer 2005 Edition
Hi: I have SQL Serrver 2005 Express Edition with Advanced Services running on a machine with Vista Home Premium o/s. I am trying to build the Personal Web Site Starter Kit using Visual Web Developer 2005 Express Edition but keep running into problems when trying to establish user instance. The error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The conmnection will be closed" keeps coming up. The following services are running: SQL Server (SQLEXPRESS) SQL Server Browser SQL Server Full Text Search SQL Server VSS Writer I note from the documentation that a new instance should be created in the directory : C:Documents and Settings<User>Local SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS. Unfortunately that directory does not exist on my Vista machine. Is this a fault? Should I create this directory? Any help will be gratefully received. Simon Woollard
View Replies !
View Related
Phone Number
Hi, I have 2 tables with different phone field format. Looks like below: TableA---------------------field name---------------------record Area 111 Phone 2223333 ================================================== ========================= TableB---------------------field name---------------------record phone (111) 222-3333* *with a space between (111) and 222 I want to transfer tableA (area+phone) field to tableB phone field and transfer tableB phone field to tableA area field and phone field Anybody can help me to finish it? Thank you very much!!!
View Replies !
View Related
Phone Number
I have 2 tables with different phone field format. Looks like below: TableA field name area record 111 and field name phone record 2223333 TableB field name Phone record (111) 222-3333 * *with a space between (111) and 222 I want to transfer tableA (area+phone) field to tableB phone field and transfer tableB phone field to tableA area field and phone field. Anybody can help me to finish it? Thank you very much!!!
View Replies !
View Related
Trimming Phone Number
Hi all, i have a table in SQL with +- 5000 phone numbers in various styles e.g. 0515 - 578989 033 2981861 +31 (0)30 602 44 44 03.28.68.63.18 03/658.85.80 I want this to convert to international format like this 003237778899 0031306024444 Do i have to write 10 replace after each other or is there an easier way to format the phone numbers? Thx in advance!!
View Replies !
View Related
Format Phone Number
Hi Everyone, I have a phone number coming from the database coming in the format of 2132563111. How can I do this in sql query213-563-3111 Please let me know if there is any function that does it. Thanks.
View Replies !
View Related
Phone Number Trigger?
How would I go about setting up a "mask" to automatically place the hyphen in phone numbers in SQL Server? I.e., the user types in an area code and then a hyphen automatically inserts and the cursor is on the next blank space. Thanks for the assist. Mark Somewhere down here in Texas
View Replies !
View Related
Phone Number Update
I am trying to update a bunch of phone numbers in a SQL 7.0 db. The phone numbers are in the following formate. (aaa)-xxx-cccc I need to update xxx to yyy. Has anyone done this before. Please help. Thanks in advance
View Replies !
View Related
Format Phone Number
How to format phone numbers in sql? in current fields some phone number entered like this: 1 800 7894564 8001237878 1237878 1800blue etc... I am trying to get into uniform like this: 8007834444 Thanks
View Replies !
View Related
Keep Phone Number Format
Hi, I have phone number column in Excel file. The phone number is in this format: 523-349-0212. When this data imported in to SQLServer file, it is not keeping the format, storing it as 5233490212. The data type of this column is varchar. How to keep this format? Thanks in advance
View Replies !
View Related
Phone Number Formating
Hello and thanks for taking time to read this post! Thanks in advance to any and all who reply I am creating a report that is pulling phone numbers from a DB. Unfortunately the person who designed the DB and the app that is related, not me , did not restrict formating on the phone number field. So I have a midry of values in the DB. Most common is xxxxxxxxxx, some are xxx-xxx-xxxx, and yet others are NULL in value. I looked over KB157328 and found this: Code Snippet=System.Text.RegularExpressions.Regex.Replace(Fields!Phone.Value, "(d{3})[ -.]*(d{3})[ -.]*(d{4})", "($1) $2-$3") If I drop that in to the TextBox I get nicely formatted phone numbers if the values in the DB are xxxxxxxxxx or xxx-xxx-xxxx. But, if the value is NULL I get, #ERROR. So I pondered this a bit and came up with: Code Snippet=iif(Fields!Phone.Value is Nothing," ",(System.Text.RegularExpressions.Regex.Replace(Fields!Phone.Value, "(d{3})[ -.]*(d{3})[ -.]*(d{4})", "($1) $2-$3"))) Again nice form formatting for values in the DB that are xxxxxxxxxx or xxx-xxx-xxxx. But again if the value is NULL I get, #ERROR. So I tried: Code Snippet=iif(IsNothing(System.Text.RegularExpressions.Regex.Replace(Fields!Fax.Value, "(d{3})[ -.]*(d{3})[ -.]*(d{4})", "($1) $2-$3")), " ",(System.Text.RegularExpressions.Regex.Replace(Fields!Fax.Value, "(d{3})[ -.]*(d{3})[ -.]*(d{4})", "($1) $2-$3"))) And the same results Does anyone know what I'm doing wrong in my expression or have a better way to deal with this?Again, Thanks in advance for any and all help!Fred Stemp
View Replies !
View Related
Build Random Phone Number.
I'm building a test database and I need to randomly create phone numbers in the format xxxxxxxxxx I have 5000 contacts and need to generate fake phone numbers for them. anyone know how I can write an update query to do this? ScAndal
View Replies !
View Related
Phone Number Lookup Query!!
i am trying to write a query for phone number lookup . The query should be able to search numbers which have anything matching .... like if the person enters 1918767899 or enters 918767899 the query should be able to find both the records. Itried using the LIKE , but it doesn't work the way it is required. Pls help !! Regards
View Replies !
View Related
I Need Help With Cleaning A Phone Number Column, Brain Freeze
For anyone who can help me resolve this minor data issue. I am trying to clean a phone number column so that all numbers are reflected in the same way. I have phone numbers in my column in this this format: (123)123-1234 123-123-1234 (123) 123-1234 How can I clean this column so that the numbers are reflected in this way: 1231231234 I'm having brain freez right now. Help me please!!! Thanks in Advance
View Replies !
View Related
Using SQL Server 2005 Express In Visual Web Developer Express
I have installed Visual Web Developer Express and its companion SQL Server 2005 Express in my Windows XP Professional box. Now I want to create a database using Visual Web Developer. I opened the Database Explorer and right clicked on Data Connections icon but what I am seeing is an inactive "Create new database" command. How can I make it active ? How to create a database using my Visual Web Developer?
View Replies !
View Related
Using Sql Server With Visual Web Developer
Hey, Im trying to make a website that I can enter information on the website and have it transfered to the database the problem is the website and database are on two different computers , how do I copy the data base onto the other computer and have it will be ready to take information from the website and store it in the database?
View Replies !
View Related
Using SQL Express With Visual Web Developer
Hi, Can I use Sql Express Edition with Visual Web Developer at the same time? I tried but I always get a permission error. Also, when I try to attach a database (that I created in Visual Web Developer) to the SQL Express i cant find the .mdf file, I don't know why? Is there is a way where I can specify a folder where I can keep the mdf and allow both applications to access it?
View Replies !
View Related
Visual Web Developer And Sql Error 40
lo all, when i try and connect web developer to a sql file i get "An error occurred while establishing a connection to the server.When connecting to sql server 2005,this failure may be caused by the fact that under the default settings SQL server does not allow remote connections(provider:Named Pipes Provider,error : 40-Could not open a connection to SQL server)" thx for any help Charlie
View Replies !
View Related
Which Better For Visual Basic Developer
hi i found these books for learnning sql server which better to read for Visual Basic Developer ?? http://www.sqlserver2005books.com/1-3805-0735622507-%20Microsoft_SQL_ServerTM_2005_Reporting_Services_Step_by_Step_Step_by_Step_Microsoft.html ------------------------ http://www.sqlserver2005books.com/1-3805-0735622078-%20Microsoft_SQL_ServerTM_2005_Database_Essentials_Step_by_Step_Step_By_Step_Microsoft.html thank you
View Replies !
View Related
Basic Sql Querying In Visual Web Developer
I'd like to be able to query a database to get the value of a certain row. However, I'd like to save this value into a variable and use them as I'd like, NOT nessessarily display them in a data control such as a gridview etc. I've been able to find a lot of information on binding datasourses to predefined data controls, but I can't find anything on simply querying a database for values and using those values to display a page as I want.My basic end goal is to create what's basically a shopping site like Amazon only for about 100 or so products.Thanks in advance for any help. I'm just getting into Visual Web Developer so please excuse my ignorance and lack of posts.
View Replies !
View Related
Adding A New Table Of Visual Web Developer
hi i added a new table to my existing database in visual web developernow when i am running this i get an error Invalid object name 'TestTable'.with this sql command string sqlCmd = "INSERT INTO [TestTable] ([Employee], [Client] ,[Project] ,"+ "[TimeSpent],[TimeSpentOnline] ,[Description],[Incident], [Billable],[AfterHours],[Pending],"+ "[OnSite] ,[WorkOrder]) VALUES( '" + employee + "' ,'" + client + "','" + project + "','" + timeSpent + "','" + timeSpentOnline + "','" + desc + "'," + iactive + "," + bactive + "," + ahactive + "," + pactive + "," + osactive + "," + woactive + ")"; but it was working fine i was using this table which is exactly the same thing just a different name ..by the way i didnt create the tracking table string sqlCmd = "INSERT INTO [Tracking] ([Employee], [Client] ,[Project] ,"+ "[TimeSpent],[TimeSpentOnline] ,[Description],[Incident], [Billable],[AfterHours],[Pending],"+ "[OnSite] ,[WorkOrder]) VALUES( '" + employee + "' ,'" + client + "','" + project + "','" + timeSpent + "','" + timeSpentOnline + "','" + desc + "'," + iactive + "," + bactive + "," + ahactive + "," + pactive + "," + osactive + "," + woactive + ")"; i have already double checked the data types and also have made sure that everything was saved properly..... Can any one plz help me out on this
View Replies !
View Related
|
TRACKER
