Fully Editable Datagrid
Nov 10, 2005
I have been trying to formulate a fully editabe datagrid for a couple of days with no luck. I have used code from 4guys and some other sites and am at the point where I can render the datagrid correctly (as a bouncolumn and template column-textbox) but when I try to update the database it all falls apart. I am getting "input string was not in a correct format" and the error references ...Dim id as Integer = Convert.ToInt32(sls.DataKeys(dgi.ItemIndex))I suspect the problem lies in the area of primary indexes and such. The table I am using is a simple two-column table with usernames, passwords. Username is the primary field. Here is the actual code I am using...<code><%@ Page Explicit="True" Language="VB" Debug="True" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><html>
<script runat="server">Dim Connect As OleDbConnection = New OleDbConnectionDim Adapter As OleDbDataAdapter = New OleDbDataAdapterDim DS As DataSet = New DataSetDim ConnectString, SelectStatement As String
Sub Page_Load(Sender As Object, E As EventArgs)
If Not IsPostBack Then SelectStatement = "Select * From Table"ConnectString = "Provider=SQLOLEDB;UID=;PWD=;" & "Data Source=;Initial Catalog=;"
Connect.ConnectionString = ConnectStringAdapter.SelectCommand = New oleDbCommand(SelectStatement, Connect)Adapter.SelectCommand.Connection.OpenAdapter.Fill(DS, "Items")sls.Datasource = DS.Tables("Items")Page.DatabindConnect.Close()End IfEnd Sub
Sub Click(sender As Object, e As EventArgs) Dim myConnection as New OleDbConnection(ConnectString)Dim updateSQL as String = "UPDATE Table SET password = @Password WHERE Username = @ID"Dim myCommand as New oleDbCommand(updateSQL, myConnection)
Dim dgi as DataGridItemFor Each dgi in sls.Items 'Read in the Primary Key Field Dim id as Integer = Convert.ToInt32(sls.DataKeys(dgi.ItemIndex)) Dim password as String = CType(dgi.FindControl("txtPass"), TextBox).Text
'Issue an UPDATE statement... myCommand.Parameters.Clear() myCommand.Parameters.Add("@ID", id) myCommand.Parameters.Add("@Password", password)
myCommand.ExecuteNonQuery()Next
End Sub
</script><body><form runat="Server">
<asp:datagrid id="sls" runat="server" AutoGenerateColumns="False" datakeyfield="Username"> <Columns> <asp:BoundColumn HeaderText="UserName" datafield="Username"/>
<asp:TemplateColumn HeaderText="Password"> <ItemTemplate> <asp:TextBox runat="server" id="txtPass" Columns="10" Text='<%# DataBinder.Eval(Container, "DataItem.Password") %>' /> </ItemTemplate> </asp:TemplateColumn>
</Columns> </asp:datagrid><asp:button id="Update" text="Update All" runat="Server" onclick="Click"/></form></body></html></code>Anyone have any idea as to why the id variable (error message above) is causing problems?
View 2 Replies
ADVERTISEMENT
May 14, 2008
Having read the following :
How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/
How to obtain the latest SQL Server 2000 service pack
http://support.microsoft.com/?kbid=290211
Service Pack 4 for Microsoft SQL Server 2000
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32desksp4.htm#_1461463_hardware_and_software_requiremen_fzpy
Cumulative list of the hotfixes that are available for SQL Server 2000 SP4
http://support.microsoft.com/?kbid=894905
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
http://support.microsoft.com/?kbid=916287
Which appears to indicate
8.00.760 = sp3/sp3a
8.00.2039 = sp4
8.00.2187 = Cumulative rollup
8.00.2249 Final patch build number
I still have the following question which i would very much appreciate help in answering:
If support is required from Microsft what is the acceptable level of SQL Server patching before Microsoft will agree to look at a SQL Server problem. ?
SP4 Build 2039 + Build 2040 (awe fix)
SP4 Build 2187 cumulative rollup
SP4 Build 2249 fully patched as per KB894905
Do I need to apply builds 2187 to 2249 ?
If so where/how can I obtain the down loads from ( 8.00.2187 - 8.00.2249) ?
Have logged a call with microsoft support but as yet no responce.
View 8 Replies
View Related
Jun 11, 2007
Hello,
I want to put a textbox on the report such that the end-user can type in that textbox and then the text entered in the textbox could be captured by the report and could be used for further processing. Any pointers to this??
Thanks,
RS-2005
View 1 Replies
View Related
Sep 10, 2007
Is it possible to set up a report so that there's a column where the user can insert data of their own, which then gets saved to the underlying database?
What I'm thinking of is the ability to have a drop-down box at the end of each row of data in the report, whereby the user can select an option to specify the action they have taken in response to the data. Is this possible, and if so, how exactly would I achieve this?
View 9 Replies
View Related
Jul 10, 2007
I have created a table in sql studio and i need to make cell editable and be able to update them to the server. I have looked around here but all i can find is code for the site side, i need a way to do it in studio if possible. BTW im very new to this so im sorry in advance
View 3 Replies
View Related
Apr 12, 2004
I try to find the way to create editable data grid (a view from MySQL database) in a web page. So, user can edit, add, or delete from one page instead of having switch edit, insert pages, one field in the view only. Any script I need to write or any special server behavior I can use?
Thanks a lot any one can help with.
Ann
View 1 Replies
View Related
Feb 13, 2007
I have a custom component that takes in unicode stream and converts it to ascii text. However I would like to make my default string length and code page editable in the standard GUI editor. Right now I can set the default to 1000 characters, but when I try to change it, it says "Property value is not valid"
Any ideas?
Thanks!
View 1 Replies
View Related
Oct 5, 2007
I'm having a real hard time coming up with a solution to this problem. I created a custom gridview control from Dino Esposito's "Extending Gridview" article which autogenerates a checkbox column that allows for multiple record selection. Once a user checks a box, the entire row gets selected. I added a dropdown list on the top of the page that has only two options, "Yes" or "No". What I'm trying to do is update a boolean column called "contract" (I'm using the Pubs sample database) for all selected rows (via checkboxes checked) depending on whether the user selects "Yes" or "No" from the drop down menu. For example,1) the user selects "No" in the dropdown2) The user checks all rows in the checkbox column for which he wants the all the values"contract" field set to "No"3) The user then clicks on a button called "Submit" and all selected records get updated to "No" under the "contracts" column. The idea is to allow the user to change the boolean values from a field for multiple records. Hence, making individual cells editable is pointless. Anybody have an idea how to go about this?
View 3 Replies
View Related
Dec 6, 2007
Hello All,
We have a server running Windows Server 2003 with SQL Server 2005, it also does some minor file-sharing usage.
I noticed that the over 3/4 of our 2GB of RAM was being used by SQL and the pagefile was over 1.5GB constantly.
Needless to say this caused performance issues, so I upgraded to 4 GB of RAM.
However it would seem that nothing has changed.
The same amount of RAM is being committed to SQL resulting in the same size pagefile and 2GB of unused memory.
Should my Windows Processor Scheduling and Memory Usage be set to Programs or Background Services/System Cache for best performance and best usage of memory with SQL server?
Also when I look at the MS SQL server properties, what should these settings be for best performance and memory usage as they are currently set to:
NOT use AWE to allocate memory
0MB - minimum server memory
2147483647MB - maximum server memory
0KB - Index creation memory
1024KB - minimum memory per query
Any help with this problem would be greatly appreciated.
View 2 Replies
View Related
Mar 23, 2006
Having sucessfully tested mirroring, I've suggested we should implement it at my place of work.
However, they are non too pleased that it is not yet officialy part of SQL Server 2005 and therefore not supported, does anyone know when it will be in standard edition? because I really really need to know...
Thanks
View 4 Replies
View Related
Jul 17, 2014
When I export the report in excel format the chart is displayed as picture. I want it to be displayed as editable chart.Does Office Writer work in this situation and did anyone use Office Writer to accomplish same type of problem.Is there any other method or product we can use instead of the office writer.
View 2 Replies
View Related
Jan 31, 2008
Hi all,
i have a table1 with 3,25,000 records in US database.i want to upadate this table information in to table2 in SG database based on some condition (if prodid and skuno match in both tables, then update ordertransferind column in table2 from table1) what is happening is after 10,000 records query is not executing. in status bar it is displaying 'done'. but only 10,000 records are updating not the remaining ones. for this 10,000 records also it is taking more than 1 hour time. i tried by incresing the commandTimeout to max value(99999)...but still it is same...any advise...please suggest...
i am using sql2005,visualstudio 2005....
thanks for the help..
Anne
View 3 Replies
View Related
Jun 30, 2000
I know that you can fully qualify a database and dbo in a statement, but is it possible to do this for different servers? For example, if you have three different servers registered in Enterprise Manager, can you write a script that could query any of the three servers?
View 1 Replies
View Related
Nov 11, 1999
I am managing a number of SQL Server 6.5 systems via lan and wan connections.
I have a couple of servers which, althought I have an administrator account on the server and access through the fire walls, I can only connect if I set up entries under the client config utility using named pipes with the relevant ip address.
The servers are set up to use both tcp/ip and named pipes. When I do connect I dont get the traffic lights, and Service manager shows the servers in indeterminate state although I know they are running OK.
When I expand the server in EM, the SQL Executive also does not appear, again the service is running.
I am connecting to the server as sa, and can perform all sa functions.
I have connected to the server through security manager and it shows me as an administrator with sa rights.
We are using standard security on these servers.
Anybody any ideas ?
Thanks in advance
Tom
View 1 Replies
View Related
May 24, 2006
Hi all,
I need to create flat file connection managers. The connection Manager editor forces me to use fully qualified file names. Is there a possibility to use unqualified file names, because I need to reference to files in different directories with the identical file strcture.
Any Ideas?
Guido
View 1 Replies
View Related
Oct 25, 2007
I downloaded the windows installer: SQLServerCE31-EN.msi
When I run it, it creates a directory in Program Files The directory has a number of dll files, a Readme file, a word document, and a text document. There is no link to actually launch SQLServer though. I've tried repairing, and removing and reinstalling but the results are the same. Can someone help me figure out how to actually launch this application?
Thanks.
View 1 Replies
View Related
Nov 13, 2007
All:
I have about 35 packages in a SSIS Project and have been successful at building and deploying until now. For some reason it build stops processing after 5 packages and does not update the bindeployment folder.
Are there any logs to which I can refer to find out what is going on? Any ideas why I am experiencing this weird behavior all of a sudden.
I had to delete a couple of packages from my project as I created new replacements for them. I then noticed however that the packages did not get deleted from the bin and deployment folders and so I manually deleted them from those directories. Could this cause any problems and if so can I fix it now?
I appreciate your help and advice!
View 8 Replies
View Related
Mar 27, 2008
I have a database that has been upgraded from SQL 200 to 2005. The database was owned by 'Joe' and all objects were also owned by 'Joe'. In SQL 2000 when Joe logged in he could simply issue 'select * from table' and would get results.
The upgraded db now has a user Joe and a schema Joe. All objects now belong to the schema Joe. Joe the user has his default schema set to Joe and he is the owner of the schema. When Joe logs in and tries to 'select * from table' he gets an invalid object. He can 'select * from joe.table'.
How can I set it up so that the objects are still owned by the schema Joe and a simple 'select * from table' works when user Joe logs in? I was convinced that is he owned the schema and this was his default schema it should work.
Thanks
scott
View 1 Replies
View Related
Jun 3, 2015
SQL Server 2008 R2
Issue: In the globalts I have
<Expansion>
<sub>Multi-lan</sub>
<sub>Multilan</sub>
</expansion>
my where clause.. is similar to.'where Contains(Word, ''formsof(thesaurus,"'+@curWord+'") OR "'+@curWord+'*"'')'When i pass in Multi-Lan, i get results for Multi-LAN and MultiLAN.. however.. when i pass in Multilan.. i dont get results for Multilan nor Multi-lan.I have double checked my formats, and i have checked to see if this word was used in a previous expansion set.. everything checked out. I also have many other expansions that function without issue. BT and Bluetooth are interchangeable.
View 2 Replies
View Related
Nov 7, 2007
I have a database that is released as part of a thrid party product. I sent out an update but it failed at one of the customer sites because the objects were not fully quailified. The original statement work at all but one of the sites. The altered statement is what finally worked. The SQL Server instances are installation and configuration are controlled by our interface so all instances are installed and configured the same. Any idea on how this would happen? It has never happened on previous updates.
Original Statement:
SELECT * FROM tblProcesses WHERE ProcessName='Name'
IF @@ROWCOUNT=0
INSERT INTO tblProcesses(ProcessName, GroupTypeID, ProcessDesc) VALUES('Name', 1, 'Description')
GO
Altered Statement:
SELECT * FROM dbname.dbo.tblProcesses WHERE tblProcesses.ProcessName='Name'
IF @@ROWCOUNT=0
INSERT INTO tblProcesses(ProcessName, GroupTypeID, ProcessDesc) VALUES('Name', 1, 'Description')
GO
View 2 Replies
View Related
Nov 29, 2007
hi folks,
i am using foreach loop to load a whole load of files.
but these files are placed into various folders and with distinctive names.
each file is name is certain conventions that imply what sort of data is held in it. like
marketing_extract_20071204.csv
customers_extract_20071224.csv
but within the foreach loop i have a variable with the FULLY QUALIFIED NAME (FQN)as in:
Y:data_filesmarketing_extract_20071204.csv
thus i would like to find out how i can extract the filename from the FQN?
could i use a derived column expression or a script task?
many thanks for your assistance,
Nicolas
View 5 Replies
View Related
May 21, 2008
Details here: http://groups.google.com/group/visualsvn/browse_thread/thread/b05c327597d9cfae
Why not email them here
support@visualsvn.com
and get them to hurry up and fix it!
View 2 Replies
View Related
Aug 8, 2007
Why am im i getting this error I am trying to join four table from different databases.select INBTable.InBound_Calls, OUTTable.OutBound_Calls, INBTable.Line_Number as INLine_Number,
OUTTable.Line_Number as OUTLine_Number, INBTable.Hold_Time as INHold_Time,OUTTable.Hold_Time as OUTHold_Time, INBAbandonInfo.INAbandon_Calls as INBAbandon_Calls,
OUTAbandonInfo.OutAbandon_Calls as OUTAbandon_Callsfrom sql2.XMWin_Test.dbo.temp_Report20070807IN as INBTable
JOIN sql2.Juniper_I.dbo.temp_Report20070807OUT as OUTTableon INBTable.Line_Number = OUTTable.Line_Number
sql2.XMWin_Test.dbo.temp_GraphIN_INAbandon as INBAbandonInfoJOIN sql2.Juniper_I.dbo.temp_GraphIN_OutAbandon.Line_Number as OUTAbandonInfo
on INBAbandonInfo.Line_Number = OUTAbandonInfo.Line_Number
My Error Message:
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'sql2'.
View 2 Replies
View Related
Sep 21, 2007
Are there any perfmonace or query optimization limitations or issues that arise when issueing a fully qualified query across multiple databases on the same Instance of SQL Server. In other words are all features of query optimization fully supported in queries that span databases on the same Instance.
View 3 Replies
View Related
Dec 29, 2006
I wihsh to discuss whether to use fully qualified names:[database].[schema].objectof objects to operate (create, query..) on is good or not?If someone change order of sql code blocks in my script - this may causelose of it's context (like: use master / use <mydb>..). I wish to have mysript independed on changes like this and always produce correct result.Does using full name make use of 'use <db>' statement unnecessary?
View 8 Replies
View Related
Mar 21, 2008
Hello everyone...
Our team has a DBA governing body that refuses to accept any T-SQL script that our dev group writes where fully qualified names of the objects aren't used. These non fully named objects in scripts just aren't accepted in their world.
So, all the scripts the developers now have to write must have fully qualified names in them. Of course, the Query analyser in Managment Studio could care less about object names as long as ambiguity is not found. So, I need some sort of Static Code analysis of these scripts that my team creates in order to hand them over to our DBA's to run.
The DBA's intend to make this inspection a manual process (they have time to kill I guess)... but my team doesn't have that luxury. It is not easy to ensure all scripts have this qualification in them with some many of them being written.
Does anyone know of any algorithim, tool, or options that could help me detect the presence of non-fully qualified names in T-SQL scripts?
Thanks for any ideas...
Ron D.
View 3 Replies
View Related
Mar 30, 2007
We've set up a report farm with two servers, both 64 bit with 4 CPUs each. One has 16Gig and the other 8Gig of memory. We're using Windows NLB and the load test software confirms that the NLB is working. When we run a number of concurrent reports, both servers get utilized, but they only work on a few at a time. The report server queue doesn't seem to be fully utilizing the hardware. From a prior post I've learned that the report server queue automatically runs 4 reports per CPU. This is not occuring for our setup. Has anyone else experienced the same? Are there any configurations that need to be set to open the queue up? The reports are heavy (300,000 records grouped and summed). Does this affect the queuing process?
View 4 Replies
View Related
Aug 10, 2007
I need to take 8 indiviual parts of a table and combine then into 1 Column of a Datagrid. Is this even possible, if so how?
example:
The DB contains:
Comp1 Comp2 Comp3 ... Comp8
The DG should say
header --> Comp
Data --> Comp1, Comp2, Comp3, ..., Comp8
View 4 Replies
View Related
May 6, 2004
hey all
i have 2 tables
1. Location (locid, name)
2. Product (pid, locid, productname, ...etc)
right now i do a select * from product where locid ='locid', and a datagrid with colums
ProductId | ProductName | AvailableIn
how do i do a select * from Location where locid ='locid' and show Location Name in the datagrid?
ProductId | ProductName | AvailableIn
123456 | testing | Somewhere (instead of the locid)
thanks
View 2 Replies
View Related
Mar 31, 2007
I have a requirement.
I have a CUBE in SQL 2000. I need to change the structure of Fact Table and i need to add one more dimension to my CUBE.
What are the problems will arise if i do this. i need to Fully process the CUBE?
PLS help me
View 1 Replies
View Related
Jun 19, 2015
I had to migrate my report server (2008R2) to a new domain. I built new server and restored the old ReportServer and ReportServerTempDB into new server and also restored the certificate from old server. The Report Server is running but I don't have full access to all server futures anymore, looks like it's AD authentication messed up. My new account is Admin on new server but I can't see all options, like New Data Source, or wehn going on report level to manage to see all option such as Parameters, Subscriptions, Data Source.
View 2 Replies
View Related
May 30, 2008
Hi folks
I have deployed a package from file resources to sql server named instance. I did not receive any errors. msdb..dtspackages90 table have rows for my package.
But when I try to connect to integration services using ssms like 'serverinstance', I am getting an error saying that 'serverinstance' names are not supported by integrated services and I should use just a servername.
What am I doing wrong? Is that really integration services are not supported on named instances or i miss something?
Thank you, Gene.
View 4 Replies
View Related
Nov 9, 2006
The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example:
sqlcmd -E -S nnn.nnn.nnn.nnn
where nnn.nnn.nnn.nnn is the real IP address of the machine, or
sqlcmd -E -S hostname.domain.com
where hostname.domain.com is the fully qualified hostname of the machine, gives the error:
Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1
Login failed for user ''. The user is not associated with a trusted SQL Server c
onnection.
On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433.
This is on a clean machine, with SQL Server 2005 freshly installed as Administrator with mixed authentication, and the test runned also by Administrator.
Is it normal or is it a bug?
Thanks.
Georges
View 1 Replies
View Related
