使用c#将图像插入cassandra blob
本文关键字:cassandra blob 插入 图像 使用 | 更新日期: 2023-09-27 18:08:25
我正在尝试将图像插入到列数据类型blob
的Cassandra表
插入i得到错误:
输入时无变量可选
ISession CluSession = cluster.Connect("dbs");
MemoryStream ms = new MemoryStream();
OpenFileDialog f = new OpenFileDialog();
f.InitialDirectory = @"H:'MobilePics_sufian'";
f.Filter = "All Files |*.*|JPEGs|*.jpg|Bitmaps|*.bmp|GIFs|*.gif";
f.Multiselect = true;
DialogResult dr = f.ShowDialog();
int i = 0;
if (dr == System.Windows.Forms.DialogResult.OK)
{
foreach(string file in f.FileNames)
{
i = 1;
lstimage.Items.Add(file.ToString());
FileStream fs = new FileStream(file.ToString(), FileMode.OpenOrCreate, FileAccess.Read);
byte[] MyData = new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
CluSession.Execute("insert into Product1(id,name,p_image) values (" + i + "," + "hello" + "," + MyData.ToArray() + ")");
i = i + 1;
}
}
使用参数化查询,如(…值(?, ?)…),并添加参数。您的查询方式,它将具有值(1,"hello", "Array")....(或相似的)。
从这里查看文档:https://github.com/datastax/csharp-driver