Hi
Using SQLserver 2000 I have to enter a huge data (nearly 8000 charcters) into a field, which data type is suitable for that and what is the method to store data.
You might need to use a VARCHAR(8000) or a text datatype; however, there is not enough information.
Is your data divisible into different definite pieces? Do you need to support unicode? Is your data numeric? binary? Is your data XML Is there additional data that needs to be stored with the 8000 characters?
I have written following lines of code, but when TransferData() method is called, it generates error "Property LoginSecure cannot be changed or read after a connection string has been set."
Can anybody help me? Thanks in advance....
Code:
//1. Create Transfer Object
Transfer transObj = new Transfer();
//transObj=new Transfer(server.Databases[fromdatabasename]);
transObj.DestinationLoginSecure = false;
transObj.DestinationLogin = "sa";
transObj.DestinationPassword = "test";
//Set Destination Server//Build a "serverConnection" with the information of the "sqlConnection"
destSrvCon =
new ServerConnection(sqlCon);
//The serverConnection is used in the ctor of the Server.
destServer = new Server(destSrvCon);
transObj.DestinationServer = destServer.Name.ToString();
//2. Define Transfer Object's Properties
transObj.Database = server.Databases["Aworks"];
transObj.DestinationDatabase = "AWorksCopy";
transObj.Options.WithDependencies =true;
transObj.Options.ContinueScriptingOnError = true;
transObj.CopySchema = true;
transObj.CopyData = true;
transObj.CopyAllTables = true;
//4. Finally Transfer Data
transObj.TransferData();
//transObj.ScriptTransfer();
I got this error as well, and have tried everything to avoid it. The only explanation I have left is that I'm using server 2000. Is this what you're using Ritesh?
i get this same error.
did you guys resolve the problem?
ReplData folder? only folder i can think of is the folder where the database files are stored....
I have written following lines of code, but when TransferData() method is called, it generates error "Property LoginSecure cannot be changed or read after a connection string has been set."
Can anybody help me? Thanks in advance....
Code:
//1. Create Transfer Object
Transfer transObj = new Transfer();
//transObj=new Transfer(server.Databases[fromdatabasename]);
transObj.DestinationLoginSecure = false;
transObj.DestinationLogin = "sa";
transObj.DestinationPassword = "test";
//Set Destination Server//Build a "serverConnection" with the information of the "sqlConnection"
destSrvCon =
new ServerConnection(sqlCon);
//The serverConnection is used in the ctor of the Server.
destServer = new Server(destSrvCon);
transObj.DestinationServer = destServer.Name.ToString();
//2. Define Transfer Object's Properties
transObj.Database = server.Databases["Aworks"];
transObj.DestinationDatabase = "AWorksCopy";
transObj.Options.WithDependencies =true;
transObj.Options.ContinueScriptingOnError = true;
transObj.CopySchema = true;
transObj.CopyData = true;
transObj.CopyAllTables = true;
//4. Finally Transfer Data
transObj.TransferData();
//transObj.ScriptTransfer();
I got this error as well, and have tried everything to avoid it. The only explanation I have left is that I'm using server 2000. Is this what you're using Ritesh?
i get this same error.
did you guys resolve the problem?
ReplData folder? only folder i can think of is the folder where the database files are stored....
I have written following lines of code, but when TransferData() method is called, it generates error "Property LoginSecure cannot be changed or read after a connection string has been set."
Can anybody help me? Thanks in advance....
Code:
//1. Create Transfer Object
Transfer transObj = new Transfer();
//transObj=new Transfer(server.Databases[fromdatabasename]);
transObj.DestinationLoginSecure = false;
transObj.DestinationLogin = "sa";
transObj.DestinationPassword = "test";
//Set Destination Server//Build a "serverConnection" with the information of the "sqlConnection"
destSrvCon =
new ServerConnection(sqlCon);
//The serverConnection is used in the ctor of the Server.
destServer = new Server(destSrvCon);
transObj.DestinationServer = destServer.Name.ToString();
//2. Define Transfer Object's Properties
transObj.Database = server.Databases["Aworks"];
transObj.DestinationDatabase = "AWorksCopy";
transObj.Options.WithDependencies =true;
transObj.Options.ContinueScriptingOnError = true;
transObj.CopySchema = true;
transObj.CopyData = true;
transObj.CopyAllTables = true;
//4. Finally Transfer Data
transObj.TransferData();
//transObj.ScriptTransfer();
I got this error as well, and have tried everything to avoid it. The only explanation I have left is that I'm using server 2000. Is this what you're using Ritesh?
i get this same error.
did you guys resolve the problem?
ReplData folder? only folder i can think of is the folder where the database files are stored....
I have written following lines of code, but when TransferData() method is called, it generates error "Property LoginSecure cannot be changed or read after a connection string has been set."
Can anybody help me? Thanks in advance....
Code:
//1. Create Transfer Object
Transfer transObj = new Transfer();
//transObj=new Transfer(server.Databases[fromdatabasename]);
transObj.DestinationLoginSecure = false;
transObj.DestinationLogin = "sa";
transObj.DestinationPassword = "test";
//Set Destination Server//Build a "serverConnection" with the information of the "sqlConnection"
destSrvCon =
new ServerConnection(sqlCon);
//The serverConnection is used in the ctor of the Server.
destServer = new Server(destSrvCon);
transObj.DestinationServer = destServer.Name.ToString();
//2. Define Transfer Object's Properties
transObj.Database = server.Databases["Aworks"];
transObj.DestinationDatabase = "AWorksCopy";
transObj.Options.WithDependencies =true;
transObj.Options.ContinueScriptingOnError = true;
transObj.CopySchema = true;
transObj.CopyData = true;
transObj.CopyAllTables = true;
//4. Finally Transfer Data
transObj.TransferData();
//transObj.ScriptTransfer();
I got this error as well, and have tried everything to avoid it. The only explanation I have left is that I'm using server 2000. Is this what you're using Ritesh?
i get this same error.
did you guys resolve the problem?
ReplData folder? only folder i can think of is the folder where the database files are stored....
helloo
Can I use "like" in datatable.select method?
meaning:
Dim exp As String = "c.cDesc like " & txtSearch.Text & " + N'%' "
Dim rows() As DataRow = dtCenters.Select(exp)
knowing that txtSearch.text has unicode characters
Yes. However, your expression does not include quotes so you are probably not sending what you think you are sending.
Dim exp As String = "c.cDesc like '" & txtSearch.Text & "' + N'%' "
The better option is to use a parameter and set the value of the parameter to your textbox.
sql
I have become a big fan of the datasets in Visual Studio 2005. I usually create the SQL for each method in the table adapter; however, I am wondering if there is any 'built-in' functions in the C files for sql injection prevention? I have read that using stored procedures is a good method for prevention. Should I be using SP rather than SQL within my methods in the data table?
Hey,
Welcome to the forum. The key is, do you have any dataset queries that take user input and passes it to a SQL query directly? Then you may want to beware if that is true. I like the use of SPs because SQL Server will cache them for increased performance.
In addition, you should be able to use @.Parameters within a SQL query, and pass in the values as parameters, which is safer than embedding the response directly into the SQL query.
|||
wendycarpenter@.polk-county.net:
I am wondering if there is any 'built-in' functions in the C files for sql injection prevention?
Use parameterized queries!
http://aspnet.4guysfromrolla.com/articles/030106-1.aspx
|||I am using parameterized queries - I've included a sample below. SQL Injection prevention has been "in the air" a lot lately and I guess I want to make sure that I am doing what I need to do to keep my customers' data safe.
INSERT INTO [Case] ([cseYear], [cseNumber], [cseStatus], [csePartI], [csePartII], [cseDestruction])
VALUES (@.cseYear, @.cseNumber, @.cseStatus, @.csePartI, @.csePartII, @.cseDestruction);
select SCOPE_IDENTITY()
|||
I appreciate the link. Maybe I wasn't specific enough. I am using the built in dataset (.xsd), so I am not creating any sql statement within my code - I strictly call the method within the datatable of the table adapter within the dataset. Most of the work is done within the auto generated code within Visual Studio 2005.
|||Hey,
OK, which used the parameter approach I believe. That should be OK; I've seen several projects where Adapters were used even with secure info. Note that table adapters can also use stored procedures in case you want to be sure.
sql
Hey all... what is the proper method for setting a Dataset.xsd path in your Settings.settings value:
Here's the app.config from settings.settings value:
<add name="ffgsCRM.My.MySettings.ffgscrmConnectionStringSQLCE"
connectionString="Data Source = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData)\ffgsCRM.sdf"
providerName="Microsoft.SqlServerCe.Client" />
I have the above and wondered how to make the path dynamic to C:\Documents and Settings\USERNAME\Local Settings\Application Data\ffgsCRM.sdf in the settings.settings value.
Thanks a ton!!
Bill
I think what you want is to use the |DataDirectory| substitution. Eg "Data Source = |DataDirectory|\ffgsCRM.sdf"|||Thanks... but that only puts the .sdf in the bin and not where I need it. :)|||To set the DataDirectory property, call the AppDomain.SetData method. If you do not set the DataDirectory property, the following default rules are applied to access the database folder:
(from http://support.microsoft.com/kb/920700)
|||
|||
To be honest I think you missed the point that both Erik and I were making with the DataDirectory in the when you deploy using ClickOnce it will automatically set the path to the users docs & settings folder.
w.r.t making the dataset dynamic - you can always set the connection object on each of the tableadapters that are used to fill the dataset?
|||
Nick, I'm wrong and had an error in the deployment... sorry... I'm going to try and path the Dataset1 to the users c:\drive\somewhere and go from there.
Thanks,
Bill
|||
my bad...
|||Yea, but where to you use the call to AppDomain.SetData? I call it in the load routine of my start up form, and my data is still being directed to a data folder from the click once deployment, and not to the place I want it in my application executable folder. ? what the ?|||I did a public in the main form that looks like this for my dataset.xsd:
Public CRMConnectionString As String = "Data Source = " & Environment.GetFolderPath(Environment.SpecialFolder.ProgramFiles) & "\CRM.sdf"
Now when my app is fired up or deployed the dataset looks for the local db that is in the users program files folder... works all the time as long as you have the local db in the folder.
Hope this helps,
Bill
Hey all... what is the proper method for setting a Dataset.xsd path in your Settings.settings value:
Here's the app.config from settings.settings value:
<add name="ffgsCRM.My.MySettings.ffgscrmConnectionStringSQLCE"
connectionString="Data Source = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData)\ffgsCRM.sdf"
providerName="Microsoft.SqlServerCe.Client" />
I have the above and wondered how to make the path dynamic to C:\Documents and Settings\USERNAME\Local Settings\Application Data\ffgsCRM.sdf in the settings.settings value.
Thanks a ton!!
Bill
I think what you want is to use the |DataDirectory| substitution. Eg "Data Source = |DataDirectory|\ffgsCRM.sdf"|||Thanks... but that only puts the .sdf in the bin and not where I need it. :)|||To set the DataDirectory property, call the AppDomain.SetData method. If you do not set the DataDirectory property, the following default rules are applied to access the database folder:
(from http://support.microsoft.com/kb/920700)
|||
|||
To be honest I think you missed the point that both Erik and I were making with the DataDirectory in the when you deploy using ClickOnce it will automatically set the path to the users docs & settings folder.
w.r.t making the dataset dynamic - you can always set the connection object on each of the tableadapters that are used to fill the dataset?
|||
Nick, I'm wrong and had an error in the deployment... sorry... I'm going to try and path the Dataset1 to the users c:\drive\somewhere and go from there.
Thanks,
Bill
|||
my bad...
|||Yea, but where to you use the call to AppDomain.SetData? I call it in the load routine of my start up form, and my data is still being directed to a data folder from the click once deployment, and not to the place I want it in my application executable folder. ? what the ?|||I did a public in the main form that looks like this for my dataset.xsd:
Public CRMConnectionString As String = "Data Source = " & Environment.GetFolderPath(Environment.SpecialFolder.ProgramFiles) & "\CRM.sdf"
Now when my app is fired up or deployed the dataset looks for the local db that is in the users program files folder... works all the time as long as you have the local db in the folder.
Hope this helps,
Bill
sql
I have a gridview and a dataset. When I start my application I see the results in my gridview. When I clic on edit and chanche some value and click on update it wil give me this error:
ObjectDataSource 'ObjectDataSourcePersoon' could not find a non-generic method 'Update' that has parameters: naam, tussenvoegsel, achternaam, adres, woonplaats, telefoonnummer, original_id, Original_naam, Original_tussenvoegsel, Original_achternaam, Original_adres, Original_woonplaats, Original_telefoonnummer.
Does someone know whats the problem??
Can we see your code for both the GridView and the ObjectDataSource on your ASPX page?
||| <asp:GridView ID="GridView3" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="LightGoldenrodYellow" BorderColor="Tan"
BorderWidth="1px" CellPadding="2" DataKeyNames="id" DataSourceID="ObjectDataSourcePersoon"
ForeColor="Black" GridLines="None">
<FooterStyle BackColor="Tan" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" SortExpression="id" />
<asp:BoundField DataField="naam" HeaderText="naam" SortExpression="naam" />
<asp:BoundField DataField="tussenvoegsel" HeaderText="tussenvoegsel" SortExpression="tussenvoegsel" />
<asp:BoundField DataField="achternaam" HeaderText="achternaam" SortExpression="achternaam" />
<asp:BoundField DataField="adres" HeaderText="adres" SortExpression="adres" />
<asp:BoundField DataField="woonplaats" HeaderText="woonplaats" SortExpression="woonplaats" />
<asp:BoundField DataField="telefoonnummer" HeaderText="telefoonnummer" SortExpression="telefoonnummer" />
</Columns>
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<AlternatingRowStyle BackColor="PaleGoldenrod" />
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSourcePersoon" runat="server" DeleteMethod="Delete"
InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="DataSetRoosterTableAdapters.PersoonTableAdapter" UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_id" Type="Int32" />
<asp:Parameter Name="Original_naam" Type="String" />
<asp:Parameter Name="Original_tussenvoegsel" Type="String" />
<asp:Parameter Name="Original_achternaam" Type="String" />
<asp:Parameter Name="Original_adres" Type="String" />
<asp:Parameter Name="Original_woonplaats" Type="String" />
<asp:Parameter Name="Original_telefoonnummer" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="naam" Type="String" />
<asp:Parameter Name="tussenvoegsel" Type="String" />
<asp:Parameter Name="achternaam" Type="String" />
<asp:Parameter Name="adres" Type="String" />
<asp:Parameter Name="woonplaats" Type="String" />
<asp:Parameter Name="telefoonnummer" Type="String" />
<asp:Parameter Name="Original_id" Type="Int32" />
<asp:Parameter Name="Original_naam" Type="String" />
<asp:Parameter Name="Original_tussenvoegsel" Type="String" />
<asp:Parameter Name="Original_achternaam" Type="String" />
<asp:Parameter Name="Original_adres" Type="String" />
<asp:Parameter Name="Original_woonplaats" Type="String" />
<asp:Parameter Name="Original_telefoonnummer" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="naam" Type="String" />
<asp:Parameter Name="tussenvoegsel" Type="String" />
<asp:Parameter Name="achternaam" Type="String" />
<asp:Parameter Name="adres" Type="String" />
<asp:Parameter Name="woonplaats" Type="String" />
<asp:Parameter Name="telefoonnummer" Type="String" />
</InsertParameters>
</asp:ObjectDataSource>
<UpdateParameters>
<asp:Parameter Name="naam" Type="String" />
<asp:Parameter Name="tussenvoegsel" Type="String" />
<asp:Parameter Name="achternaam" Type="String" />
<asp:Parameter Name="adres" Type="String" />
<asp:Parameter Name="woonplaats" Type="String" />
<asp:Parameter Name="telefoonnummer" Type="String" />
<asp:Parameter Name="Original_id" Type="Int32" />
<asp:Parameter Name="Original_naam" Type="String" />
<asp:Parameter Name="Original_tussenvoegsel" Type="String" />
<asp:Parameter Name="Original_achternaam" Type="String" />
<asp:Parameter Name="Original_adres" Type="String" />
<asp:Parameter Name="Original_woonplaats" Type="String" />
<asp:Parameter Name="Original_telefoonnummer" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
Look at your UpdateParameters above, if the signature of your Update method does not accept the "Original_" parameters, then remove them from the declaration. You should only have the Parameters needed for your Update method.
|||I have removed them in the deafault.aspx page en it gives me now this error:
|||
The "id" parameter should be sent instead of the "original_id" parameter. Remove
OldValuesParameterFormatString="original_{0}"
from your ObjectDataSource collection and see if this works. The whole idea, is that the Parameters sent match the signature of your business class method.
|||Ik have do it again..remove all parameters with the prefix:
This is the error:
En this is the asp code:
<asp:ObjectDataSource ID="ObjectDataSourceTester" runat="server" DeleteMethod="Delete"
InsertMethod="Insert" SelectMethod="GetData"
TypeName="DataSetRoosterTableAdapters.PersoonTableAdapter" UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_id" Type="Int32" />
<asp:Parameter Name="Original_naam" Type="String" />
<asp:Parameter Name="Original_tussenvoegsel" Type="String" />
<asp:Parameter Name="Original_achternaam" Type="String" />
<asp:Parameter Name="Original_adres" Type="String" />
<asp:Parameter Name="Original_woonplaats" Type="String" />
<asp:Parameter Name="Original_telefoonnummer" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="naam" Type="String" />
<asp:Parameter Name="tussenvoegsel" Type="String" />
<asp:Parameter Name="achternaam" Type="String" />
<asp:Parameter Name="adres" Type="String" />
<asp:Parameter Name="woonplaats" Type="String" />
<asp:Parameter Name="telefoonnummer" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="naam" Type="String" />
<asp:Parameter Name="tussenvoegsel" Type="String" />
<asp:Parameter Name="achternaam" Type="String" />
<asp:Parameter Name="adres" Type="String" />
<asp:Parameter Name="woonplaats" Type="String" />
<asp:Parameter Name="telefoonnummer" Type="String" />
</InsertParameters>
</asp:ObjectDataSource
I dont know what the problem is!
Show us your Update method as well.
|||Here it is:
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>UPDATE [dbo].[Persoon] SET [naam] = @.naam, [tussenvoegsel] = @.tussenvoegsel, [achternaam] = @.achternaam, [adres] = @.adres, [woonplaats] = @.woonplaats, [telefoonnummer] = @.telefoonnummer WHERE (([id] = @.Original_id) AND ((@.IsNull_naam = 1 AND [naam] IS NULL) OR ([naam] = @.Original_naam)) AND ((@.IsNull_tussenvoegsel = 1 AND [tussenvoegsel] IS NULL) OR ([tussenvoegsel] = @.Original_tussenvoegsel)) AND ((@.IsNull_achternaam = 1 AND [achternaam] IS NULL) OR ([achternaam] = @.Original_achternaam)) AND ((@.IsNull_adres = 1 AND [adres] IS NULL) OR ([adres] = @.Original_adres)) AND ((@.IsNull_woonplaats = 1 AND [woonplaats] IS NULL) OR ([woonplaats] = @.Original_woonplaats)) AND ((@.IsNull_telefoonnummer = 1 AND [telefoonnummer] IS NULL) OR ([telefoonnummer] = @.Original_telefoonnummer)));
SELECT id, naam, tussenvoegsel, achternaam, adres, woonplaats, telefoonnummer FROM Persoon WHERE (id = @.id)</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.naam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="naam" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.tussenvoegsel" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tussenvoegsel" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.achternaam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="achternaam" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.adres" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.woonplaats" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="woonplaats" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.telefoonnummer" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefoonnummer" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@.Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@.IsNull_naam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="naam" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.Original_naam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="naam" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@.IsNull_tussenvoegsel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tussenvoegsel" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.Original_tussenvoegsel" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="tussenvoegsel" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@.IsNull_achternaam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="achternaam" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.Original_achternaam" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="achternaam" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@.IsNull_adres" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.Original_adres" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@.IsNull_woonplaats" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="woonplaats" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.Original_woonplaats" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="woonplaats" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@.IsNull_telefoonnummer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telefoonnummer" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@.Original_telefoonnummer" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telefoonnummer" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@.id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</UpdateCommand
And here is a picture of my dataset:
I've had this happen before. I'm assuming this is the Update method which was automatically generated by your TableAdapter. If so, I end up just adding my own Update method to the TableAdpater with the signature you want. Therefore, don't include any of the extra "Original_" Parameters.
|||I have made my own update and delete methods and now it works..Thank you for your good and fast support..
hi,
i created a query to insert a row in DataSet in Visual Studio 2005. i gave the method name to the query i created. as i understood it returns '1' if successful or '0' if not.
is it possible to get the ID or the row instead?
what did it say,or whats the eror code if there is?|||there is no error. the point is i would like to get the id of the row that i insert instead of default int value.
|||Hi,are you using a SQL 2k5? There is a new ouput clause in the syntax, where you can get values back. Look in the BOL for more information about that, or raise a hand if you need further assistance.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
i am using SQLExpress...
sorry should have mentioned earlier.
|||Hi,
ok then go the OUTPUT way (described in the BOL)
INSERT INTO Sometable (Columnlisthere....)
OUTPUT INSERTED.*
VALUES ...Values here...
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
Hi,
I am trying to run the EnumObjectPermissions method on the pubs database in SQL Server 2000. When it tries to enumerate the permissions for the public role it throws a InvalidCastException saying that you cannot cast a System.DBNull to System.String
I know that its not my code so I am unsure what to do to fix this issue. The code runs fine against other databases.
James
This may be a SMO bug. Do you have a code sample for this?|||I'm able to reproduce the InvalidCastException error on any SQL Server 2000 database by granting a "CREATE" database level permissions. By default the pubs database has these types of permissions granted to guest and public. I ran a trace an noticed SMO is sending the following query for EnumObjectPermissions calls:
SELECT
grantee_principal.name AS [Grantee],
grantor_principal.name AS [Grantor],
CASE prmssn.protecttype WHEN 204 THEN 87 WHEN 205 THEN 71 WHEN 206 THEN 68 END AS [PermissionState],
null AS [Code],
CASE prmssn.id WHEN 0 THEN 0 ELSE 1 END AS [ObjectClass],
null AS [ColumnName],
object_name(prmssn.id) AS [ObjectName],
user_name(prmssn.uid) AS [ObjectSchema],
prmssn.id AS [ObjectID],
CASE when 1 = grantee_principal.issqlrole THEN 3 WHEN 1 = grantee_principal.isapprole THEN 4 ELSE 2 END AS [GranteeType],
CASE when 1 = grantor_principal.issqlrole THEN 3 WHEN 1 = grantor_principal.isapprole THEN 4 ELSE 2 END AS [GrantorType],
CAST(prmssn.action AS int) AS [SqlCodePP]
FROM
dbo.sysprotects AS prmssn
INNER JOIN sysusers AS grantee_principal ON grantee_principal.uid = prmssn.uid
INNER JOIN sysusers AS grantor_principal ON grantor_principal.uid = prmssn.grantor
The ObjectName column is NULL for database level permissions, I would think EnumObjectPermissions would exclude database level permissions which should be included in EnumDatrabasePermissions?
Here's the SMO code I'm running against a SQL Server 2000 instance:
ServerConnection conn = new ServerConnection();
conn.LoginSecure = true;
conn.ServerInstance = "MyServer";
Server srv = new Server(conn);
foreach (Database db in srv.Databases)
{
Console.WriteLine(db.Name);
foreach (ObjectPermissionInfo objPermInfo in db.EnumObjectPermissions())
{
Console.WriteLine("{0,-35} {1,-25}", objPermInfo.ObjectName, objPermInfo.PermissionType);
}
}
|||I opened a case on this issue and it has been logged as a bug. The fix may be included in SQL 2005 SP2 or may be released as a hotfix
Hi,
I am trying to run the EnumObjectPermissions method on the pubs database in SQL Server 2000. When it tries to enumerate the permissions for the public role it throws a InvalidCastException saying that you cannot cast a System.DBNull to System.String
I know that its not my code so I am unsure what to do to fix this issue. The code runs fine against other databases.
James
This may be a SMO bug. Do you have a code sample for this?|||I'm able to reproduce the InvalidCastException error on any SQL Server 2000 database by granting a "CREATE" database level permissions. By default the pubs database has these types of permissions granted to guest and public. I ran a trace an noticed SMO is sending the following query for EnumObjectPermissions calls:
SELECT
grantee_principal.name AS [Grantee],
grantor_principal.name AS [Grantor],
CASE prmssn.protecttype WHEN 204 THEN 87 WHEN 205 THEN 71 WHEN 206 THEN 68 END AS [PermissionState],
null AS [Code],
CASE prmssn.id WHEN 0 THEN 0 ELSE 1 END AS [ObjectClass],
null AS [ColumnName],
object_name(prmssn.id) AS [ObjectName],
user_name(prmssn.uid) AS [ObjectSchema],
prmssn.id AS [ObjectID],
CASE when 1 = grantee_principal.issqlrole THEN 3 WHEN 1 = grantee_principal.isapprole THEN 4 ELSE 2 END AS [GranteeType],
CASE when 1 = grantor_principal.issqlrole THEN 3 WHEN 1 = grantor_principal.isapprole THEN 4 ELSE 2 END AS [GrantorType],
CAST(prmssn.action AS int) AS [SqlCodePP]
FROM
dbo.sysprotects AS prmssn
INNER JOIN sysusers AS grantee_principal ON grantee_principal.uid = prmssn.uid
INNER JOIN sysusers AS grantor_principal ON grantor_principal.uid = prmssn.grantor
The ObjectName column is NULL for database level permissions, I would think EnumObjectPermissions would exclude database level permissions which should be included in EnumDatrabasePermissions?
Here's the SMO code I'm running against a SQL Server 2000 instance:
ServerConnection conn = new ServerConnection();
conn.LoginSecure = true;
conn.ServerInstance = "MyServer";
Server srv = new Server(conn);
foreach (Database db in srv.Databases)
{
Console.WriteLine(db.Name);
foreach (ObjectPermissionInfo objPermInfo in db.EnumObjectPermissions())
{
Console.WriteLine("{0,-35} {1,-25}", objPermInfo.ObjectName, objPermInfo.PermissionType);
}
}
|||I opened a case on this issue and it has been logged as a bug. The fix may be included in SQL 2005 SP2 or may be released as a hotfix
Hi,
I am trying to run the EnumObjectPermissions method on the pubs database in SQL Server 2000. When it tries to enumerate the permissions for the public role it throws a InvalidCastException saying that you cannot cast a System.DBNull to System.String
I know that its not my code so I am unsure what to do to fix this issue. The code runs fine against other databases.
James
This may be a SMO bug. Do you have a code sample for this?|||I'm able to reproduce the InvalidCastException error on any SQL Server 2000 database by granting a "CREATE" database level permissions. By default the pubs database has these types of permissions granted to guest and public. I ran a trace an noticed SMO is sending the following query for EnumObjectPermissions calls:
SELECT
grantee_principal.name AS [Grantee],
grantor_principal.name AS [Grantor],
CASE prmssn.protecttype WHEN 204 THEN 87 WHEN 205 THEN 71 WHEN 206 THEN 68 END AS [PermissionState],
null AS [Code],
CASE prmssn.id WHEN 0 THEN 0 ELSE 1 END AS [ObjectClass],
null AS [ColumnName],
object_name(prmssn.id) AS [ObjectName],
user_name(prmssn.uid) AS [ObjectSchema],
prmssn.id AS [ObjectID],
CASE when 1 = grantee_principal.issqlrole THEN 3 WHEN 1 = grantee_principal.isapprole THEN 4 ELSE 2 END AS [GranteeType],
CASE when 1 = grantor_principal.issqlrole THEN 3 WHEN 1 = grantor_principal.isapprole THEN 4 ELSE 2 END AS [GrantorType],
CAST(prmssn.action AS int) AS [SqlCodePP]
FROM
dbo.sysprotects AS prmssn
INNER JOIN sysusers AS grantee_principal ON grantee_principal.uid = prmssn.uid
INNER JOIN sysusers AS grantor_principal ON grantor_principal.uid = prmssn.grantor
The ObjectName column is NULL for database level permissions, I would think EnumObjectPermissions would exclude database level permissions which should be included in EnumDatrabasePermissions?
Here's the SMO code I'm running against a SQL Server 2000 instance:
ServerConnection conn = new ServerConnection();
conn.LoginSecure = true;
conn.ServerInstance = "MyServer";
Server srv = new Server(conn);
foreach (Database db in srv.Databases)
{
Console.WriteLine(db.Name);
foreach (ObjectPermissionInfo objPermInfo in db.EnumObjectPermissions())
{
Console.WriteLine("{0,-35} {1,-25}", objPermInfo.ObjectName, objPermInfo.PermissionType);
}
}
|||I opened a case on this issue and it has been logged as a bug. The fix may be included in SQL 2005 SP2 or may be released as a hotfix
Hi,
I am trying to run the EnumObjectPermissions method on the pubs database in SQL Server 2000. When it tries to enumerate the permissions for the public role it throws a InvalidCastException saying that you cannot cast a System.DBNull to System.String
I know that its not my code so I am unsure what to do to fix this issue. The code runs fine against other databases.
James
This may be a SMO bug. Do you have a code sample for this?|||I'm able to reproduce the InvalidCastException error on any SQL Server 2000 database by granting a "CREATE" database level permissions. By default the pubs database has these types of permissions granted to guest and public. I ran a trace an noticed SMO is sending the following query for EnumObjectPermissions calls:
SELECT
grantee_principal.name AS [Grantee],
grantor_principal.name AS [Grantor],
CASE prmssn.protecttype WHEN 204 THEN 87 WHEN 205 THEN 71 WHEN 206 THEN 68 END AS [PermissionState],
null AS [Code],
CASE prmssn.id WHEN 0 THEN 0 ELSE 1 END AS [ObjectClass],
null AS [ColumnName],
object_name(prmssn.id) AS [ObjectName],
user_name(prmssn.uid) AS [ObjectSchema],
prmssn.id AS [ObjectID],
CASE when 1 = grantee_principal.issqlrole THEN 3 WHEN 1 = grantee_principal.isapprole THEN 4 ELSE 2 END AS [GranteeType],
CASE when 1 = grantor_principal.issqlrole THEN 3 WHEN 1 = grantor_principal.isapprole THEN 4 ELSE 2 END AS [GrantorType],
CAST(prmssn.action AS int) AS [SqlCodePP]
FROM
dbo.sysprotects AS prmssn
INNER JOIN sysusers AS grantee_principal ON grantee_principal.uid = prmssn.uid
INNER JOIN sysusers AS grantor_principal ON grantor_principal.uid = prmssn.grantor
The ObjectName column is NULL for database level permissions, I would think EnumObjectPermissions would exclude database level permissions which should be included in EnumDatrabasePermissions?
Here's the SMO code I'm running against a SQL Server 2000 instance:
ServerConnection conn = new ServerConnection();
conn.LoginSecure = true;
conn.ServerInstance = "MyServer";
Server srv = new Server(conn);
foreach (Database db in srv.Databases)
{
Console.WriteLine(db.Name);
foreach (ObjectPermissionInfo objPermInfo in db.EnumObjectPermissions())
{
Console.WriteLine("{0,-35} {1,-25}", objPermInfo.ObjectName, objPermInfo.PermissionType);
}
}
|||I opened a case on this issue and it has been logged as a bug. The fix may be included in SQL 2005 SP2 or may be released as a hotfix
