Comments by Ailiseu Brigitta (Top 44 by date)

sorry guys i have created the table in name EMPLOYEE_SITEID and called it by EMP_SITEID my fault but i don't know how to read the item {
EmployeeItem s_item = new EmployeeItem();

s_item.Id = query.GetInt64(1);

empdetails.Add(s_item);
}

i retified the problem but sql is not reading

while (query.Read())

i retified the problem but sql is not reading

while (query.Read())

SQLite Error 1: 'no such table: EMP_SITEID'.

i am getting error called no such table: EMP_SITEID'.

i have updated my question

public static async void Writeemployee()
{
var path = @"text file\\GetAllEmp.txt";

string rawJson = File.ReadAllText(path, Encoding.UTF8);

ObservableCollection<employeeitem> Employee = new ObservableCollection<employeeitem>();
var jsonData = JsonConvert.SerializeObject(rawJson);

List<employeeitem> emp = JsonConvert.DeserializeObject<list<employeeitem>>(rawJson);
for (uint i = 0; i < emp.Count; i++)
{
EmployeeItem s_Item = new EmployeeItem();

s_Item.SiteID = Int64.Parse(emp.ToString());
DataAccess.AddEmployee(s_Item);

can i insert in a loop

there is no way to insert a new object? is there is othere way to insert a data

is that code is correct which i have wrote in the above question

it is avilable
i took the path from the text file properties

file can't be read which i have said in abve code sir

apolozies for that i don't know about this

apolozies for that i don't know about this

i have done all but still error

ok

can you plese give more detail for public static List<string> Getemployee() { try { string rawJson = System.IO.File.ReadAllText(@"C:\Users\Admin\Desktop\new folder\xyz.txt"); List<employeeitem> employees = JsonConvert.DeserializeObject<list<employeeitem>>(rawJson); } catch (Exception e) { Console.WriteLine("The file could not be read:"); Console.WriteLine(e.Message); } Console.Read(); return null; } please sir you are my only hope

i saw the link my friend

it 's ok grant no problem it is not must all to know all i understand

can you create a sample project and run my code if there is no error i accept your solution is correct please don't send link just run my code with your solution

ok i have gave you step by step detail and flow of code you are not providing detail. can you please send more details.

C#string rawJson = File.ReadAllText("file path of the text file");

List<employeeitem> employees = JsonConvert.DeserializeObject<list<employeeitem>>(rawJson);

this one

i still now can't solve my problem how can i mark it.your deserized method is not so clear for uwp

its ok grant i still now can't resolve my problem :-( its ok thank you for the time you spend for me :-)

where should i need to right observable collection , sorry i am new to c#

thank you very very much grant your code is working prety well but i can't print the data can you see my dataacess and find what erorr i have made

how to deserize in my code

can you correct my code

ok [{"Id":5,"GID":1,"SID":34},{"Id":4,"GID":1,"SID":33},{"Id":3,"GID":1,"SID":32}] Please help me my friend

please help me with this problem i have struck with this for 5 hours please :(

this error occurs//A field initializer cannot reference the non-static field, method, or property (st); this st can't be read

can give more details for the code

ok can you help how to delete a post.just to know about it

thank you

can you help me how to delete this post

ya i have already tried it and i convrted 84 table

no need sorry for that OriginalGriff thankyou for your response

thank you RickZeeland