Hi bro I'm developing an online bingo app in android studio where the user is ready to play the server should find the opponent for it and start the match . For that what should I do or what online server should I choose pls guide me .
Hello sir, I am trying to program android, but it is very difficult to find resources. Can I ask you a question, especially regarding SQL server transactions? Do you have any ideas on how I can get the total values of records between 2 dates?
Is there any other thing needed to connect to database I have done all the things in this video but my connection have not been setup maybe u can help...!!
Check your SQL Server port no. Default port no is 1433. If it change in your sql server then put that one. to get port no- go to SQL Server Configuration manager. right click on the TCP/IP and go to the Property scroll down and see the port no. Thanks
Hello. First of all, thank you for this tutorial. It helped a lot! Thanks. On the second hand: Could you help me with, what should I do to connect my local database from a real device? I always get "connection refused" error. I know it could be the firewall, but can you help me, how could I allow the connection?
@@rivaldovola9896 I've found the solution. :) 1.) Go to the Control Panel 2.) Go to System and Security 3.) Go to Windows Firewall 4.) Now go to Advanced Settings Okay now you should import new policies for inbound and outbound rules. 1.) Select Inbound rules 2.) Click New Rule 3.) Select Port and then Next 4.) Now give your port which was 1433. 5.) Now press Next until you reach the final chapter. 6.) Give a name for the rule. (It can be anything) Okay, the inbound rule is done. Now you need to do the very same thing with outbound rule. Just be "careful" at the chapter named Action select the "Allow all Connection" option. I hope it helps :D
I struggled with getting my physical phone to work, but finally got it to work when I enabled port forwarding on the *router's* 'firewall status' section (to my laptop within the router's LAN) as well as on my laptop's firewall (laptop is on a Home WIFI), to make port 1433 open on my laptop's IP address. Hope this helps someone struggling with this.
@@ProgrammingGeekI'm waiting .. I'm waiting . I want use SQL server with android completely. I'm web developer .Use .Net c# with SQL server. So I want my web application in android using SQL data Base. Please make video. Thnx for responding
Hey man! I loved the video and found it very helpful, But there is one problem, I do not know how to find the ip address of the server, can you please tell me how to find the ip address of the sql server? Thanks in advance
IP address is in PCs, if your computer is in local network, you must have an IP Address. To get IP address of the server go to the ethernet settings. double click on LAN icon. You can use SQL server name instead of IP Address. Thanks.
You can do a complete project on human resource management android app connected to sql server. And has all the functions. Combined with RadioButton, Switch, Date May. I really need them. Please! I am an amateur.
Thanks man. This video so great that you have show data from SQL to textview in app Android. But now 09/ 2021, I have try many way, it really not workings that when I click button, no event listener appears.And I have connect check login from android to sql but it not working. Can you help me? Can I have link your Facebook to ask you? Thanks you a lot, I will be grateful you. Hope you reply my answer.
Late response but the answer is yes. The mobile phone and the laptop you are using are both needed to be in the same connection. To connect them to each other, you may use a single internet provider or just connect your phone through the mobile hotspot of your laptop.
@@ProgrammingGeek I have hosted Sql Server database and i can connect to it normally . now i need to create SQLite as local database and make sync between SQLite and remote sql server in android studio
I have develop water application which is run on localhost sql server. If install apk directly the conection string is working successfully that means i can login. But if i install apk via play store i can not login. Can any one help me about this. Please please
Hi Programming Geek, I want to know if we can use the Server Name rather than the IP Address to connect to SQL Server? Your reply would be really appreciated. Thank you!
Many many thanks sir. After a long time I have found such helpful tutorial. Thanks again.
Pleased to see your comment. Thanks.
The way you say "Oooow" is kinda adorable lol :) thanks for the tutorial really helps
So kind of you. Please keep connected.
thank you so much
If anyone has any problems connecting to the database. I tried to add a new firewall rule with port 1433, this is what worked for me.
Thanks for your comment
sorry to ask....after thenk you for this great job can i connect specify table on my database,..please help
Yes, you can connect to a specific table. Please mention table name in your SQL query.
I am connected to the database and can select values, but insert and update won't work.. do you know what could be the problem?
check the full code. at the ending watch data.add portion. hope you will success. Thanks.
so many thanks for you i have found it so helpful
Thank you too for your valuable comment. Please keep in touch.
Thank you so much man you are a lifesaver
Thanks for your valuable comments.
Excelente muy bien explicado, muchas gracias!
Thanks for your comment. Please keep connected.
Sir.. Can be acces local sql database form internet connection useing form anddroid app ?
Please try with real ip instead of local ip. Then it will be accessible from internet.
Hi bro I'm developing an online bingo app in android studio where the user is ready to play the server should find the opponent for it and start the match . For that what should I do or what online server should I choose pls guide me .
currently having E/error: net.sourceforge.jdts.jdbc.Driver, any idea?
same, did you fix yours? how did you fixed? can you share it. Pls
@@dummysecond2787 done, i already fixed mine. share to me ur email i sent the code for the db connection
@@muhammadsyafie4248 (second dummy0) my g-mail acc. No spacing. I comment so many times but always deleted :(
@@muhammadsyafie4248 send me your email too. I will message u thank youu!
@@dummysecond2787 done email, just replace ur main activity file
Thanks man!!
Happy to help!
If I create multiple screens and only execute the connection function on Mainactivity, will the database be accessible
from other activities?
Hello sir, I am trying to program android, but it is very difficult to find resources. Can I ask you a question, especially regarding SQL server transactions? Do you have any ideas on how I can get the total values of records between 2 dates?
how can i get your source code ...but you did it everything thank you al ot
Hello friend. I already have a database on hosting and how can I connect to it. Please help me
Thanks for your question. You may use real ip instead of local ip. I will make such tutorial very soon. Please wait
Thanks for this tutorial, Login user into app please ...
Thanks for your comment. I will
12:15 Sir, in the line 24, how can I get the MS SQL Server ip?
IP is the PC IP address where SQL server is installed.
Can we use xampp server for SQL
Please try and let me know!
Is there any other thing needed to connect to database
I have done all the things in this video but my connection have not been setup maybe u can help...!!
Check your SQL Server port no. Default port no is 1433. If it change in your sql server then put that one. to get port no- go to SQL Server Configuration manager. right click on the TCP/IP and go to the Property scroll down and see the port no. Thanks
thank you so much sir
Do you have an example of how to connect with Azure?
Hello. First of all, thank you for this tutorial. It helped a lot! Thanks.
On the second hand: Could you help me with, what should I do to connect my local database from a real device? I always get "connection refused" error. I know it could be the firewall, but can you help me, how could I allow the connection?
i have the same problem please help
@@rivaldovola9896 I've found the solution. :)
1.) Go to the Control Panel
2.) Go to System and Security
3.) Go to Windows Firewall
4.) Now go to Advanced Settings
Okay now you should import new policies for inbound and outbound rules.
1.) Select Inbound rules
2.) Click New Rule
3.) Select Port and then Next
4.) Now give your port which was 1433.
5.) Now press Next until you reach the final chapter.
6.) Give a name for the rule. (It can be anything)
Okay, the inbound rule is done. Now you need to do the very same thing with outbound rule. Just be "careful" at the chapter named Action select the "Allow all Connection" option.
I hope it helps :D
Thanks
I struggled with getting my physical phone to work, but finally got it to work when I enabled port forwarding on the *router's* 'firewall status' section (to my laptop within the router's LAN) as well as on my laptop's firewall (laptop is on a Home WIFI), to make port 1433 open on my laptop's IP address. Hope this helps someone struggling with this.
I am facing same problem how can I resolve it
@@patd7352
Very helpful bt.
But how can I call procedure, function ,from sql server instead of writing query in android studio . Please help me.
Good idea. I will make such tutorial very soon. Thanks
@@ProgrammingGeekI'm waiting .. I'm waiting .
I want use SQL server with android completely. I'm web developer .Use .Net c# with SQL server. So I want my web application in android using SQL data Base. Please make video. Thnx for responding
@@technosmart2435 Thank you too to be connected with me.
Hi sir , I haven't any error but after i inserted any value in android studio it is not inserting in Database.
please Help me sir.
Hey man! I loved the video and found it very helpful, But there is one problem, I do not know how to find the ip address of the server, can you please tell me how to find the ip address of the sql server? Thanks in advance
IP address is in PCs, if your computer is in local network, you must have an IP Address. To get IP address of the server go to the ethernet settings. double click on LAN icon. You can use SQL server name instead of IP Address. Thanks.
You can do a complete project on human resource management android app connected to sql server. And has all the functions. Combined with RadioButton, Switch, Date May. I really need them. Please! I am an amateur.
And maybe County, district. Retrieved from database for selection in insert.
Good, thankz
Thank you too for your valuable comment. Please keep in touch.
could you do the same with azure data base? so far there is no one to show it on video
Thanks man. This video so great that you have show data from SQL to textview in app Android. But now 09/ 2021, I have try many way, it really not workings that when I click button, no event listener appears.And I have connect check login from android to sql but it not working. Can you help me? Can I have link your Facebook to ask you? Thanks you a lot, I will be grateful you. Hope you reply my answer.
E/Error: The executeQuery method must return a result set.
It is possible to do the same but using PostgreSQL database instead of SQL Server?
Thanks, is this also working Xmap?
I have tried this on Xamp and it doesn't work huhu
Quick question, if i build the app on my phone and disconnect phone from PC, will the database be accessed and how ?
Late response but the answer is yes. The mobile phone and the laptop you are using are both needed to be in the same connection. To connect them to each other, you may use a single internet provider or just connect your phone through the mobile hotspot of your laptop.
Hi, is it possible to accept null values for the CRUD Operation?
Please try.
Can I search data by I'd?
Plz reply
Sure, you can. watch this tutorial ruclips.net/video/-vca9x_d28U/видео.html
I receive this error
Network error IOException: Connection refused
how to make the android app with sql server
work offline such as whatsapp
host the database and put real ip in connectionstring. thanks.
@@ProgrammingGeek I have hosted Sql Server database and i can connect to it normally . now i need to create SQLite as local database and make sync between SQLite and remote sql server in android studio
hello! how to code that if I use xammp phpmyadmin
I have develop water application which is run on localhost sql server. If install apk directly the conection string is working successfully that means i can login. But if i install apk via play store i can not login. Can any one help me about this. Please please
Try with real ip instead of local ip. Thanks
pls code file activity_main.xml
Code is added in the description. Please check!
hello
Send me a link github
Not added in git hub. I will try.
Hi Programming Geek, I want to know if we can use the Server Name rather than the IP Address to connect to SQL Server?
Your reply would be really appreciated. Thank you!
Hello genius, Please try yourself and let me know. thanks🌷🌷
I've already tried it but no success. Already found another solution for my problem.
Btw, thank you for replying.
Does not work sir
Check your connectionstring. you can copy from description box. Check you SQL Server Port no. thanks