|
HI,
i m trying to save value in access database,can i do this if yes then how can i implement.
thanx in advance
|
|
|
|
|
do u means to insert data into access db.
try and try untill reach success..
|
|
|
|
|
yes
i can do in sql server,but i want to MsAccess Db.
is it possible? how can i do?
|
|
|
|
|
|
Firstly u add <appSettings> tag in web config file
attach data base
<appSettings>
<add key="ConnectionStrings" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}"/>
<add key="dbfile" value="~/App_Data/data.mdb"/>
</appSettings>
then after
Pro = ConfigurationManager.AppSettings["ConnectionStrings"].ToString();
MyPath = ConfigurationManager.AppSettings["dbfile"].ToString();
Conns = String.Format(Pro, HttpContext.Current.Server.MapPath(MyPath));
con = new OleDbConnection(Conns);
con.Open();
string st = "Madhaya Pradesh";
string qql = "INSERT into Registration(UniqueID,Name,FName,DOB,TMarks,OMarks,PMarks,PClass,PLine,Board,District,Division,Category,Sex,PChallange,Address,Pin,RDistrict,State,Phone,SchoolAddress,SchoolPincode,SchoolDistrict) values('" + lbluniquid.Text + "','" + txtname.Text + "','" + txtfathername.Text + "','" + tbMyDate.Text + "'," + txttotalmarks.Text + "," + txtobtainmarks.Text + "," + p + ",'" + rdpresent.SelectedItem.Text + "','" + rdpovertyline.SelectedItem.Text + "','" + rdboard.SelectedItem.Text + "','" + ddldistrict.SelectedItem.Text + "','" + lbldivision.Text + "','" + rdcategory.SelectedItem.Text + "','" + rdsex.SelectedItem.Text + "','" + rdphysically.SelectedItem.Text + "','" + txtaddress.Text + "','" + txtpincode.Text + "','" + ddldistrict1.SelectedItem.Text + "','" + st + "','" + txtcontact.Text + "','"+ txtschooladdress.Text +"','"+ txtschoolpincode.Text +"','"+ ddldistrict2.SelectedItem.Text +"')";
cmd = new OleDbCommand(qql, con);
int res;
res = cmd.ExecuteNonQuery();
res = 1;
con.Close();
prabhakar
|
|
|
|
|
This code useful for u..
firstly add <appsettings> tag in web config
<appSettings>
<add key="ConnectionStrings" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}"/>
<add key="dbfile" value="~/App_Data/data.mdb"/>
</appSettingst>
After then
Pro = ConfigurationManager.AppSettings["ConnectionStrings"].ToString();
MyPath = ConfigurationManager.AppSettings["dbfile"].ToString();
Conns = String.Format(Pro, HttpContext.Current.Server.MapPath(MyPath));
con = new OleDbConnection(Conns);
con.Open();
string st = "Madhaya Pradesh";
string qql = "INSERT into Registration(UniqueID,Name,FName,DOB,TMarks,OMarks,PMarks,PClass,PLine,Board,District,Division,Category,Sex,PChallange,Address,Pin,RDistrict,State,Phone,SchoolAddress,SchoolPincode,SchoolDistrict) values('" + lbluniquid.Text + "','" + txtname.Text + "','" + txtfathername.Text + "','" + tbMyDate.Text + "'," + txttotalmarks.Text + "," + txtobtainmarks.Text + "," + p + ",'" + rdpresent.SelectedItem.Text + "','" + rdpovertyline.SelectedItem.Text + "','" + rdboard.SelectedItem.Text + "','" + ddldistrict.SelectedItem.Text + "','" + lbldivision.Text + "','" + rdcategory.SelectedItem.Text + "','" + rdsex.SelectedItem.Text + "','" + rdphysically.SelectedItem.Text + "','" + txtaddress.Text + "','" + txtpincode.Text + "','" + ddldistrict1.SelectedItem.Text + "','" + st + "','" + txtcontact.Text + "','"+ txtschooladdress.Text +"','"+ txtschoolpincode.Text +"','"+ ddldistrict2.SelectedItem.Text +"')";
cmd = new OleDbCommand(qql, con);
int res;
res = cmd.ExecuteNonQuery();
res = 1;
con.Close();
|
|
|
|
|
if javascript is disabled on the client browser is it posibble that ajax will still work. i mean xml http requests will be posted to server.
|
|
|
|
|
No. AJAX is just a particular use of javascript.
I am not sure but there are a few a hacks available with GreaseMonkey for FireFox, but in general the answer is NO.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
YEs exactly if htere is no javascript . there is no ajax.. in the common terms.
try and try untill reach success..
|
|
|
|
|
Hi Rajeshwar,
If you reply me, the OP does not get notified. Its always better that you reply to the OP so that he know he has an answer.
Btw, you are 100% right.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
No, javascript is mandatory for AJAX and must be enabled on browser.
|
|
|
|
|
We have a report in html Table form. When he gives print, say the table would take 5 papers to print, he wants the table headers in all pages. How to do this.
|
|
|
|
|
|
Thanks for your reply.
But, i am not using reporting services.
I am getting data from SAP and from there i am just placing them in labels inside a table format in my webpage.
And, when i take print of this webpage, i need header text in all printed pages
|
|
|
|
|
Sorry ! Presently i working with ssrs thts y i gave u the link .
SUDHAKAR PALLAM wrote: I am getting data from SAP
i Have No Idea
If It Helps Click It as Answer
|
|
|
|
|
Does anybody have knowledge of how to implement Bitkoo Keystone with ASP.Net 2.0
Best Regards,
Mini Thomas
|
|
|
|
|
Hi Mini,
To use the BiTKOO Keystone Auth component do the following:
1. Add a reference to it and then create a variable such as auth1 and instantiate it
2. Set the ApplicationId property to an application you create in the admin app
3. Set the PrimaryAuthUrl to the URL of the Keystone auth web service
4. Optionally set the SecondaryAuthUrl to the same or different auth web service
5. Call the auth component instance's Login method. There are several overloaded methods.
You can call like this: auth1.Login("bitkoo", "username", "password")
Make sure to substitute username and password for their correct values.
The above steps allow you to authenticate. The Login method returns true if the user you specified in username has at least one role in the application.
You can store the auth instance in the session and re-hydrate it on every page load.
Since the authorization metadata is now cached in the auth component, you can call one of the auth component's methods to check whether a user has access to a resource. Consult the manual for a list of methods.
If you need more information, BiTKOO is always happy to provide fanatical support. Just send an email to support@bitkoo.com
|
|
|
|
|
Hi DGrinstein,
Thanks for your reply, really apppreciate your help!
I am able to Authenticate by using AuthComponent however it is the authorization part especially the KeyStone Role Provider that we are not able to explore.
I found out that not all the methods are implemented in Keystone for the UserManagement module.
for e.g GetAllRoles(), AddRole() etc
As an alternative we are calling the webservice directly for accessing these methods.
My question is there any other alternative way in which Keystone exposes its UserManagement methods so that we can call them directly rather than accessing through web service?
Best Regards,
Mini Thomas
|
|
|
|
|
I see what you need. Yes, we have an ADMIN component that abstracts the calls to the web service. It allows making role management tasks and other administrative tasks very quick and easy. You can obtain the admin component, just send an email to eric@bitkoo.com and ask him to send you the admin comp.
thanks!
|
|
|
|
|
hi
I am working for fingerprint. The fingerprints are stored in database in binary formate and that file is RAW file. I have to show it in form as image .
so how can i do this.
Any one help me .
Rajeev Kr. Sharma
Sr. Software Engineer
E-Meditek Solutions Ltd.
http://www.emeditek.co.in/
|
|
|
|
|
Dim fs As FileStream
Try
fs = New FileStream("C:\Inetpub\wwwroot\xyz.jpg", FileMode.OpenOrCreate, FileAccess.Write)
Dim l As Long
l = UBound(bytes)
fs.Write(bytes, 0, l)
Catch ex As Exception
Finally
fs.Close()
End Try
here bytes is a byte array which holds the binary data from the databse
after that assign the file name to ur image control.
|
|
|
|
|
sorry this is not working.
the binary data which is stored in database that type is raw file
Rajeev Kr. Sharma
Sr. Software Engineer
E-Meditek Solutions Ltd.
http://www.emeditek.co.in/
|
|
|
|
|
I don't think you can directly render a raw file as an image in HTML. You are going to need to transform that .RAW file into a .jpg or something else that is readable by a web browser. I would look into possible using the SDK provided by Canon or maybe Nikon. Beyond that, and not knowing anything about the RAW file (each RAW format is different, it isn't standarized from my understanding)
|
|
|
|
|
Normally when storing images in databases blobs are used. Simply load data in memory stream and then create bitmap object from that stream, save a temp image and built a URL to that new temp image and then anchor it on desired location.
|
|
|
|
|
how to generate image by byte could you give me the code.
because i have tryed it by different ways.
Rajeev Kr. Sharma
Sr. Software Engineer
E-Meditek Solutions Ltd.
http://www.emeditek.co.in/
|
|
|
|
|