how to insert textblock in combobox in sql server

Javier R 211

how to insert Textblock in Combobox in Sql server

<ComboBox Margin="10,20,0,0" x:Name="cbCategoria" Width="180">
                            <ComboBoxItem IsSelected="True">
                                <TextBlock x:Name="txtAlimento"  x:Uid="Alimento" Style="{StaticResource TextTextStyle}"/>
                            </ComboBoxItem>
                            <ComboBoxItem>
                                <TextBlock x:Name="txtMedioAmbiente"  x:Uid="MedioAmbiente"  Style="{StaticResource TextTextStyle}"/>
                            </ComboBoxItem>
                            <ComboBoxItem>
                                <TextBlock x:Name="txtParasito"  x:Uid="Parasito"  Style="{StaticResource TextTextStyle}"/>
                            </ComboBoxItem>
                            <ComboBoxItem>
                                <TextBlock x:Name="txtInsecto" x:Uid="Insecto"  Style="{StaticResource TextTextStyle}"/>
                            </ComboBoxItem>
                            <ComboBoxItem>
                                <TextBlock x:Name="txtMedicamento" x:Uid="Medicamentos"  Style="{StaticResource TextTextStyle}"/>
                            </ComboBoxItem>

                        </ComboBox>

Yitzhak Khabinsky 25,106 Reputation points

2021-10-25T15:59:17.373+00:00

@Javier R ,

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)
Dan Guzman 9,211 Reputation points

2021-10-25T16:45:59.367+00:00

Are you asking how to load the combo box items from the results of a SQL Server query?
Javier R 211 Reputation points

2021-10-25T16:51:45.223+00:00

code to insert into database

cmd.Parameters.Add("@Category", SqlDbType.VarChar, 40).Value = cbCategoria;
Javier R 211 Reputation points

2021-10-25T16:54:22.327+00:00

code to insert into database

cmd.Parameters.Add("@Category", SqlDbType.VarChar, 40).Value = cbCategoria;
Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-10-26T01:23:54.39+00:00

Do you means insert TextBlock into ComboBox dynamically?
Javier R 211 Reputation points

2021-10-26T09:55:18.943+00:00

when the user chooses an option from the Combobox is inserted into the database table.

5 answers

Olaf Helper 40,901 Reputation points

2021-10-26T06:06:51.433+00:00

how to insert Textblock in Combobox in Sql server

There are no kind of controls "in" SQL Server, only in application.

code to insert into database

No, it's not, in the code line you just assign a parameter for a query, which we don' know.
Please sign in to rate this answer.
Javier R 211 Reputation points

2021-10-27T12:49:34.497+00:00

I want to know how to insert in the database (table) the option that the user chooses in the Combobox

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-10-28T01:43:01.28+00:00

Combobox has SelectionChanged , you could invoke your command in that event handler.

Javier R 211 Reputation points

2021-10-28T08:07:35.013+00:00

if I use selectionChnaged in this aprte I would have to put thes entence of the select

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-10-28T09:05:02.547+00:00

Could you explain what's the mean of put thes entence of the select?

Javier R 211 Reputation points

2021-10-28T13:16:49.347+00:00

if something selectionchanged afterwards as I do to bring this to the sqls part of the code

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-10-29T07:38:45.087+00:00

You could also make submit button and invoke sql command with current ComboBox selected item.

Javier R 211 Reputation points

2021-10-30T15:51:22.32+00:00

If I do Selection_Changed as I do when I choose in the combobox it appears in the database table in the code

cmd.Parameters.Add("@Category", SqlDbType.VarChar, 40).Value = cbCategoria

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-11-01T01:48:06.237+00:00

You can't set cbCategoria uielement to sqldb value directly, you need pass cbCategoria selected item.

Javier R 211 Reputation points

2021-11-01T16:23:23.87+00:00

CbCatagoria is the name of the Combobox therefore I put: CbCategoria.selectedItem
Sign in to comment
Tom Phillips 17,716 Reputation points

2021-10-29T11:49:41.17+00:00

Just to be clear.

SQL Server does not have UI. It is the back end database for storage.

You are apparently asking a question about EF. Your question would be better asked on the EF forum.
Please sign in to rate this answer.
Javier R 211 Reputation points

2021-10-30T15:48:47.74+00:00

I have combobox formed by comboboxitem and Textblock as I can enter what I chose in the combobox in the database table

Tom Phillips 17,716 Reputation points

2021-11-01T19:25:05.82+00:00

You cannot save data to SQL Server using pure HTML code. You must use a programming language like Java, C#, javascript, ASP, etc to access SQL Server from your web server.

Javier R 211 Reputation points

2021-11-02T11:00:52.57+00:00

Language is c# and xaml (UWP)

Tom Phillips 17,716 Reputation points

2021-11-02T12:11:32.293+00:00

See this tutorial:
https://learn.microsoft.com/en-us/visualstudio/data-tools/create-a-simple-data-application-with-wpf-and-entity-framework-6?view=vs-2019

Javier R 211 Reputation points

2021-11-02T19:54:52.173+00:00

if I have a Combobox with ComboboxItem that includes a Textblock as I can save the Text="" of the Textblock in the database º

<Combobox x:Name=CbDosis">
<ComboBoxItem>
<Textblock Text=""/>
</ComboboxItem>
</ComboBox>

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-11-04T03:04:05.863+00:00

Why not use datatemplate to replace above Textblock ? you could refer to code sample here
Sign in to comment
Javier R 211 Reputation points

2021-11-04T20:30:29.547+00:00
if I make an example how I take the code to the sql part: the problem I have is that the Textblock carries x:Uid=""

cmd.Parameters.Add("@Category", SqlDbType.VarChar, 40).Value = cbCategoria
Please sign in to rate this answer.
Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-11-05T07:47:09.797+00:00

Please refer document here Refer to a string resource identifier from code

var resourceLoader = Windows.ApplicationModel.Resources.ResourceLoader.GetForCurrentView(); var cbCategoria = resourceLoader.GetString("Alimento");

Javier R 211 Reputation points

2021-11-05T08:41:02.75+00:00

what I mean according to example as I take the ComboBox _ SelectionChanged to the sql part.

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-11-05T09:29:22.31+00:00

So, what's the key point? and what feature that you want to implement?

Javier R 211 Reputation points

2021-11-05T15:48:02.673+00:00

when the user chooses one of the options that the ComBoBox has in this case are the Textblock that are in each Comboboxitem that is saved in the database table

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-11-08T01:33:41.883+00:00

You could save only ComBoBox selected item into database table.

Javier R 211 Reputation points

2021-11-08T08:56:31.717+00:00

exactly , When the user chooses one of the options that are in the Combobox this has to be saved in the database.

Nico Zhu (Shanghai Wicresoft Co,.Ltd.) 12,856 Reputation points

2021-11-10T08:13:39.707+00:00

What's the CommandText you used?

Javier R 211 Reputation points

2021-11-22T17:18:56.577+00:00

This is code for: enter the Text into the database

ComboBoxItem Item = cbCategoria.SelectedItem as ComboBoxItem; TextBlock textBlock = Item.Content as TextBlock; if(Item != null) { return; }

Javier R 211 Reputation points

2021-11-22T17:21:40.25+00:00

For Category Table varchar
Sign in to comment
Javier R 211 Reputation points

2021-11-24T14:40:51.707+00:00
when I choose one of the options of the Combobox I get the error: textblock was null. if I implement the code inside the bootn Accept me produces described above.

ComboBoxItem Item = cbCategoria.SelectedItem as ComboBoxItem; TextBlock textBlock = Item.Content as TextBlock;

if I do SelectionChanged it gives me error in the code that is the button Accept dciendo that declares textBlock.

cmd.Parameters.Add("@category", SqlDbType.VarChar, 40).Value = textBlock.Text;
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Javier R 211 Reputation points

2021-12-07T10:25:52.87+00:00
This is the application for comboboxes (ComboBoxitem). this is the release for the database

<ComboBox x:Name="ComboBox1"> <ComboBoxItem Content=""/> <ComboBoxitem Content=""/> </ComboBox> cmd.Parameters.Add("@category", SqlDbType.VarChar, 40).Value = cbComboBox1.SelectionBoxItem.ToString();
Please sign in to rate this answer.
Tom Phillips 17,716 Reputation points

2021-12-07T13:57:07.787+00:00

Again, this is not related to SQL Server. Your question is related to Entity Framework and C# development. Your question is better asked in the appropriate forum.

Javier R 211 Reputation points

2021-12-07T14:23:47.93+00:00

Hello ;

this is the Combobox request to insert the data into the database.

Tom Phillips 17,716 Reputation points

2021-12-07T15:35:19.377+00:00

Again, again. Your questions are about EF development. This is not related to SQL Server.

Please post your questions here:
https://stackoverflow.com/questions/tagged/entity-framework
Sign in to comment