Comments by Mantu Singh (Top 93 by date)

Simple edit the query like date='2015-05-19'

Your IP address has a dot in the end remove and try connecting

Pray tell me why is it impossible

what are columns of your table ?

welcome !!

how have u saved the image in folder in database?

my sample code works just fine

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SKTConnectionString %>"
SelectCommand="SELECT * FROM [CLIENT_DET_SMRY]">
<asp:Button ID="Button1" runat="server" Text="Next" onclick="Button1_Click" />

<asp:GridView ID="GridView1" runat="server" Height="168px" Width="322px">

<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Button" />

Select the Sql data source & see its ConnectionString property like
Data Source=sqlserver;Initial Catalog=DB;User ID=sa;Password=password

if not click small arrow top right corner of sqldatasource & Configure datasource...

have you configured sqldatasource properly

try removing If IsPostBack = False Then
because when u click button page is posted to server got it!!

Man u can't expect someone to do whole work for you you have books internet teachers friends...

Dim I as integer=sql.ExecuteNonQuery()
Msgbox(I)
See value it must be >0 for successful insert

Code pls

I have worked using ado.net code on several access based project but this time I plan to save coding by using components created by Vstodio and do in one line which manual coding requires10 lines. And this data deletion prob is quite nagging since morning then only I posted it
Anyway thanks for or help

if U can do it in sql server you can do it in Oracle

Web config file does not have connection string it worked automatically

Dear sir i install ajax extension and used scriptmanager and updatepanel as shown in link but the problem is same when i click other button the button in updatepanel disappear

further only one button is added even if i click end exam button 10 times to add 10 buttons

pls help!!

are null values allowed on the date column of the database..........

so what's the problem ?

To delete you can use
ds.Tables[0].Rows[0].Delete(); //delete first row
ds.Tables[0].Rows[1].Delete(); //delete second row

Pls be kind to accept the answer too ! welcome

You need to create a byte array as I hope in the database you column datatype will be varbinary or image where you need the bytes of image

byte [] img=File.ReadAllBytes("image name");

Add(New SqlParameter("@Photo",img));

Remove semicolon as it wont work in VB

read all database of sql server in my application of vb.net in combo box ;-)

Have you tried something yet!! sounds like H/W

updated the solution!!

Use comment under question to elaborate or further query Do not post your query in solution!!

Try improving the connection string!!

yes u can!!

Thanks a lot sir!!

Thanks a lot Got it!
One doubt pls
cout << sum(5,4,6) << endl; //5 -no of args still runs with
//junk value like4245556

Is there any clearer type safe way to do this like
param arrays in C#

thanks a lot sir for reminding the mistake but I only wanted to run the code and see if i would be able to help and i found index out of range exception on first run.........

using treeview might not be good choice as you need to add child nodes dynamically leaving the evnt handling to be followed use this link may be this helps
http://www.codeproject.com/Answers/271528/Treeview-every-next-number-should-be-child-of-Prev

mention column names of both tables and what columns you want in the output then the query could be framed properly.........?

Sir;
Pls add using System.Diagnostics;

on the top...............

Pls post code where you got error.......!

Try this........
where is one more connection string code......?
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Soure=|DataDirectory|\Schooldb.mdb");

pls post the code for both connection strings you use...........

Crash has come.....? Pls elaborate

Thanks a lot!

a pretty tough task u r onto u need lot of expense hardware leave along software....(plus compete with giants like google ?)Anways keep trying Best of luck.......

Thanks for reply sir!.....
Nice article
So there is no way out...?
Actually I need to give this app to operators for data entry after which
collect it back and merge it on single database.......

i wanted that operators may not see the MDB file and mess with eg. copy data from it
(password is not enough it can easily be cracked by free tools) so i thought of embedding it in exe itself

In properties window.........

pls be more clear.....

Sry now I hv updated the answer
After adding progress bar ensure that enabled is set to false
best of luck.....

pls elaborate more as to what prob u face

Sire! Pls mention type of pressure u would like to measure...
1)Atmospheric ?
2)Blood pressure ?
3)underwater ?

: D

U r welcome......!

Doe sthis happen in prog or SSMS(I hope)
Some Msg level,Line no might appear with the error pls bestow ur kindness to specify it.....seeing the length of code

U r welcome.........!

I hope windows services run automatically after deployment when system starts.........

U r welcome...........!

pls give more info code where you encounter the error so we may be able help u

Pls elaborate more............

Thanks a lot sir.....

Thanks a lot sir.....!

Reason for my vote of 1
looks like HW!

Welcome;
use following

string path=Application.ExecutablePath;

Is you data grid empty....?
if not you are passing null value to parameter
I noted a line above in u r ques

try this

cmd.CommandText = "Insert into table2(aa,bb) Values(@firstname,@lastname)"
cmd.Parameters.AddWithValue("@firstname",val1)
cmd.Parameters.AddWithValue("@lastname",val2)

Thanks for guidance .......
Some complex out of way methods were given on various sites this one simple enough........
This didn't help FALILA may be but helped me

Regards;

Dear sir;
I tried to change color of progress bar other than default green once for a project but after lot of hassles couldn't do it even through back color property....

Some help will be greatly appreciated as how to achieve this effect
Regards;

Thanks Sir;

But the simple library i have is a simple class with public method if I skip renaming will the Class be obfuscated keeping its name for usability

Thanks Sir;
Your suggestion is worth having
But I m doing this for my knowledge

My Purpose is to use library after obfuscation and see that it works well
when we add reference to other project.

i want the code to be secure but classes and methods defined be usable too.

What prob r u facing
we r not able to see the project so if you need answers please put question in details and if some code as required.........

try combobox1.selecteditem.tostring() this may work or may be some prob with connection string.......

thanks at last i got some scripts from a friend Thanks for help

thanks at last i got some scripts from a friend Thanks for help

pls elaborate the detail if any code or error you face......?

I tried the same but can't find such option in SSRS project however posible in Crystalreports

Is ReportDocument1 object of CrystalReport added to project and can we adjust page size /orientation at time of designing the crystal report if yes how...?

Did you get any exception or error like Dynamic generation of Sql Command is not supported when query does not have key column information IS tableView a DataAdapter?

Before attaching the database u need to ensure it is on writable media like hard disk otherwise you wont be able to update any data......

use vbscript or javascript to achieve this ......

you can go microsft site and search for instructions to upgrade sql server installation maintining old databases..
But pls backup the database before doing anything......

please clarify more.....?

pls clarify more whether you want to search in the data grid or database

You may think of using crystal report to do the job instead of doing overhead of linking to word you have option to save report to various formats (excel word pdf) etc

I think you are not seeing sample databases or even worse SSMS is not to be seen; Sql Server setup is a bit tricky try seeing any manual or someone experienced with SQl installation Best of luck....

logging in to server with sysadmin role you have privilege over all database objects this may not be possible with a limited role account Best of luck......

Thanks for updating got to learn little VB

Nice Answer...
Being lazy I would use..
foreach(Process pcs in p)
{
MessageBox.Show(""+p.Name);
}

Agree totally doing simple entry in registry is better than loading a service in the system my 5!

Use registry just set the installer to do that entry for the application you need to run its simple enough or use Microsoft.Win32.Registry class for you purpose.....

Nice details my 5!

Thanks a lot......! that worked...

try to use Access 2002 data file format for better results
OleDbType.Date) may sometimes cause problem try using varchar instead
The format of date is not fixed in acces ;means if you insert 20/10/2011(d/m/y)
if ur system regional setting changes to(m/d/y) it automatically changes in table to 10/20/2011 so check that..........best of luck

the col1,col2 etc must match the table columns
the order you give in columns you need to add parameters in same order

Try to use this @ symbol in parameter name............
cmd.Parameters.Add("@user_id", OleDbType.VarChar).Value=userIDBox.Text;
check insert statement according to columns you need to insert no of ? mark must be equal to no of columns for which you insert data

Thanks a lot ! that worked

please clarify the question and provide details.......