Forum Array

Android :: Insert ArrayList In To Droid SQLite Database?

I have array list of geopoints List<GeoPoint> geoPointsArray = new ArrayList<GeoPoint>(); I want to put geoPointsArray array in to SQLite database and then fetch the data back as an array. Now I use ContentValues for insert into array as: ContentValues initialValues = new ContentValues(); initialValues.put(KEY_TIME, time); db.insert(tableName, null, initialValues);

View Answers

Very Similar Questions

HTC Droid Eris :: Android Sync With Mac (10.4.11) Via Address Book
Just got the HTC Eris and transfered my contacts from my old BlackBerry to the new Eris. Everything's there, actually way more than I need (over 3970 contacts, many duplicates and such. I realize that there is the 'delete duplicates' function on Gmail's contacts page, but sync'ing of that many contacts to go back and edit the contacts that I would like to keep on the phone, has really slowed down the phone, eaten battery big-time and in 3-4 days only 501 contacts have come across. I really don't need that many and was only planning on having the people I call on a daily basis. So, I turned off the sync function on the phone and the phone is running a bit better, but having to scroll or search through that many contacts takes for ever to do. I would like to find a sync conduit (that works with my PowerBook Mac running Tiger 10.4.11) that I could sync via USB my contacts off of this phone, edit the ones to keep, re-populate (replace) the contacts. At this point I would just turn on the phone sync function(with the fewer contacts) and let them populate Gmail. How is this possible? Many of the suggested downloads I have seen online haven't really stated that they work with my Mac OS. Is there a faster way to have the contacts sync'd up to gmail and maybe just edit everything up there on line?

Android :: Statically Link Sqlite To Droid Application?
I need to statically link the 3.6.2 version of SQLite against my android application due to a bug that affects the dynamic library bundled with Android < 2.2. I've already compiled and installed 3.6.2 on my development machine, but I'm not sure how I go about linking it to my Android app (developing with Eclipse). I'm not familiar with building and compiling options, so if someone could walk me through step-by-step.

Motorola Droid :: Sync Google Apps Directory To Android Contacts
I have been searching Google and this forum but have not been able to find a solution. I have a Motorola Droid (running 2.2). My company uses Google Apps for their e-mail, calendar and phone directory. I have my personal Gmail account setup as the primary account on the phone and my corporate Google Apps account as additional account. I can see my mail, calendar and contacts just fine for both accounts. In Google Apps there is a corporate directory that I can search from while using it on my desktop. Is there a way to see the Google Apps Directory contacts on my Android phone contacts or elsewhere on the phone? If someone is not already in my own contacts, I would like to be able to lookup their phone number in the contacts on my phone from the Google Apps Directory. Is this possible? My boss has a Motorola Droid X with 2.1. Can this be done in 2.1 also?

Android :: Remove Phone Tab From Droid Contacts App?
I want to remove the phone tab from android contacts application. How can i do this? Also how can i rotate the focus on contacts different tabs means when focus reaches on the last last tab of contact when pressing keyboard it should focus on first tab.

Android :: Droid WebView Crashes When Clicking On A Link / Fix It
I have some WebView widgets inside my Activity. I use loadData() to set the content, and this html contains a link. Some of my WebViews work okay, when I click the link, the web browser is started in a new window, but some make my app crash when I click on a link. 10-13 08:45:24.257: ERROR/AndroidRuntime(751): Uncaught handler: thread main exiting due to uncaught exception 10-13 08:45:24.308: ERROR/AndroidRuntime(751): android.util.AndroidRuntimeException: Calling startActivity() from outside of an Activity context requires the FLAG_ACTIVITY_NEW_TASK flag. Is this really what you want? 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at android.content.ContextWrapper.startActivity( 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at android.webkit.CallbackProxy.uiOverrideUrlLoading( 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at android.webkit.CallbackProxy.handleMessage( 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at android.os.Handler.dispatchMessage( 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at android.os.Looper.loop( 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at java.lang.reflect.Method.invokeNative(Native Method) 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at java.lang.reflect.Method.invoke( 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at$ 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at 10-13 08:45:24.308: ERROR/AndroidRuntime(751): at dalvik.system.NativeStart.main(Native Method) There seems to be a problem with the Intent that the WebView fires when I click the URL, but I have no control of this Intent, I think. Does anybody have any idea? I use this AsyncTask to set the content in the WebView, and it works fine.code...

Android :: Palm Contacts & Calendars In Gmail Already Before Syncing Droid
I am a long time Palm user. I have a Centro and recently, just testing, moved all my contacts to Gmail and "some" of like 10 years of Calendar data (but not nearly all of it) - an no Memeo's or Tasks. Well, my Droid should be here in a few days and I wonder.. should I kill off and delete my test Calendar data and my contacts from my Gmail account? I plan to use that CompanionLink to do a 1 time sync of my Palm data and want to mitigate any issues and just have a nice clean port over. Best to remove what I have done OR leave what I have done since CompanionLink and Google will sort it out (redundant entries).

Insert Fields From Different Pages To Database?
i have three pages named first.aspx, second.aspx, third.aspx. i fillup some fields in first.aspx, then click next,i fillup some fields in second.aspx then click next, i fillup some fields in third.aspx and here i click submit i want to save those all fields in to the database at once.

Image Insert Into Database - Oledb To Connect With Oracle
i am using oledb to connect with oracle from i am inserting image into my database.i could insert large and samll image into database. but i couldn't update large image with small image. ie if i insert small image(50kb)and if i want to update small image with large image(200kb) it is not updates with null value. i don't know why.

ADO.NET :: Linq To Sql Many To Many Insert Into Database In One Transaction
i have a Tag Table TagId TagName Post Table  PostId PostName TagPost Table TagId PostId How can i do a many to many insert into database in one transaction?

Insert Checkbox Values In To Database?
I'm trying to insert checkbox values in to a table, this is my code:-  [Code].... I get :- The variable name '@emp_id' has already been declared. Variable names must be unique within a query batch or stored procedure.

Databases :: Inserting Malayalam Data To Blob Data Field?
I am using 3.5 framework and mysql as my database. When i am saving malayalam data in to the database having datataype blob, it saves like '????'. But when i insert the specified value directly using the mysql query browser, then i can able insert the correct malayalam value.

Android :: Remove Android Default Link Styling In Webview
When you click a link in the Android browser, the target link area gets highlighted with an orange box by default. A longpress then opens up the context menu for link handling (copy, paste, new window, etc). Is there a way to disable either / both of these in webview? I'm using the highlight code in scriptaculous and the default android link styling is being laid over top of the effect.

Motorola Droid X :: Facebook Live Feed - REAL Facebook Page On Droid X
I'm sure this isn't news to any of you veterans, but this is my first android device so please bare with me. I'm using the facebook app and have noticed that neither the app itself or the widget show the actual facebook live feed or provide a way to access it.... Of course my next thought was "well what if I just use the facebook page in a browser window". Turns out that's not as simple as I thought! Apparently facebook not only has a mobile page, it also has a "touch" page that it likes to route you to. Neither the mobile or the touch facebook pages have a way to access the live feed either....

Motorola Droid :: Facebook Contacts Not Syncing With Droid List
Im have trouble merging my facebook contacts and my phone contacts. I have changed the names so that they correspond with each other but for some reason they still appear on my list as two separate contacts. How do i merge them?

Motorola Droid :: Apply Facebook Photos To Droid Contacts?
Has anyone found a way to take someone's facebook photo and add it to the Droid contact list? When I open my contacts, most of them have photos, which have been pulled from FaceBook, but 3rd party apps, such as Handcent SMS, only pull the images I have set for my contacts.Has anyone found a workaround to this issue?

Motorola Droid :: Moto Droid - Gmail - Contacts
Hey Android experts - First off, First Time poster, and long time lurker. I am thinking about getting the moto droid, and I heard that you can sign into your gmail account and sync all your contacts, but I have a question. What if I don't want my Gmail contacts to be syncd with the device, but I want to be able to check my gmail accounts, is that possible? The reason that I am asking is because I have numerous, like 10s of thousand contacts, and I don't want them all on the phone.

Databases :: Recording Individual Field Values From MySQL Database
I am using a simple Login function and need to record individual field values from MySQL database to compare with inputs. My connection code: Dim myConnection  As MySqlConnection Dim myDataAdapter As MySqlDataAdapter Dim strSQL As String myConnection = New MySqlConnection("Database=mydatabase;Data;port=3362;UId=myID;Password=1234;") strSQL = "SELECT username,password FROM Login WHERE ID = '" & 1 & "'" myDataAdapter = New MySqlDataAdapter(strSQL, myConnection) myDataSet = New Dataset() myDataAdapter.Fill(myDataSet,"Login") I have confirmed it is connecting by adding the following GridView. GridView1.DataSource = myDataSet GridView1.DataBind() My problem is isolating the individual field values.

Web Forms :: Transferring Data Between Access Database And Sql Database
I want to transfer data from a access table to a sql table. Simple by clicking a button. first off all i set up and OleDbConnection and a SqlConnection in my web.config file. This is the code i use in a b button method for transfer data for 1 tab le. [code]....

Databases :: How To Check Space On Oracle Database Server
I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend. I need to know two things: (1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts. (2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?

Web Forms :: Insert Html Tage To Sqlserver Database Through Textbox( 2.0)?
Insert html tage to sqlserver database through textbox Display it lable control

C# - How To Insert Image In Html Action Link
I have navigation and many link on my webproject from html action links. They are ugly with underline. I would like to insert some image with name or play with styles of action link.Is it possible? How to do that?

Insert Text With Command Button Into Textbox
How do I make a command Button Insert text into a textbox where the cursor currently is in that textbox?Thanks

Inserting Text In A Textbox After Hitting A Command Button
I am trying to find a way of inserting text into a textbox (wherever in the textbox the user has left the cursor) after the user has clicked a command button. The command button is intended to allow the user to insert a special character ie delta, degree symbol etc by pressing a command button which then puts the character into the textbox where the user had been typing.Please help!

Insert A LINK Into My Program
Hello to everybody,I want to insert a link into a my program. I need to insert something like a label that, when the user moves the cursor on it, the pointer changes, the color of the text changes, and if he clicks on it the default browser opens a web page. How can i open the default browser on a particular page???Thanks for any suggestions!

Insert Website Address On Form
How does one go about inserting a website address onto a form--that is what process is used to insert the address as an active link?Milt Gordon email@removed  

Android : Identify A Contact Item In Droid Address Book?
How to identify a contact item in Android address book ? I am developing an application to add, delete and update contacts on Android PDAs, I can't think up a good way to identify a contact item in the Contact(address book) taking the following issues into consideration: 1. different people can have the same name. 2. Though a record can be identified by its _ID (eg: Phones._ID), serveral rows may belong to one specific person. I am going to teat all the information(name, display name, phone number .....) of one person as a whole. Do you have a good way to identify them ? Or, How could I find the connection among the properties of the same person?

Android :: Link Where To Study And Develop Application Using Droid?
I am new to android/mobile application .I have exp in developing applications using Java/J2EE but no knowledge of mobile application/ games etc. Please suggest me any link/help from where I can study and develop application using android.

HTC Droid Eris :: Android 2.1 / Syncing Contacts From Multiple Gmail Accounts?
On my Droid Eris (just updated to Android 2.1), I have taken advantage of 2.1 offering support for multiple Gmail accounts. So I have 3 Gmail Accounts in the Gmail app. My question pertains to how Android syncs the contact lists (which include many of the same contacts) from these 3 separate accounts. Will I end up with dozens of duplicate contacts? If so, is there a workaround? Also, is there an easier way to switch between different Gmail accounts? E.g., in the Gmail app, you have to go to Menu then Accounts, which is inefficient. The built-in mail app displays a list of accounts when you open it (an ideal approach), but I would prefer to not open my Gmail accounts in the default mail app.

Android :: Prevent Gmail Contacts , Email And Calendar From Syncing With Droid?
How do I prevent my gmail contacts, email, and calendar from syncing with my android? I want to use the same email to login, but don't want the above to be synced

Html - Dynamically Created Elements From Codebehind Need To Be Inserted Between Specific Elements
I created a method and pass the element type, id, and any inner text that instantiates a new html element. The last statement: Me.Controls.Add(element) adds it to the end of the page, but I would like it to be inserted in a specific position (between 2 divs within a form). What I am describing is very similar to this post on SO here, although it was for javascript.

Web Forms :: How To Insert Link In Different Cities Of Country Dynamically
How can i insert link in different cities of country dynamically?

Can Insert Muiple Rows Into Table Using Entity Framework
i'm trying to use Entity Framework to insert into SQL SERVER 2005, using Visual studio 2008.the following codes are a Button onclick event,I want to insert into DB multiple rows at a time [Code].... however this does not work, it seems we can only insert into DB only one row at a time

Forms Data Controls :: Pass Parameter When Inserting?
I have a listview that has a hiddenField in the ItemTemplate. I want to pass this hidden control as control parameter when inserting a new record.but i get the errorCould not find control 'hiddenFieldID' in ControlParameter 'ID'.I also tried to access it in the ItemCommand event of the list view but it returns null. <ItemTemplate> <asp:HiddenField ID="hiddenFieldID" runat="server" Value='<%# Eval("reviewID") %>' /> </ItemTemplate> [code]...

Forms Data Controls :: Insert Dropdownlist Item To Db?
I got this to populate the dropdownlist, but I'm not sure how to setup the codebehind to insert the selected value when I select it and hit "insert" in the detailsview. Details View <asp:DetailsView ID="DetailsView1" runat="server" Width="400px" DefaultMode="Insert" AutoGenerateRows="False" oniteminserted="DetailsView1_ItemInserted"> <Fields> [Code]....

Forms Data Controls :: Insert In FormView On Webpage
I am using the query builder to frame an Insert query that I am using for a FormsView control on a web page. The problem is there are more than 50 fields that need to be inserted and I am wondering if there is any better way to do this... than manually typing in IdNames of controls on the web page in the VALUES (,,,,,,,,,,.......) section of the SQL statement.

Forms Data Controls :: Default Value In Formview Insert Mode
Formview1 datasource ID is SQLTest. When I click New on the form and go into insertmode, is there an easy way to auto file  textboxID to the value of the NextIDNumber  field ( field 9)  from SQLTest datasource?

Forms Data Controls :: Formview Default Insert - Need ReadOnly View
I'm using a formview in Insert mode with an AccessDataSource. I want to switch to readonly mode upon insertion to let the user confirm the input worked, then give them the option to insert a new record. If I set the DefaultMode to Insert, then after the first record is inserted, I get a new blank insertion form (no confirmation). If I set the DefaultMode to ReadOnly, after insertion, I get a blank form (presumably because I am not on the record just inserted).  How do I get the just inserted record to display? If I need to set the ID of the formview to the just inserted record OnInserted, how do I get that given I'm using an AccessDataSource?

Forms Data Controls :: FormView Insert Mode Retaining Values?
i'm very new to this. I have a gridview, formview and an "Add" button on the page, this button is to hide the grid and show the formview. This formview has a default mode of Insert - and have databound this form view to my ods. (sharing with grid) This form view declared invisible on the button click - I hide the gridview and show the formview, the user fills in the form and presses insert button in the fv, the record is inserted and in my ods_inserted event i hide the formview and reshow the gridview. And the new record is in my grid. However if i press the add button again, my formview is still populated with my previous inserts values. I would have thought the values would have been cleared.. How do i clear the values?

Forms Data Controls :: Insert Data Using EntityDataSource In FormView - C#
I am new to formview .My formview works fine, when I insert data into the database directly and then do an update on it. It throws an error when I try to insert a new record.  The error just says "An error occurred while updating the entries. See the inner exception for details." How to insert data into the table using an entity dastasource?

Forms Data Controls :: Use Manual Insert & Update With FormView (master/detail)
I have a master/detail page using gridView and  formView attached to a pair of entityDataSources.  The automagic insert and updates quit working after making heavy customizations to the form (replacing ID numbers with persons' name, etc).  The automatic CRUD throws errors on insert and silently fails on edits, but delete works fine (woot!!!). After two fruitless months of trying to get the automatic insert and update to work, I wrote my own code to replace them.  This has caused a new problem: The records are inserting correctly (haven't made it to the updates yet) but the automatic is still firing and throwing an error.  I've tried turning the automatic inserts and updates off - the insert still fires, but an exception is thrown that the form doesn't support inserting records. I can post code but I don't know whats relevant. The two files are in the neighborhood of 220 lines each. Basic structure is gridView formview tied to gridview formview fires OnDataBound (code replaces numbers with human readable stuff) formview fires OnItemInserting (fires custom code to assemble new record and save to the database outside the entityDataSource) formview fires OnItemUpdating (when completed, will update records similar to OnItemInserting) entityDatasource for gridview autogenerate where clause turned on Enable Insert, Delete & Update turned on entityDatSource for formview

How To Insert And Retreive An Uploaded Document Using Fileupload Into Sqlserver
How to insert & retreive an uploaded document using fileupload into sqlserver. I am practicing on a job portal website. Jobseeker uses fileupload to upload his/her resume and when uses preview resume. the resume should be displayed here only when uses preview resume command..

Can't Insert Image Into Project
I downloaded a source code of a project and inside the project there is an images folder. I wanted to add another image file to that folder and so what I did is just put the image that I want to add into the actual directory of the image file then I drag and drop the image to visual studio 2008 image folder. However when I try to refer to the image, it seems like visual studio 2008 can't find the image. When I try to view the page in the browser, it gives me the classic x mark.

Insert Image In Crystal Report
i need to set logo of company according to the title of along with company title want to send image path and set the image accordingly. My motot is to set image dynamically..but not from database. Read the ideas.nd coverted image in byte[]..but i am not able to send it along with parameter...and wat parameter shall i take on report for displaying it?

Web Forms :: Uploading Image Using Insert?
I'm trying to craete an upload form using the following code: [Code].... when I click the 'Add imag' button I keep getting this error:String or binary data would be truncated. The statement has been terminated.the 'Image' column in the SQL database is set to VARBINARY(250) and this exception still pops up even when I'm trying to upload a small 3kb JPG image, why is that?

Web Forms :: How To Insert 2 Markers (with Image) In Different Series
i´m using Microsoft ASP.NET CHART CONTROL: [URL] how can I insert 2 markers (with image) in different series and in points with equal values. next to each other.

Pass Selected Radiobutton To Insert Parameter SQL Server?
I can do that writing to insert into code. But my manager wants me to use sqldatasource control and it's insert delete update function to work with. My old code was this Code: [code]... after than i pass fieldevent but i don't know how to do it on sqldatasource control.

How To Insert Empty Row In Datagrid When Click The Button
i have Datagrid control  with 4 columns and a button outside Datagrid ,i am displaying some records in datagridwhen i click the button outside Datagrid  i  want to create a empty row in Datagrid

Web Forms :: Onclick Rename Page And Insert Text?
is it possible to add an onclick event to button so when its clicked a page would be renamed from "a" to whatever is in a textbox . and also is it possible to make the onclick event insert some text into a textbox in this renamed page from a text that is already in an existant page.

Insert Value In Appsettings In Web.config File?
I am  inserting new values in  appsettings of  web.config file  using   user interface my web.config file <appSettings> <add key="ConnectionString" value="user id=sa;password=123;Initial Catalog=MYDB;data source=MYSERVERNAME" Connect Timeout=5" /> </appSettings> I am using this method in page.aspx i have 4 textboxes int page.aspx for input userid ,password, servername  , databasename from page.aspx Dim xDoc As New XmlDocument xDoc.Load(path) Dim nodeList As XmlNodeList = xDoc.GetElementsByTagName("appSettings") Dim nodeAppSettings As XmlNodeList = nodeList(0).ChildNodes Dim xmlAttConnectionString As XmlAttributeCollection = nodeAppSettings(0).Attributes xmlAttConnectionString(0).InnerXml = "ConnectionString" '' for key attribute xmlAttConnectionString(1).InnerXml = '' for value attribute  her i am getting problem  how i insert value to ConnectionString Key

DataSource Controls :: Cannot Insert Explicit Value For Identity Column When Identity_Insert Is Set To...
The wierd thing is this was working fine and then it just started throwing this error, "Cannot insert explicit value for identity column in table 'Reports' when IDENTITY_INSERT is set to OFF." Here is the code: [Code]....

DataSource Controls :: Multiplying Column Values On Insert Statement?
This is my code so far: SQL = "insert into " & tableNameToday _ & "(ID, Name, Calories, Of_Which_Fat, Protein, Carbohydrate, Of_which_sugars," _ & "Fat, Of_Which_Saturated, Of_Which_Monounsaturates, Of_Which_Polyunsaturates," _ [Code]....  how do i multiply the columns like this. for now static explanation would be ok but eventually i would like to make it dynamic so there would be a text box for users to enter the amout they like e.g 160g then the table would know to multiply the columns by 1.6.

DataSource Controls :: Way O Insert Statement Conflicted With Column Foriegn Key Constraint
I have a stored procedure which i pass a number of parameters into. One of these parameters is staffNo (only passed this in because i couldn't execute the query without it). The thing is this field can be Null, but when trying to pass null into it it comes up with an Foreign Key conflict. staffNo is a foreign key within the table i'm inserting the data into.This is the error i get:"INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'PropStaffFK'. The conflict occurred in database 'DewMountain', table 'TblStaff', column 'staffNo'. The statement has been terminated. The 'PropertyAdvert' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. "

SQL Server :: How To Insert Data Based On Gridview User Value On Row
I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this  ItemNo ItemName Qty  uservalue 001       A               50       20 002       A               20       5 003       B               50   004       C               60      10 005       D               40  006       E               90      15  ........ If its 300 row from database to gridview it will show 50 record with page navigation..What i need is i need to insert data in to database table which gridview row has user value..The output of the another table(Table2) will look like this after insert ItemNo ItemName   uservalue 001       A                    20 002       A                      5   004       C                    10 006       E                    15 

Forms Data Controls :: Cannot Insert The Value NULL Into Column 'UniqueID'
so i have a FormView bound to an SQL datasource. Using the Auto generated insert/update/delete. "Cannot insert the value NULL into column 'UniqueID'" The FormView Default view = Edit I have set the PKey and the Datasource is loading the record from a session. The record is loading no problem, just wont update.

SQL Server :: Cannot Insert The Value NULL Into Column ReviewDate - Table "ProrsumDB.dbo.Review"
I've been working on this project which requires me to insert data into a database. Due to the complexities of the function that I am doing, it is more complex to use SqlDataSource and hence I've used the traditional method of inserting to the database. The codes are as follows: [Code].... I am not too sure why, but even though I've debugged numerous times and the data gets inserted into the database through the form view, I get this error on the page after everything is executed: Cannot insert the value NULL into column 'reviewDate', table 'ProrsumDB.dbo.Review'; column does not allow nulls. INSERT fails. The statement has been terminated. reviewDate wasn't null when I tried and there are no exception thrown.

Forms Data Controls :: DetailsView - Cannot Insert The Value NULL Into Column 'Title'
why I am getting this error when I try to insert data in a DetailsView 2.0?  Cannot insert the value NULL into column 'Title',table'C:INETPUBWWWROOTTESTAPP_DATAQUIZ.MDF.dbo.Question'; column does not allow nulls. INSERT fails. I used the Configure Data Source wizard to set this up and Question ID is a autonumber. When you autogenerate the Insert button on a Detailsview control and click on that button during run time the control posts back with text input areas where you are supposed to type the Title, Answer1, Answer2 etc. Obviously I typed data in to this text area labeled Title. It didn't work and that's why I'm asking about the control. Because I can't debug the control I am having a hard time figuring out where the problem is. Here is the code: [code]....

Forms Data Controls :: Cannot Insert Explicit Value For Identity Column In Table 'UserDetails'
I have error: Cannot insert explicit value for identity column in table 'UserDetails' when IDENTITY_INSERT is set to OFF. I'm trying to insert a record through a BLL (Business Logic Layer) class with an 'Insert' button attached to the FooterTemplate of a GridView2. My code:   [Code].... [Code].... BLL layer code:   [Code]....   The field 'idUser' is autoincremented. When I use SqlDataSource with a DetailsView, add option it adds a record and autoincrements the 'isUser'.

Forms Data Controls :: How To Insert Several Checkbox Values Into A Single Column In The Table
i have a form with several checkboxes....i want to insert the selected checkbox values in to a single column in the sql database..

MVC :: Cannot Insert Explicit Value For Identity Column In Table
Following the MVC1 vers of Nerddinner, but using 2010 and MVC2. Never seen this error. Looked in controller, model, view. Where does MVC pass the identity value, and how to stop it? I have never had to set IDENTITY_INSERT in any app before.

How To Insert The Value That Is Not In Textbox Into Database Which Is Primary Key For Table Without Identity...
i have created a web form, where i have 3 textboxes into a table   and one submit button. i would like to store values from the textboxes  into my database (sql server) when i click the submit button. but how to insert the value that is not in textbox into database which is primary key for table without identity column.

ADO.NET :: Error - Cannot Insert The Value NULL Into Column 'Cid
I have a table called category that has tow attribute (Cid,Name)  what can i do to insert  category name only without allow user to insert category id in my webpage, I use view detail control and make the wizard link but when run the error message appear (Cannot insert the value NULL into column 'Cid) note the identity properties is not pass.

Error - Cannot Insert The Value NULL Into Column 'Vid'
I have two table with a one to many relation. 1- voteChoose has (Choid PK,Choose,Vid) 2-VoteQuestion has(Vid PK,Vquestion,Action) so when insert a question and answer in a page this error message (  Cannot insert the value NULL into column 'Vid') appears i use this function to add vote  public void AddVote(string VQuestion, string[] Choose)

C# Return Identity After Insert Using SQL DB
I need to know how to return th Id after inserting row, I can do it by many ways, but I need to know why my code doesn't work? [Code]....

ADO.NET :: Show Identity Value Before Insert?
I have a registration page that must contain a user id label. When a user tries to register, the label on the page should show the identity value for the registration before completion. How to do this?

MVC :: Insert Many To Many With Linq To Sql
I have two Table Products(ProductID,ProductName) and Categories(CategoryID,CategoryName) with Many to many Relation Between Products and Categories ProdctsCategries(ProductID,CategoryID) How Can I Implement a view that enable user to add and Edit one prodcut to many category Using ASP.NET Mvc and LINQ TO SQL

ADO.NET :: Linq Insert/update Exception?
I am using Linq-To-Sql to add people to a one-to-one table. Sometimes I get a error "Violation of PRIMARY KEY constraint" when the person is already added. Can anyone give me instruction on how to handel the exception. [Code]....

DataSource Controls :: Insert Dbnull With Linq To SQL?
I am trying to do an update and if no selection has been made in a dropdownlist (integer) or date field I would like to insert a dbnull value. But I am new to Linq to Sql and wonder if this is possible and if so how to process. I have the following code but the DBNull.Value is giving me an error. Dim context As New SondageDataContext() Dim repondant = (From r In context.Repondants Where r.RefRepondant = iRefRepondant Select r).Single repondant.Prenom = strPrenom repondant.Nom = strNom 'dates If dtAdhesion > Date.MinValue Then repondant.DateAdhesion = dtAdhesion else repondant.DateAdhesion = DBNull.Value End If 'Integer for dropdownmenu If iOccupation <> -1 Then repondant.RefOccupation = iOccupation Else repondant.RefOccupation = DBNull.Value End If context.SubmitChanges()

ADO.NET :: Insert Data Into Database Using LINQ To Sql I Have Textboxes?
i want to insert data into database using LINQ to sql i have textboxes and when i enter data and click the button data has to be entered into the db,i have seen examples and googled but i dint get the correct to do this??

Insert An Empty Record Using LINQ Query?
I have a LINQ query like this: var query1 = from x in db.FaqCategories select new { x.CategoryId, x.Category }; What I would like to get is a query with an empty record var empty = new {CategoryId="", Category=""}; on the very top of query1. I think this can be accomplished by using the union operator, just don't know how.

ADO.NET :: Insert Data Into Database Using LINQ To Sql Have Textboxes?
i want to insert data into database using LINQ to sql i have textboxes and when i enter data and click the button data has to be entered into the db,i have seen examples and googled but i dint get the correct to do this??If possible give me small example.

Linq Insert Statement Inserts Nothing, Does Not Fail Either?
I am trying to insert a new account in my Acccounts table with linq. I tried using the EntityModel and Linq2Sql. I get no insert into my database nor an exception of any kind. public static Linq2SQLDataContext dataContext { get { return new Linq2SQLDataContext(); } } [code]...

How To Specify A Default Value For A Field In A .NET Details View Insert Mode
.NET newbie. I know there has to be a way to do this.I have a details view with it's default mode set to Insert. This is to be used as a form for users to enter records into a database. For two of the fields, I want to pre-populate the field with information. Specifically, I have a vb script with a few functions to query Active Directory to return the user's name based upon their user id. This script works fine.I call the functions for the user name like this: <InsertItemTemplate> <asp:TextBox ID="txtUserID" runat="server" Text='<%#CurrentUID() %>'></asp:TextBox> </InsertItemTemplate> <InsertItemTemplate> <asp:TextBox ID="txtUserName" runat="server" Text='<%# GetUserName(CurrentUID()) %>'></asp:TextBox> </InsertItemTemplate> When the page loads, this populates the text boxes with the user id and the user name.But when the form is submitted, the values in the text boxes are not inserted in to the database.How can I set default values for the fields when the values come from functions?

Security :: CreateUserWizard With Inserting A New Member?
I can't seem to add a new member when using the CreateUserWizard.... All my validation seems to be working...I don't think it is wired up correctly though because:   1. No user is added to the database (remote)   2. CompleteWizardStep does not fireI tried to see if anything was happening by stepping through the page's VB code and flagged...AddUserWizard_CreatedUser  sub...but it did not fire...I created a user using the built-in ASP.NET Configuration Wizard.. I also created a login file and I can successfully login.... just can't create a user with the CreateUserWizardmy hunch after some investigating is that I am missing something in my web.config file...I suspect I need something under the <authentication> tag???

Forms Data Controls :: Stop An Update Bind / Database Insert At This Point?
I'm using SqlDataSource and at the point of adding a record, I've called SqlDataSource_UploadNewsLetter_Inserting. In here, I'm testing a value, and if it's true, I need to stop the insert from taking place. But how can I stop the database insert at this point?

Forms Data Controls :: Insert Date To Access Db?
In gridview, one of my fields is date. (i have editing enabled). I want, everytime i update the gridview, to get date and store it in [date] field in database.

SQL Bulk Insert And Operating System Error 3
I have two servers. One is a web server and one is a sql server. What I'm trying to do is as follows: User uploads a document to a web site. File is stored on a web server in a directory, verified that it's a certain type of file, and saved. When the user presses a submit button, the page is uploaded and the Onclick event triggers a sql bulk insert (not on the same web server.) That's it in a nutshell. The basics of this page are done. The file can be saved but for whatever reason, I'm getting a Operating system error code 3(The system cannot find the path specified.) I've modified the machine.config on the web server to impersonate another user. I've made sure that the directory in question can be reached from both servers (and it can.) I can open/edit/delete the file  from the directory from both sides, but evidently that's not the issue.

Jquery - Insert Checkbox Checked Value To Textbox?
I have a 45 checkboxes in webform with values 1 to 45 i want insert checkbox checked value to textbox in comma seperated string as in ascending order as 1,2,3,4,5 ...if checkbox1, checkbox2, checkbox3, checkbox4 and checkbox5 is checked...if these checkboxes will be unchecked then the inserted value in textbox will be removed 1 by one respectively. .. hwo to do this using or jquery or javascript ..

How To Insert Checkbox Checked Value To Textbox Without Autopostback
I have unlimited checkboxes to my webpage .How to insert checkbox checked value to textbox without autopostback. I i check checkbox1 and checkbox2 then in textbox it appear as 1,2 ...and after when i uncheck checkbox1 then in textbox the value would be 2. and if i uncheck checkbox1 and checkbox2 then value in textbox is blank

Insert Phone Number Format?
I have any form for register member. my field phone number is 3 text input . how to import into one row(col) mysql?? and how to show for edit .

Batch Inserts And Prepared Query Error?
Ok, so I need to populate a MS Access database table with results from a MySQL query. That's not hard at all. I've got the program written to where it copies a template .mdb file to a temp name and opens it via odbc. No problem so far.I've noticed that Access does not support batch inserting (VALUES (foo, bar), (second, query), (third query)). So that means I need to execute one query per row (there are potentially hundreds of thousands of rows). Initial performance tests show a rate of around 900 inserts/sec into Access. With our largest data sets, that could mean execution times of minutes (Which isn't the end of the world, but obviously the faster the better). So, I tried testing a prepared statement. But I keep getting an error (Warning: odbc_execute() [function.odbc-execute]: SQL error: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect , SQL state 07001 in SQLExecute in D:....php on line 30). Here's the code I'm using (Line 30 is odbc_execute): $sql = 'INSERT INTO table ([field0], [field1], [field2], [field3], [field4], [field5]) VALUES (?, ?, ?, ?, ?, ?)';[code].... So my question is two fold. First, is there any idea on why I'm getting that error (I've checked, and the number in the array matches the field list which matches the number of parameter ? markers)? And second, should I even bother with this or just use the straight INSERT statements? Like I said, time isn't critical, but if it's possible, I'd like to get that time as low as possible (Then again, I may be limited by disk throughput, since 900 operations/sec is high already)...

Looping A Db Insert Statement With Dates?
I need to run a statement that will populate a data base with the same information every time EXCEPT for the date. im currently trying something along these lines and aren't having any luck. DECLARE i_int BINARY_INTEGER := 1; BEGIN WHILE i_int <= 30 LOOP INSERT INTO bs_events.......... I can't seem to get it to work and im stuck in a code hole and cannot think straight. I basically want the date to up by one from 01-30 and then i will manually change the month and run the script again for all 12 months of the year.

Insert Into Middle Of Array
I've read over all of the array functions at The closest thing to what I'm looking for is array_push(). But I can't figure out how to use push to put data in at a specific point in the array, just the beginning. I want to insert data in the middle of my arrays while preserving/pushing back all the values behind it: array(0,1,2,3,4); insert_into_array at 2(value1,value2,value3) so then my array is 0,1,2,value1,value2,value3,3,4 How do you do this? I'm feeling befuddled, maybe I should get more sleep (I really don't get enough sleep:()

Insert Row Into Middle Of Table
Is there a lovely easy way of swapping 2 mysql rows? Come to think of it, swapping the unique IDs instead of the entire row data may have the desired effect.

Jquery :: Insert Default Value If Input-text Is Deleted
I have the following piece of jQuery code: [code]If a user have posted the form, and something is entered into one of the fields, then I can't show the default value in the field, if the user deletes the text from the input field.This is happening because the value of the text-field is still containing something, even when the user deletes the content. So my problem is how to show the default value when the form is submitted, and the user then removes the typed in content?When the form is submitted the input looks like this, and keeps looking like this until the form is submitted again:<input type="text" value="someValue" defaultvalue="From" />So I need to show the default value in the input-field right after the user have deleted the content in the field, and removed the focus from the field.

Jquery :: Insert Text Into The Input / Textarea
<div class="ctrlHolder"> <label for="" id="name.label">Name</label> <input name="name" id="name" type="text" class="textInput small" /> <p class="formHint">The name of the item you are submitting</p> </div> How can I insert predefined text into a input element. I'd like this function to active when the user doubleclicks the label element. $('#name.label').dblclick(function(){ $('#name').val('some text'); });

Insert Parameter Into Input Text?
i want to store some parameter in input text. im using this code to get the querystring parameter Code: <script language="javascript" type="text/javascript"> function qs(unique) { var query =; var parms = query.split('&'); [code].... how do i store this parameter in input text?

Building Insert Query
I'm somewhat confused on how to build an insert query that will take $this->tagPositions and insert it as a record in my db. It's an decrypted block of text. PHP Code: function decompPositions($positions) { $this->tagPositions = unserialize(base64_decode(urldecode($positions))); }

Paypal IPN Script: Create On Site That Receives Confirmed Payment Messages And Inserts Into Wordpress...
There are two parts to this question, so I'm going to pubish it as two separate questions. The first one deals with interfacing with IPN and is this: I need to create a simple .php script that can interface with Paypal's IPN system everytime I receive a confirmed payment for a given product. The script will then install the user into my wordpress user's database as a "member" (which is a custom role I've defined) using their email address as their username and the paypal transaction id as their password. I'm doing it this way because I can easily enter all the people who have purchased prior to this, into the database without having to generate random passwords for everyone. The second question will be much easier and that's how to use the IPN data (firstname, lastname, email address and transaction id) to enter the user into the wordpress member database.

Android :: Cannot Link One Person In People To Facebook
I have a ton of people in People (google) and 300 people in Facebook. All seem to link just fine. Except one person. She is in People (google) and in Facebook. Same exact name. If I open up People, she is there. If I open up Facebook friends, she is there. When I open up People, find her and try to link to Facebook, she is not there.

Android :: Facebook / Address Book Link And Updates?
When I open my address book and edit a contact and select facebook to link the contact. It updates and uses the picture from facebook. This is a very neat option, my question is when I link a profile from facebook to a contact does this decrease battery life, or can I change some setting so facebook wont update but maybe once a day?

Android :: Remove Facebook Contacts From Phone Contacts?
How can I remove facebook contacts from phone contacts?:rolleyes::confused:

Android :: Webview Anchor Link - Jump Link - Not Working
I have a WebView in my Android App that is loading an HTML string using the loadDataWithBaseURL() method. The problem is that local anchor links (<a href="#link">...) are not working correctly. When the link is clicked, it becomes highlighted, but does not scroll to the corresponding anchor. This also does not work if I use the WebView's loadUrl() method to load a page that contains anchor links. However, if I load the same URL in the browser, the anchor links do work. Is there any special handling required to get these to work for a WebView? I am using API v4 (1.6). There isn't much to the code, here are the relevant parts of some test code I've been working with: CODE:...................

Android :: Link Up UI Elements To Data In Complicated Link Item
How can I link like the Checkbox and larger TextView to external data? Should I use a SimpleCursorAdapter? Or create my own adapter? Should it extend ArrayAdapter or BaseAdapter? My list item UI:

Android :: Organizing Contacts - Gmail - Facebook
i keep all of my contact in my gmail contact list. I also have facebook on my droid2 and whenever i go to my contacts list to make a call both my gmail contacts and my facebook contacts are in the list. I have 500 facebook contacts and many of them are just people i have known in the past but dont talk to so I dont need them in my phones contact list. it also makes teh list HUGE having 500 more contacts. I want to change it so that when i go to my contact list I only see my gmail contacts.

Android :: Back Up Facebook Details With Gmail Contacts?
I've just spent a while linking Facebook details with Gmail contacts and my phone book. How should I best backup all this data now? I really don't want to have to link it all again if I lose my phone or need to do a factory reset. Is there some way of exporting all the data now? I tried exporting to SD card and then adding to Gmail contacts and this didn't copy across facebook photos.

Android :: Sync FaceBook Pictures To GMail Contacts
I have my Contacts updated with Facebook profile pictures, but when i check on the GMail website, no contact has the Facebook photo. I want to synchronize the pictures from Facebook to the contacts I have on my GMail account.

Android :: Links To Articles - How To Move Palm Contacts To Gmail Contacts
I'm about the take the Android (EVO specifically) plunge. I'm coming from an old Palm phone. Wow, talk about a quantum leap. Anyway, to prepare for the move, how do I get my Palm contacts into Gmail's contacts? Is that how it works? I need to move my Palm contacts to Gmail contacts, right? Then when I get my new EVO, it will sync with Gmail and my contacts will be in the new phone?

Android :: Automatically Synced With Google Contacts
I just got a new incredible last week, and have already been using a Google Contacts account for some time. When entering a new contact on an iPhone, the info is automatically synced with Google contacts, and vice versa. My Google contacts automatically appear in my phone directory, but how can I get new contacts entered thru my phone synced to my google account, without having to manually select 'contact type' when entering the info?

Android :: Application For Merge Of SIM Contacts With GMail Contacts
i've been looking for an application for merging the SIM contacts with the GMail contacts but can't seem to find any. Does anyone know if such an application is available? The result now is that i have a huge list of contacts (GMail + SIM) with many duplicates and information spread around different entries. Remark: i'm not sure if this question belongs here, but i had to choose between the G1 T-mobile and this forum.

Android :: Android: Best Way - Library To Write An App That Simply Gets - Sets Your Facebook Status,...
I have the Android Facebook-Connect library running in my emulator and I'm able to set my status with the Facebook API I have setup. However, I don't know where to go from there? Am I supposed to use the session key that this library allows me to get and make some Facebook API calls? I haven't found any code examples to even see what the proper syntax is. Am I better off using another library? I tried fbrocket with limited luck(I get a "server error 104 - Incorrect signature").