This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Save image to Database Sql Server Uwp c#
cmd.Parameters.Add("@picture", SqlDbType.Image).Value = Photo;
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 88%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
can you send me your social media account or your email i have the same issue
Attention download onedrive example :
All that is needed is the database for both the code and the StudentsTable.css!AsmtnygZJMcaoJViT-P-NPurh0G3zg
Download Example1
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
@Javier R I have checked your sample, you query and save the database data to students collection in bind() method. However, you didn’t call bind() method, so the students haven’t data, which caused your binding to fail. I suggest you could call bind() method in the constructor of StudentPage class like the following.
public StudentPage()
{
InitializeComponent();
bind();
}
Then a way that this students this case in bind()
@Javier R Does the code work? If not, what is the error message?
I have a question where it has to go. public async void bind
@Javier R You declared public ObservableCollection<StudentsTable> students; in StudentPage class, but it isn't instantiated. So you need to call the bind() method to add data for students. If you call this method in the constructor of StudentPage class, the students will be filled with data when the page is loaded.
You can put a example.
MemoryStream seems to be needed
using System.Runtime.InteropServices.WindowsRuntime; using Windows.Storage; ...... IStorageFile file; IBuffer buffer = await FileIO.ReadBufferAsync(file); byte[] picbytes= buffer.ToArray(); …… cmd.Parameters.Add("@picture", SqlDbType.Image).Value = picbytes;