Store multiple values
-
Hi , I have a checked listBox control , which stores multiple items.The thing is , I should store these values and then retrieve.How could I store these values in a SqlColumn ? ( I am sorry it could be an Sql Forum question but there could be a way using C# before Sql, so I decided to post it here.) Thanks a lot. Bahadir Cambel.
-
Hi , I have a checked listBox control , which stores multiple items.The thing is , I should store these values and then retrieve.How could I store these values in a SqlColumn ? ( I am sorry it could be an Sql Forum question but there could be a way using C# before Sql, so I decided to post it here.) Thanks a lot. Bahadir Cambel.
Bahadir Cambel wrote: How could I store these values in a SqlColumn ? Well, it seems to me you want more than one column. If you want to put all the fields of a checked item in the ListBox control into one column, then you should probably put them into a comma delimited string first. In either case, put your data into SqlParameters, like:
SqlParameter param=new SqlParameter("@foo", myFooValue);
Then add the parameter:
cmd.Parameters.Add(param);
Then do the ExecuteNonQuery call. Of course, I'm leaving out the creation of the SqlCommand cmd variable and some other stuff, but that's not relevant to your question. Marc MyXaml Advanced Unit Testing YAPO
-
Bahadir Cambel wrote: How could I store these values in a SqlColumn ? Well, it seems to me you want more than one column. If you want to put all the fields of a checked item in the ListBox control into one column, then you should probably put them into a comma delimited string first. In either case, put your data into SqlParameters, like:
SqlParameter param=new SqlParameter("@foo", myFooValue);
Then add the parameter:
cmd.Parameters.Add(param);
Then do the ExecuteNonQuery call. Of course, I'm leaving out the creation of the SqlCommand cmd variable and some other stuff, but that's not relevant to your question. Marc MyXaml Advanced Unit Testing YAPO
Thanks for the reply Marc, I thought in the same way , but I asked for that there may be a better solution. What about putting values into a class/struct,and then serialize it binary and put into a binary column ? Do you have any ideas ? Is it possible ? and could it be more efficient ?
-
Thanks for the reply Marc, I thought in the same way , but I asked for that there may be a better solution. What about putting values into a class/struct,and then serialize it binary and put into a binary column ? Do you have any ideas ? Is it possible ? and could it be more efficient ?
Bahadir Cambel wrote: What about putting values into a class/struct,and then serialize it binary and put into a binary column ? You could do that, but you may encounter, at some point, the need to query the DB, and then you don't have very searchable data. Also, beware of the .NET binary formatter. It isn't very efficient. It encodes into hideous xml, actually! You'd have to do your own binary serialization if you want efficiency, but then again, you should probably rely on the server to keep things efficient, imo. Marc MyXaml Advanced Unit Testing YAPO
-
Bahadir Cambel wrote: What about putting values into a class/struct,and then serialize it binary and put into a binary column ? You could do that, but you may encounter, at some point, the need to query the DB, and then you don't have very searchable data. Also, beware of the .NET binary formatter. It isn't very efficient. It encodes into hideous xml, actually! You'd have to do your own binary serialization if you want efficiency, but then again, you should probably rely on the server to keep things efficient, imo. Marc MyXaml Advanced Unit Testing YAPO
Thanks a lot for the replies Marc.