How insert data in Database MS access Through User Defined GUI

Question

shery khan 2015-3-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/195015-how-insert-data-in-database-ms-access-through-user-defined-gui

编辑： Geoff Hayes 2015-3-29

can any one tell how to insert data in database through GUI like making some Edit text boxes and Button in GUI and When User click the All Data Is saved in Database please tell me For MS access Database i do this in Under Button

 conn = database('MMU2', 'sherykhan', 'shery')
 colnames = {'ID','Country'};
 edata={user_string1,user_string2}
 get(conn, 'AutoCommit')
 insert(conn, 'ac_iris', colnames, edata)
 close(curs)
 close(conn)

and this in two Edit text boxes

user_string2= get(hObject,'String');
user_string1=get(hobject,string);

please tell me the Way i need that when User Will Enter some Data in Edit boxes the Data is Submitted to Database MMU like . i am usin Matlab R2010a Version

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Geoff Hayes 2015-3-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/195015-how-insert-data-in-database-ms-access-through-user-defined-gui#answer_173063

在 MATLAB Online 中打开

Shery - use GUIDE to create your GUI with two edit boxes (named edit1 and edit2) and one push button. Then, in the callback to your push button, you can reference the edit boxes using their handles. Something like

 function pushbutton1_Callback(hObject, eventdata, handles)
 user_string1 = get(handles.edit1,'String');
 user_string2 = get(handles.edit2,'String');

then continue with your connection to the MS Access database. See here for details on how to connect with ODBC.

8 个评论
显示 6更早的评论隐藏 6更早的评论

shery khan 2015-3-28

编辑：Geoff Hayes 2015-3-29

在 MATLAB Online 中打开

sir thanks sir for your reply but which you have Refer i can read it and do it i am using R2010a Version Kindly Guide Me What Error in this Code is

function pushbutton1_Callback(hObject, eventdata, handles)
% hObject    handle to pushbutton1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
s=oledbcnstr('Access',[],'MMU2.mdb');
cn=oledbcn(s);
cn=database('Access','','');
ID=get(handles.ID,'string');
country=get(handles.edit2,'string');
Nationality=get(handles.edit3,'string');
Region=get(handles.edit4,'string');
Age=get(handles.edit5,'string');
gender=get(handles.edit6,'string');
Enviroment=get(handles.edit7,'string');
data={ID country Nationality Region Age gender Enviornment}
col={'ID', 'Country' , 'Nationality', 'Region', 'Age', 'gender', 'Enviroment'}
insert(cn,'ac_iris',col,data);
msgbox('record Saved Sucessfully?','save','warn');
close(cn);

shery khan 2015-3-29

编辑：shery khan 2015-3-29

在 MATLAB Online 中打开

Now Error in oledbcn.m

if true
??? Error using ==> oledbcn at 60
Could not create connection. See troubleshooting
above.

Error in ==> intialpage>pushbutton1_Callback at 221 cn=oledbcn(s);

Error in ==> gui_mainfcn at 96 feval(varargin{:});

Error in ==> intialpage at 42 gui_mainfcn(gui_State, varargin{:});

Error in ==> @(hObject,eventdata)intialpage('pushbutton1_Callback',hObject,eventdata,guidata(hObject))

60 error('Could not create connection. See troubleshooting above.') K>> end

thanks sir your kind help will so Good now tell me Error in insert .m as you previously say that i can add files oledbscntr and other files in my path without editing or change them but now error so please kindly tell me what to do now Thank you So Much sir your Guide lines are so Good for me

Geoff Hayes 2015-3-29

编辑：Geoff Hayes 2015-3-29

Unfortunately, shery, the error information that you provided is not enough to determine what the problem is. Have you changed your code, and if so, to what? oledbcn appears to be a function that you have not referenced before. How are you calling this function? What are the inputs?

请先登录，再进行评论。