Comments by Stylus STYLUS (Top 58 by date)

Feel free to do so. I have time and I will treat you the same as you treat me. A JERK. THANK YOU

That is not solution. Thank you

It works. DEAL. Anyone who posts, I will answer
1) This is not your google
2) This is not your Chat GPT

Thank you

There are only some smart people and philosophers here, including you. You just talk and argue and I never got a single answer or solution. Fine writes string Working = rd.GetString("R1") Reads only textual data, I need to convert to numbers varchar or decimal. I don't understand what needs to be explained so much, short, clear and simple. If you don't know, you shouldn't have answered anything

Thank you

Example?

I modified the code with my data, it reads my labels but does not read the query, code no errors just not read query

I try to solve that :-)

I check now. Table hae 3 records

Of course
https://www.google.com/search?q=Cloud+hosted+database+read+data+to+list+view+xamarin+C%23&sca_esv=577106327&sxsrf=AM9HkKnvIjVKm26CNyQnwSpKkTF73afX-w%3A1698397137986&source=hp&ei=0Xs7Zd7GOPj87_UPlfGB-AE&iflsig=AO6bgOgAAAAAZTuJ4a2AIxlX4lpwIlQC-9BdARqnA8Io&ved=0ahUKEwie89-w7pWCAxV4_rsIHZV4AB8Q4dUDCAk&uact=5&oq=Cloud+hosted+database+read+data+to+list+view+xamarin+C%23&gs_lp=Egdnd3Mtd2l6IjdDbG91ZCBob3N0ZWQgZGF0YWJhc2UgcmVhZCBkYXRhIHRvIGxpc3QgdmlldyB4YW1hcmluIEMjSKsDULABWLABcAF4AJABAJgBtAGgAbQBqgEDMC4xuAEDyAEA-AEC-AEBqAIKwgIHECMY6gIYJw&sclient=gws-wiz

This is solution?

All question, I post answer: YOU HAVE ON GOOGLE AND POST LINK FROM SEARCH.
OKAY???
ALL QUESTION SMART GUY

I'm looking for someone to guide me, that's why I was looking for examples for you to guide me. And not to be smart here and give me some lectures. You are not in a position to lecture me, nor will you write my code for me. I wrote and created everything in my life, neither you wrote to me, nor some idiot like you. I was just looking for a XAMAR example application with a CLOUD base. That's all, not that someone is lecturing me here. If you don't have an example or something clever to say, please don't be boring. Thank you

Nobody is mine, a slave, nor am I looking for it. I was culturally looking for an example of a connection for a mobile application. The answer is nowhere near perfect. I was looking for a XAMARINE connection example, not a simple widows forms connection. If you think you're smart, stop philosophizing, offer an example, not just be smart. On this page, no matter what someone asks, you think first and argue with people because you are bored in life. Unlike you, some people do something and live from it. If you don't have a specific answer (some example) to offer, you don't need to respond, comment or anything else, and not only when you don't like something, you delete the question. Thank you

XAMARIN, I have app with standard sql conection. Need for mobile. NOT GOOGLE SEARCH. Need example
Thank you

row_num Naziv J.M. Izlaz
1 SIS CEVAP
1 AJVAR Kilogram
2 SREDNJI CEVAP
2 BIBER Kilogram
3 VELIKI CEVAP

That is not solution

I don't undestand conection parameters. Need update existing local db and replace with cloud db
Inetad this

SQLiteConnection con;
public SQLiteConnection GetConnectionWithCreateDatabase()
{
string fileName = "sampleDatabase.db3";
string documentPath = System.Environment.GetFolderPath
(System.Environment.SpecialFolder.Personal);
string path = Path.Combine(documentPath, fileName);
con = new SQLiteConnection(path);
con.CreateTable<employee>();
return con;
}

need to be

Data Source=94.251.1.1,1433;Initial Catalog="BCC";User ID=admin;Password=admin

Where to insert that paramteres?

I am new in mobile development
Need to put new string in app
I know how to do in visual studio c# Windows Forms
Mobile development don't now
I wan't to learn how to change conn string in xamarin
Existing work, how to replace existing sting for new?
Show me

Instead local database need to replace cloud database
This is data
Data Source=94.251.1.1,1433;Initial Catalog="BCC";User ID=admin;Password=admin

Data are fake. Just for example

private void SaveEmployee(object sender, EventArgs e)
{
if (saveBtn.Text == "Potvrdi")
{
Employee employee = new Employee();
employee.Name = name.Text;
employee.Address = address.Text;
employee.PhoneNumber = phoneNumber.Text;
employee.Email = email.Text;
employee.Password = password.Text;

bool res = DependencyService.Get<isqlite>().SaveEmployee(employee);
if (res)
{
Navigation.PopAsync();
}
else
{
DisplayAlert("Message", "Data Failed To Save", "Ok");
}
}
else
{
// update employee
employeeDetails.Name = name.Text;
employeeDetails.Address = address.Text;
employeeDetails.PhoneNumber = phoneNumber.Text;
employeeDetails.Email = email.Text;

bool res = DependencyService.Get<isqlite>().UpdateEmployee(employeeDetails);
if (res)
{
Navigation.PopAsync();
}
else
{
DisplayAlert("Message", "Data Failed To Update", "Ok");
}
}
}

Yes, it is possible. I solve to another place. Thank you

Yes, it is possible. I solve to another place. Thank you

DEAR SIR, I WANT TO PUT MULTIPLE QUERY IN ONE TABLE.
EACH QUERY ONE COLUMN
ALL NEED TO BE I ONE TABLE
WHAT IS PROBLEM?

Are you kidding me?

(select name from table1) as Name, (date from table2) as Date, (select name, sum(qty) as QTY from table3 group by name ) as QTY, (select name from table3) as NameY

Result new table

column1 (Name), Column2(Date), Column3(QTY), Column4(NameY)

(select name from table1) as Name, (date from table2) as Date, (select name, sum(qty) as QTY from table3 group by name ) as QTY, (select name from table3) as NameY

Result new table

column1 (Name), Column2(Date), Column3(QTY), Column4(NameY)

Sir, I need an example of how to add more columns to one table, but the result of each column should be the result of a query
What are you not summarizing?
1 query one column
I need a table with 36 columns

I need an example of how one column can be the result of one query
Why?
Because when I have two queries, they are two columns

select (query1 union query6 union query7) as column1,
(query2 union query9 union query10) as column2,
(query3) as column3,
(query4) as column4,
(query5) as column5
to one table

Are you just fooling around and screwing people on this site?
I need an example where each query is one column
What is the problem?
If you don't know, don't answer anything, don't just think
Everything I need is well written
Thank you

select (query1 union query6 union query7) as column1,
(query2 union query9 union query10) as column2,
(query3) as column3,
(query4) as column4,
(query5) as column5

to table

need example

Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.

All need to be in one table

--query 1

select t.naziv, SUM(convert(float,t.kolicina)) as kolicina,t.CIJENA, SUM(convert(float,t.UKUPNO))as 'UKUPNO'
from
(select roba as naziv, Format(sum(kolicina),'#,0.00') as kolicina, Format((mp_cijena) ,'#,0.00') as 'CIJENA', Format(sum(iznos_sa_pdv) ,'#,0.00') as 'UKUPNO' from dbo.mp_racun_roba
where roba IN(select naziv from roba_usluge where podgrupa_artikala = 'Hrana') and id_fakture IN(SELECT id FROM dbo.mp_racun_lista WHERE datum = '2023-05-18')
group by roba, mp_cijena
union all
select roba as naziv,Format(sum(kolicina),'#,0.00') as kolicina,Format((mp_cijena) ,'#,0.00') as 'CIJENA', Format(sum(iznos_sa_pdv) ,'#,0.00') as 'UKUPNO' from dbo.mp_faktura_roba
where roba IN(select naziv from roba_usluge where podgrupa_artikala = 'Hrana') and id_fakture IN(SELECT id FROM dbo.mp_faktura_lista WHERE datum = '2023-05-18')
group by roba, mp_cijena
) t
group by t.naziv, t.CIJENA


--query 2

SELECT * FROM DBO.normativi_roba WHERE id_fakture IN (SELECT id FROM DBO.normativi_lista WHERE naziv='BUREK')

string folderPath = "C:\\PDFs\\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "Putni nalog PN3.pdf", FileMode.Create))
{
iTextSharp.text.Font calibriTitle = new iTextSharp.text.Font(bfCalibri, 12);
iTextSharp.text.Font calibriSubTitle = new iTextSharp.text.Font(bfCalibri, 10);
iTextSharp.text.Font calibriPN1 = new iTextSharp.text.Font(bfCalibri, 18);
Document pdfDoc = new Document(PageSize.A4.Rotate(), 10f, 10f, 10f, 0f);
//Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
//pdfDoc.Add(new ListItem(korisnik_programa, calibriTitle));
// pdfDoc.Add(new ListItem(adresa, calibriSubTitle));
pdfDoc.Add(new ListItem(mesto, calibriSubTitle));
// pdfDoc.Add(new ListItem("JIB:" + " " + jib2, calibriSubTitle));
// pdfDoc.Add(new ListItem("PIB:" + " " + pib2, calibriSubTitle));
// pdfDoc.Add(new ListItem("Žiro-racun:" + " " + ziro_racun2, calibriSubTitle));
//pdfDoc.Add(new ListItem("E-mail:" + " " + e_mail, calibriSubTitle));
pdfDoc.Add(table);
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));

Cant add complete code

Me i Have complete code, need simple solution in one row to rotate table

Complete code

//Exporting to PDF

string folderPath = "C:\\PDFs\\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "Putni nalog PN3.pdf", FileMode.Create))
{
iTextSharp.text.Font calibriTitle = new iTextSharp.text.Font(bfCalibri, 12);
iTextSharp.text.Font calibriSubTitle = new iTextSharp.text.Font(bfCalibri, 10);
iTextSharp.text.Font calibriPN1 = new iTextSharp.text.Font(bfCalibri, 18);
Document pdfDoc = new Document(PageSize.A4.Rotate(), 10f, 10f, 10f, 0f);
//Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
//pdfDoc.Add(new ListItem(korisnik_programa, calibriTitle));
// pdfDoc.Add(new ListItem(adresa, calibriSubTitle));
pdfDoc.Add(new ListItem(mesto, calibriSubTitle));
// pdfDoc.Add(new ListItem("JIB:" + " " + jib2, calibriSubTitle));
// pdfDoc.Add(new ListItem("PIB:" + " " + pib2, calibriSubTitle));
// pdfDoc.Add(new ListItem("Žiro-racun:" + " " + ziro_racun2, calibriSubTitle));
//pdfDoc.Add(new ListItem("E-mail:" + " " + e_mail, calibriSubTitle));
pdfDoc.Add(table);
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
//pdfDoc.Add(pdfTable);
// pdfDoc.Add(pdfTable2);
//pdfDoc.Add(pdvTable); ////tabela donja mesto i tip vozaca


PdfContentByte cb = writer.DirectContent;
PdfContentByte cb1 = writer.DirectContent;
//cb.SetColorStroke(new BaseColor(41, 128, 185));// boja linija


//iTextSharp.text.Rectangle fakturisao = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 520f, 50f);
iTextSharp.text.Rectangle PN1 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 50f, 594f, pdfDoc.PageSize.Width - 98f, 50f);
//iTextSharp.text.Rectangle glavnivozac1 = new iTextSharp.text.Rectangle(340f, 550f, 160f, 50f, 270);
iTextSharp.text.Rectangle glavnivozac1 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 332f, pdfDoc.PageSize.Width - 401f, 50f); //1 vozac
iTextSharp.text.Rectangle glavnivozac2 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 302f, pdfDoc.PageSize.Width - 401f, 50f); //2 vozac
iTextSharp.text.Rectangle glavnivozac3 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 272f, pdfDoc.PageSize.Width - 401f, 50f); //3 vozac

iTextSharp.text.Rectangle pomocnivozac1 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 332f, pdfDoc.PageSize.Width - 210f, 50f); //1 pomocni vozac
iTextSharp.text.Rectangle pomocnivozac2 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 302f, pdfDoc.PageSize.Width - 210f, 50f); //2 pomocni vozac
iTextSharp.text.Rectangle pomocnivozac3 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 272f, pdfDoc.PageSize.Width - 210f, 50f); //3 pomocni vozac

iTextSharp.text.Rectangle relacija = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 226f, pdfDoc.PageSize.Width - 401f, 50f); //relacija
iTextSharp.text.Rectangle serija = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 460f, pdfDoc.PageSize.Width - 401f, 50f); //serija
iTextSharp.text.Rectangle mjesto = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 509f, pdfDoc.PageSize.Width - 401f, 50f); //mjesto

Rotate pdf table

Set location for table

With this method replace empty places with some another
I need to remove just first char which is empty
' RN 001 2023' AND NEED TO BE 'RN 001 2023'

Solved. You solve. Thank you

That is solution. Thank you

const string DATE_FORMAT = DateTime.Now.ToString('yyyy');

const string strCon2 = "Data Source=.\\SQLEXPRESS;Initial Catalog=BSS "+DATE_FORMAT+";Integrated Security=True";

error CS0133: The expression being assigned to 'Program.DATE_FORMAT' must be constant

This is my conecction string

const string strCon2 = "Data Source=.\\SQLEXPRESS;Initial Catalog=BSS "+year+";Integrated Security=True";

Defined year
private readonly string year = DateTime.Now.Year.ToString();

This part of con string "+year+"; is problem

Error CS0236 A field initializer cannot reference the non-static field, method, or property 'Program.year'

Same error

c#

Example?

In this code datagrid have all vaules from table, not just from notificationLabel.Text

Thank you

My dear friend, thank you.

I need solutin for c#, not sql.

Like...

if (checkbox1.Checked && !checkbox2.Checked)
{
insert into sql...
}
else if (!checkbox1.Checked && checkbox2.Checked)
{
insert into sql...
}

Thank you

korisnikId = Convert.ToInt32(myCommand.ExecuteScalar());

This line is error

I wrong I need help. Thank you

Exception is number from command

private static int korisnikId;
private static int korisnickaGrupa;
private string korisnickoIme;

I forgot this...I added on start code line